SQL Puzzle 3: Knights and Queens
I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem:
SQL Puzzle...
2017-09-01 (first published: 2017-08-22)
2,343 reads
Blog Posts
SSIS ForEach Enumerator File Order
I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn't order) files....
2017-09-01
595 reads
Viewing the Statistics Objects Used to Create an Execution Plan
A while ago now I was running some Performance Tuning workshops and was asked how you can find out which Statistics...
2017-09-01
422 reads
Automatic Seeding & Compression
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-31
1,074 reads
Azure Archive Blob Storage
Last week Microsoft released a public preview of a new service called Azure Archive Blob Storage, offering customers a lower-cost...
2017-08-31
1,038 reads
Bulk Inserting Build Data–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-31
682 reads
Information Measurement with SQL Server, Part 2.1: The Uses and Abuses of Shannon’s Entropy
By Steve Bolton
…………In the first installment of this wide-ranging series of amateur tutorials, I noted that the Hartley function indeed...
2017-08-31
931 reads
New in SQL Server 2017: Graph Databases
David has recorded and published a video of his presentation on SQL Server Graph Database. In his video which you...
2017-08-31 (first published: 2017-08-21)
2,671 reads
SQL Server: SARGability
SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know....
2017-08-31
4,631 reads
Using Time Zones in SQL Server
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be...
2017-08-31 (first published: 2017-08-18)
3,805 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