Curious case of SYS.MESSAGES
A strange error struck me last week, and this post is all about that. What you normally expect when you run SELECT * FROM sys.messages? The query will return a...
2016-03-07
2 reads
SQLSailor.com
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.
The transport...
2016-01-28
2,138 reads
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable. The transport security involves encryption of packets exchanged between the...
2016-01-28
3 reads
SQL Server 2016 CTP 3 Setup – UI Improvements
There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making...
2015-11-11
805 reads
Azure Virtual Machine Blog Series – Changing the size of a VM
I’m starting a new blog series on Microsoft Azure Virtual Machines, and my goal is to write blog posts exclusively on...
2015-09-30 (first published: 2015-09-24)
2,802 reads
SQL Server Data Tools is now a separate installer – Things to know!
Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I...
2015-09-08
1,288 reads
Why I won’t be running SQL Server Standard Edition on Business Critical Servers!
I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a...
2015-07-09
1,150 reads
Installing SQL Server 2016 CTP2 – UI Changes
SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No,...
2015-05-29
3,245 reads
Full Domain Trust and Natively Compiled Stored Procedures – In Memory OLTP
Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored...
2015-06-03 (first published: 2015-05-26)
1,357 reads
SQL Server 2016 Announced, and it stretches to the Cloud!
Last week during Ignite, Microsoft CEO Satya Nadella announced the next version(Till then it was called as SQL vNext) of...
2015-05-10
1,012 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
SQL Server audit with windows ad group
I am trying to create a filter on a SQL Server audit to capture...
Deadlock graph anomaly
I've come across what appears to be a strange deadlock anomaly. As seen in...
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers