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,053 reads
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
5 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,176 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
7 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
808 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,803 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,290 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,151 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,246 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,358 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers