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
615 reads
All About SQL
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
552 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
427 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
392 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
459 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
431 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
324 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
408 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
413 reads
Creating Azure Database for MySQL and using Azure Cloud Shell
After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is...
2017-05-15
384 reads
Blogs
SQL Server 2025 Release Candidate Available
By Brian Kelley
For those testing SQL Server 2025 before it officially releases, Microsoft has made the...
Scooby-Doo and the Mystery of Cloud Costs (Let’s have some fun!) – Scooby Dooing Episode 1
If there’s one thing I’ve learned in consulting, it’s that SQL Server, and other...
Fabric Real Time Data: Making the Shift from Batch to Live Insights
By Chris Yates
Embracing the New Paradigm Fabric real-time data signals a fundamental shift in how organizations...
Forums
Encryption or Certificate - Trying to NOT put hardcoded password in Proc
We have a few stored procs where we need to a dos command "net...
Next dates
CREATE TABLE ADMITS ( ID_NUM INT varchar(15) null ,provider_id varchar(15) null ,provider_name varchar(36) null...
Moving a database from AWS RDS Custom to RDS Standard
Having real fun with this. It isn't possible to set the option group, to...
Question of the Day
Change Tracking and Database Compatibility
I want to enable Change Tracking for a database. What is the minimum database compatibility level I need to set for the Changetable function to work correctly?
See possible answers