Why I Go to Summit Each Year?
This year will be my 6thPASS Summit that I will have attended. Some people have asked me why I still...
2017-10-11
327 reads
Identity_Cache feature introduced in SQL Server 2017
Hello friends, Please find the full article at this link – https://social.technet.microsoft.com/wiki/contents/articles/40666.sql-server-identity-cache-feature-in-sql-server-2017.aspx
2017-10-11
482 reads
SQL Server Temporal Tables
Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level...
2017-10-19 (first published: 2017-10-11)
2,104 reads
Avoid “Constants” in T-SQL
Unlike some other languages, T-SQL doesn’t have the concept of a constant.
As good coders, we’ve all at some point tried...
2017-10-19 (first published: 2017-10-10)
3,679 reads
How NOLOCK Will Block Your Queries
Photo by James Sutton on UnsplashNote: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK...
2017-10-10
396 reads
How NOLOCK Will Block Your Queries
Photo by James Sutton on Unsplash
Note: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK hints. The fact that it applies to NOLOCK queries...
2017-10-10
22 reads
Kill a Connection, Session, or Command in Analysis Services
One of the useful features of the SSAS Activity Monitor is the ability to cancel sessions and queries. Though there is...
2017-10-10
3,204 reads
Microsoft Ignite US 2017 – Major Azure Announcements
[read this post on Mr. Fox SQL blog] Microsoft Ignite is probably the biggest technical event that Microsoft host yearly with many major announcements across the entire solutions portfolio suite –...
2017-10-09
22 reads
Microsoft Ignite US 2017 – Major Azure Announcements
[read this post on Mr. Fox SQL blog]
Microsoft Ignite is probably the biggest technical event that Microsoft host yearly with many major...
2017-10-09
456 reads
Using xp_delete_file
First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions,...
2017-10-09
1,261 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