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,080 reads
anup.varier@gmail.com
- Website: http://sqlsailor.com
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
10 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...
2016-01-28
2,202 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
13 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
812 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,808 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,304 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,160 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,372 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,257 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Alamat BCA KCP Bontang Kontak 0817819444
WhatsApp:0817819444 Ruko Bontang Trade Center, Jl. Bhayangkara A10-A11, Gn. Elai, Kec. Bontang Utara, Kota...
Alamat BCA KCP Sangatta Kontak 0817819444
Jl. Yos Sudarso, Sangatta Utara, Kec. Sangatta Utara, Kabupaten Kutai Timur, Kalimantan Timur 75611
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers