SQL Server vNext: sys.dm_db_stats_histogram
Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram...
2017-02-21
367 reads
Arun Sirpal
Setting up SQL Server to SQL Database (Azure) Replication
I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed...
2017-02-20
386 reads
True story: Encryption in progress stuck
Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was...
2017-02-16
372 reads
Azure Advisor Recommendations
Logging into the Azure portal is a daily task of mine and my eyes light up when I see features...
2017-02-15
333 reads
Lightweight Statistics Profiling (with a potential bug)
The great thing about new versions of SQL Server is the fact that they are packed full of new features...
2017-02-13
397 reads
Using Extended Events in Azure
Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace,...
2017-02-10 (first published: 2017-02-06)
1,300 reads
SQL Server vNext
I have been pretty busy recently working with Joe Sack from Microsoft and getting my hands dirty with SQL Server...
2017-02-03
725 reads
Compare Execution Plans
Have you ever wanted to compare execution plans from SQL Server Management Studio? Well with the newer version of the...
2017-02-02
436 reads
SQL Server Performance Dashboard Reports
Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server (CMS).
2017-02-02 (first published: 2015-08-20)
15,886 reads
My backup and SLEEP_BPOOL_FLUSH
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...
2017-02-01
809 reads
Blogs
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Retro Data 2025 – Slidedeck
You can find the slides of my session on the €100 DWH in Azure...
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Forums
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
How Well Does the MSSQL Extension in VSCode Work?
Comments posted to this topic are about the item How Well Does the MSSQL...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers