Single User Mode – Back to Basics
Starting SQL Server in single-user mode should be a tool every data professional holds in the bag. This is an essential tool that can be used in multiple scenarios...
2018-05-31
301 reads
Blog Posts
SQL Saturday 769 Melbourne & 771 Sydney
For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney…
SQL Saturday769 (Sat 30 Jun 2018)...
2018-05-31
377 reads
SQL Saturday 769 Melbourne & 771 Sydney
For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney… SQL Saturday 769 (Sat 30 Jun 2018) Melbourne. SQL Saturday 771 (Sat 07 Jul 2017)...
2018-05-31
9 reads
Updated query to view data in the error log
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it...
2018-05-31
380 reads
Azure PowerShell – List Data Center Locations
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came...
2018-05-30 (first published: 2018-05-22)
2,191 reads
Azure SQL Database – The Default Isolation Is?
So what is the default isolation level for Azure SQL Database? I ran the following code to check it out....
2018-05-30
419 reads
Azure SQL Database / SQL Server – Paused Index Rebuild
I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when...
2018-05-30 (first published: 2018-05-22)
1,889 reads
Backup and Restore Automation using SQLCMD and SQL Server agent
Database administrators are often requested to refresh a database, mostly to create a live copy of the production database to...
2018-05-30
449 reads
Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...
2018-05-30
452 reads
Getting value out of data quickly
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
797 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers