When Things Go Wrong in Azure
Things go wrong in IT, it is no different with the cloud. When I say cloud I am thinking quite...
2017-10-12
462 reads
Arun Sirpal
Checking Out SQL Vulnerability Assessment
Apparently there is a new tool from Microsoft where you can discover, track, and remediate potential database vulnerabilities. This tool...
2017-10-09 (first published: 2017-09-28)
1,586 reads
Azure SQL Database Data Integrity Checks
If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it...
2017-10-04
508 reads
SQL Server Tracking Tempdb Size
Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for...
2017-10-03
483 reads
SQL Server – Pause VS Stop
You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...
2017-10-02
354 reads
SSMS 17 Dark Theme
Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...
2017-09-29
2,703 reads
Azure SQL Database Active Geo Replication Changes
Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different...
2017-09-25
524 reads
SQL Server Tracking Suspect Pages
Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table...
2017-09-25 (first published: 2017-09-19)
1,591 reads
SQL Server Schema Compare
A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...
2017-09-18
557 reads
Azure SQL Database Resumable Online Index Rebuild
If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...
2017-09-14
1,296 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
The Improvement Limit
Comments posted to this topic are about the item The Improvement Limit
Migrate SSRS Reports to a New Server in Just a Few Clicks
Comments posted to this topic are about the item Migrate SSRS Reports to a...