Who’s doing what to your SQL Server?
When doing any kind of troubleshooting in your SQL Server first thing you ask is who is currently connected to...
2013-08-24
673 reads
When and why you should use 1=1 in WHERE clause?
One Interviewer ask this question during interview of my friend.It is easy to answer but need some specific and to...
2013-08-24
1,266 reads
Authority as the Enemy: Notes on elections and perceptions in the tech community
Let’s hear a story. The story is true, but elements have been generalized and fictionalized for simplicity, and so’s not...
2013-08-23
614 reads
Decisions, Decisions. Fall Events
I was looking over my travel calendar this fall, and I’m somewhat amazed at the variety of events that are...
2013-08-23
1,147 reads
Reblog: August 16 to August 22
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-08-23
828 reads
Notes From The August 2012 OPASS Meeting
Luis Figueroa did a nice job presenting on Master Data Management. It’s nice to see the tools evolving, though I’ll...
2013-08-23
622 reads
SQL CAT is on the Move
Not a big deal really, but they’re consolidating from the SQLCAT.COM to put everything on MSDN.
Read all about it here.
I...
2013-08-23
742 reads
Specify the Parameter Names for Stored Procedures
I just ran across a case where a script was failing. Here's the part that's failing:
EXEC sp_addrolemember 'MyDomain\MyGroup', 'SomeRole';
GO
Do...
2013-08-27 (first published: 2013-08-23)
4,494 reads
2013-08-23
723 reads
SQL Server 2012 RTM CU9
On August 20, Microsoft released SQL Server 2012 RTM Cumulative Update 9, which is Build 11.0.2419. I count seven fixes...
2013-08-22
1,586 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers