Archive for September, 2011
SQL Server Features for Developers: What you should be using and why
Date: September 23, 2011 Location: Jones Day Abstract: You know about CLR and T-SQL functions like PIVOT and DENSE_RANK().В But what about those features built into the SQL Server engine itself? We’ll discuss database snapshots, data compression and Service Broker, examining how each works and, most importantly, the where and why you should use them. [...]
September 29, 2011
Posted in: Events 
No Comments
Who Dropped My Table?: A Quest for the Perfect DDL Audit Solution
Date: October 4, 2011 Location: Ohio North SQL Server User Group Abstract: Who altered this view and how? When was this index created? What happened to my stored procedure? From SQL Trace to SQL Audit, this session documents this woman’s quest for the Holy Grail of DDL Auditing. Level: Beginner
September 29, 2011
Posted in: Events No Comments
SQL Server A to Z – OPENQUERY
Good morning SQL people! It’s time for another installment of SQL Server A to Z.В We’re up to the letter O, which immediately brings to mind the song from Sesame Street, “Would you like to buy an O?”В (Circular and sweet. “O” looks just like a donut. Really good enough to eat…) You’re welcome. OPENQUERY [...]
September 29, 2011
Tags: a to z, linked servers, openquery Posted in: T-SQL No Comments
My first presentation – a recap
For those of you following along at home, you’ll recall that my first presentation was scheduled for this past Friday.В We have a regular developers’ forum at work where employees or outside vendors will talk about some new technology or something they’re working on.В Being a DBA in a department of developers, the subject matter [...]
September 26, 2011
Tags: presenting Posted in: Professional Development 2 Comments
SQL Server A to Z – NUMA
Back to our ABCs for a bit. Today we’re talking about Non-Uniform Memory Access, aka NUMA. What is NUMA? Once upon a time, servers only had a few, relatively slow processors. And these processors all used the same shared memory bus to access system memory. But because there were so few processors and because they [...]
September 22, 2011
Tags: a to z, NUMA Posted in: Features No Comments
