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. […]
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
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 […]
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 […]
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 […]
