New Azure storage account type
In Azure, there previously has been only one kind of storage account, which is now called a “General Purpose” storage...
2016-05-04
1,087 reads
Grant Deny Revoke
It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them....
2016-05-04
1,104 reads
SSRS and MDX: Think about Cell Properties
I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you...
2016-05-04
586 reads
Word-wrap in SQL Server Management Studio
I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic...
2016-05-12 (first published: 2016-05-04)
4,433 reads
How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because...
2016-05-03
802 reads
How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because...
2016-05-03
54 reads
How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because...
2016-05-03
55 reads
How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because of the restirctions put on them by the requirements...
2016-05-03
11 reads
Implicit Conversion and Performance
Letting SQL Server change data types automatically can seriously impact performance in a negative way. Because a calculation has to be run...
2016-05-03
620 reads
Weekly Round-up 30 April 2016
It’s been an interesting week for me. I spent last week in Toronto delivering a SQL Server upgrade course and...
2016-05-03
368 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers