Winner of the worst recruiter of the year!
Every week I get a bunch of emails from recruiters about jobs that I am not qualified for (see Low-rate...
2013-08-27
1,147 reads
Check Your Azure Account Usage
It is absolutely not cool or fun to pay money to learn new technology. One of the main complaints people...
2013-08-27
789 reads
SharePoint SSRS “The permissions granted to user ‘Domain\User’ are insufficient for performing this operation”
Not too long ago I ran into a crazy situation where just about everything that could have gone wrong with...
2013-08-27
1,578 reads
How to Tell If Your Users are Connecting to the Availability Group Listener
You've spent a lot of time planning and building out a new SQL Server 2012 environment complete with Availability Group...
2013-08-29 (first published: 2013-08-27)
2,428 reads
Query Stats
DBAs rarely use the full potential of sys.dm_exec_query_stats. It’s common to see the queries for looking at the most expensive...
2013-09-04 (first published: 2013-08-27)
3,760 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.2: Writing a Bare Bones Plugin Algorithm
By Steve Bolton
…………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one...
2013-09-02 (first published: 2013-08-26)
2,777 reads
SQL – Identify & Drop Duplicate Index
This post explains the simple steps to identify a duplicate indexes in all the databases. The duplicate index are more than...
2013-08-26
892 reads
SQL Saturday 223 OKC
This past weekend I made the relatively short (about 3 hours) trip to the Oklahoma City area to attend and...
2013-08-26
812 reads
Backup Your Certificate for TDE
If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database...
2013-09-03 (first published: 2013-08-26)
1,871 reads
Last Weeks Top “Reading” Links #46
It’s Monday, it’s time for weekly round-up #46. As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the...
2013-08-26
769 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