How to Drop One Plan from Cache
While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it),...
2012-06-07 (first published: 2012-06-04)
3,329 reads
Blog Posts
PAGE_VERIFY – Checksum vs. Torn Page Detection
All this talk of testing backups and data integrity and checksums has me thinking that maybe now would be a...
2012-06-07
10,812 reads
Do You Know An Exceptional DBA?
Do you know a DBA that saves the day time and again? Or one that doesn’t need to save the...
2012-06-06
984 reads
Getting started with SQL Server on private cloud
I have been invited to a private beta of SQLDirector by ScaleGrid. “SQLDirector is a MS SQL as a Service...
2012-06-06
1,534 reads
Just another SQL blog
I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. The internet...
2012-06-06
594 reads
On Break
I’m at Orlando International as I write this, about to fly to Parsippany for meetings today and tomorrow, then back...
2012-06-06
630 reads
Optimise Your Disk Subsystem I/O with An Index File Group and Index Compression
As a DBA who is always seeking solutions to performance bottlenecks, amidst the
daily rituals of validating backups and other regular...
2012-06-06
1,687 reads
Powershell Add-Type – Where’s That Assembly!
I’ve been working a lot lately with SMO and the differences between the various versions between SQL 2005, 2008, and...
2012-06-06
17,453 reads
Presenting Tips
Having done a number of presentations, I have accumulated a list of items to go over before each presentation to...
2012-06-06
1,159 reads
SQL Server Configuration Manager : Cannot connect to WMI provider – Invalid class [0x80041010]
Following error dialog pops up today, when I tried connecting to SQL Server Configuration Manager on my SQL Server 2008...
2012-06-06
25,001 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries
The Service Name
Comments posted to this topic are about the item The Service Name