Azure SQL DW – Let’s Shuffle?
Initially, the main focus of this post was going to be quick and about using the latest version of SSMS...
2018-04-12
883 reads
All About SQL
Azure SQL Database and Columnstore Indexes
I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many...
2018-04-19 (first published: 2018-04-09)
2,253 reads
4 Improvements to Azure SQL Database
If I was a wizard I would make these 4 improvements to Azure SQL Database. They are in no particular...
2018-04-12 (first published: 2018-04-05)
2,197 reads
Azure SQL Database – Failed to Delete Database Nightmare
After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs....
2018-04-03
377 reads
Database Has Been Paused
I was looking forward to do some work with Azure SQL Data Warehouse (DWH) when I hit the new query...
2018-04-03 (first published: 2018-03-27)
3,467 reads
Backup and Restore Options for Azure SQL DB
I have decided to do a summary blog post on backup and recovery options for Azure SQL Database. If you...
2018-03-26
584 reads
SQL Vulnerability Assessment for Azure SQL Database
Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA)....
2018-03-22
1,013 reads
Azure SQL Database and Cost Threshold for Parallelism
We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated...
2018-03-26 (first published: 2018-03-16)
2,338 reads
Understanding DBCC FLUSHAUTHCACHE
This command only applies to Azure SQL Database, at a high level it empties the database authentication cache for logins...
2018-03-14
753 reads
Azure SQL Database – Allow Azure Services to Access Server
When you create a “logical” Azure SQL Server (I say logical because we are not really physically creating anything) there...
2018-03-09 (first published: 2018-03-01)
2,494 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
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers