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,086 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,082 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
583 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,257 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
53 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 of the restirctions put on them by the requirements...
2016-05-03
10 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
617 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
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...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers