I’m Going on Tour
I’ve done quite a bit of speaking over the last few years, which has required a lot of travel. I...
2012-06-01 (first published: 2012-05-30)
2,271 reads
Blog Posts
June Question: Which DMV(s) do you most often use when managing your SQL Server instances, and why?
Dynamic Management Objects (DMVs and DMFs) are some of the most useful tools for the DBA. So this month’s question...
2012-06-01
1,031 reads
Ottawa In the Summer Time
I wrote a post earlier this week telling you all about my trip to Ottawa last week, during my trip...
2012-06-01
872 reads
Setup windows firewall for SQL Server
On Windows 2008 R2, the windows firewall will turn on by default which causes connection issure for the remote client, here...
2012-06-01
5,408 reads
SQL Server 2008 Security Best Practices
If you are working as a DBA for a financial organisation where sensitive financial data is stored in your databases...
2012-06-01
13,324 reads
The SQL in the City US Tour
If you haven’t heard yet, Red Gate Software is sponsoring a six city tour of the United States of its...
2012-06-01 (first published: 2012-05-29)
1,787 reads
The Standing Desk – Week 1
I finally got my standing desk working last weekend and started on Tuesday (after Memorial Day) working at it on...
2012-06-01
1,117 reads
A new neat feature in SQL Server 2012 is THROW
In SQL Server 2005 we got the TRY…CATCH construct which was a big help for developers to effectively handle errors...
2012-05-31
3,341 reads
After August, I'm Done Traveling for the Year
I mentioned in a post over at my Goal Keeping DBA blog that I was not planning to attend the...
2012-05-31
2,112 reads
Building a SQL Server Inventory – Part 1
Ok folks, you asked for it. Well, a few of you did, anyway. So today I’m going to share with...
2012-05-31 (first published: 2012-05-29)
5,942 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