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
672 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,265 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
611 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,146 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
827 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
621 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
722 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,580 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers