Setting a Processor Affinity in SQL Server – the (unwanted) Side-Effects
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-10-11 (first published: 2017-10-02)
2,355 reads
Blog Posts
sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)
I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into...
2017-10-11
431 reads
Use cases of various products for a big data cloud solution
There are a tremendous amount of Microsoft products that are cloud-based for building big data solutions. It’s great that there...
2017-10-11
2,424 reads
WAITFOR isn’t a function–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-11
1,114 reads
What's new in SQL 2017
SQL Server 2017 became General Availability (GA) on 10/2, I've been sharing through the different social media channels the different features and enhancements included in this new version, however...
2017-10-11
28 reads
What's new in SQL 2017
SQL Server 2017 became General Availability (GA) on 10/2, I've been sharing through the different social media channels the different...
2017-10-11
189 reads
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
328 reads
Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to...
2017-10-11
473 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
25 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
399 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers