SQL Server TDE – Is TempDB Encrypted?
A really quick one today, something that made me think for a minute and I thought it might make others...
2017-06-19
674 reads
All About SQL
WinDbg and SQL Server Fun
I have a SQL Server that is constantly producing “dump” files (with a MDMP File type), these are named SQLDumpxxxx...
2017-06-14
620 reads
How/Why/What is DevOps?
Thanks to Grant for hosting this month’s T-SQL Tuesday found (http://www.scarydba.com/2017/06/06/t-sql-tuesday-091-databases-devops/) where it is a chance to share our DevOps...
2017-06-13
560 reads
Unable To Call Into C Compiler !?
Following on from my previous blog post I mentioned that I had to find a solution to the “unable to...
2017-06-07
430 reads
SQL Server – Service Terminated
I had a messy (another one) day, last thing I wanted was a “broken” SQL Server instance where I was...
2017-06-05
407 reads
SQL Server Memory Metrics
A very quick post for today, recently I have been working on some code to gather metrics around SQL Server...
2017-06-02
462 reads
Azure Robots – Index Performance Recommendation
They are watching me and my Azure SQL Database and recently I noticed a low impact performance recommendation was made....
2017-06-01
438 reads
Find when your SQL Server database grew
A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database...
2017-05-25
326 reads
AD Authentication and Azure SQL Database
Setting up AD authentication with Azure SQL Database sounds simple, it is assuming you plan carefully. I did run into...
2017-05-22
417 reads
Setting SQL Server Max Memory Dangerously Low
Hopefully you know the relevance and importance of setting a correct value for max memory on your SQL Server. By...
2017-05-18
428 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers