Natively compiled user-defined functions
One new thing that SQL Server 2016 has added is the ability to natively compile user-defined functions. Previously, native compilation,...
2016-01-19 (first published: 2016-01-12)
4,252 reads
Blog Posts
New SQL Blogging Challenge
I recently came across Tim Ford’s (B|T) challenge to the technical blogging community. The challenge is to write one introductory...
2016-01-19
410 reads
Shrinking Database Data Files
Normal DBAs will sum up shrinking a database data file in one word: NO! I’ll talk to you about this subject because I’m not normal. Still, my goal is that...
2016-01-19
48 reads
Shrinking Database Data Files
Normal DBAs will sum up shrinking a database data file in one word: NO!
I’ll talk to you about this subject because...
2016-01-19
1,701 reads
Stop using Task Manager to check SQL’s memory usage!
There’s two fairly common questions I see on the forums around SQL Server’s memory usage. Either the question asks why...
2016-01-19
2,020 reads
Ad-hoc Changes
TSQL Tuesday #74: Be The Change
Each month, on the first Tuesday of the month, the announcement for the blog...
2016-01-18 (first published: 2016-01-12)
1,537 reads
Disabling SQL Server Network Protocols
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-01-18
1,089 reads
Five Years, A Quiet Quarter, A Look Ahead to 2016
Five Years of Blogging
From to My blogging story started on December 7, 2010. I have now had a blog for...
2016-01-18
522 reads
Getting Started with Change Tracking in SQL Server
Change tracking for SQL Server is a flexible and easy-to-use technology for monitoring tables for inserts, updates, and deletes. In...
2016-01-18
1,084 reads
Q&A: Multiple SQL Server Instances on a VM
I recently received a great question through email. It was whether or not it is a good idea to have...
2016-01-18
1,103 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