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,187 reads
Arun Sirpal
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,179 reads
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
868 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
365 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,454 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,321 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
577 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
993 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
730 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,483 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Distributed Availability Group Issue / Misunderstanding.
Not sure if this is a tech mistake I've made or a lack of...
Large posts full of code not allowed anymore?
Several times now, I've seen a post asking for a solution. I've replied, and...
Data > Hype
Comments posted to this topic are about the item Data > Hype
Question of the Day
Slipstream parameters
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers