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...
2016-03-15 (first published: 2016-03-07)
2,061 reads
A strange error struck me last week, and this post is all about that.
What you normally expect when you run...
2016-03-15 (first published: 2016-03-07)
2,061 reads
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
5 reads
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,188 reads
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
7 reads
There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making...
2015-11-11
809 reads
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,803 reads
Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I...
2015-09-08
1,300 reads
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,152 reads
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,365 reads
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,253 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers