Good news! I’m speaking at SQL Saturday 42 this Saturday. Got nothing to do? Head on down to Goodwill Columbus at 1331 Edgehill Rd, Columbus, OH. Got something to do? Cancel it.
I’m excited about the presentations I’m giving – I haven’t given the indexing presentation in a long time and it should be a lot [...]
Ever have a database log file grow to epic proportions on the weekend? I have. Ever forget to set up job monitoring on that server? I have. Ever get so pissed off that you decided to write a job to automatically shrink the log files whenever they grow? I have.
I’m going to be speaking at a few events in April. I bet you want to come visit and hear the crazy sounds that I’m going to be making!
Thursday April 8th – Columbus, OH
Fundamentals of SQL Server Internals
The Abstract: Want to know what makes SQL Server tick?
Ever wonder what SQL Server is doing when you [...]
SQL Server
Denis Gobo provides a double dose of dynamic SQL hotness via Changing exec to sp_executesql doesn’t provide any benefit if you are not using parameters correctly and Avoid Conversions In Execution Plans By Using sp_executesql Instead of Exec. Following his tips in here will net you some considerable benefits in how your dynamic SQL [...]
I frequently find myself having to perform calculations on the source data based on a range of user supplied values. Usually there will be some kind of target and destination parameter supplied. So, for example, the users will want to see total sales in terms of burgers sold or something like that. Here’s where it [...]