Protecting the SA Account
The sa account is a well, known, built in account for SQL Server. Years ago, in previous
versions, I’d see...
2016-03-29
973 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
492 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
957 reads
Update to TRUNCATE TABLE in SQL 2016 (partition support)
Continuing my obsession with partitioning I thought I’d write this quick post about a cool change in SQL Server 2016.
This...
2016-04-12 (first published: 2016-03-29)
2,802 reads
Do You Teach Azure Data Platform?
I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out....
2016-03-29
823 reads
SQL Server Service Broker – Service Architecture
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-03-29
1,104 reads
Talking about the Query Store at SQLBits!
From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will...
2016-03-29
772 reads
Nothing To See Here
In a galaxy far, far, far away a developer of a third party application somewhere in the Hoth system had to...
2016-03-29
902 reads
SQL Server News–29th March 2016
This past weekend is one of my favourite holiday weekends - the 4 day Easter weekend 🙂 Although I have had to...
2016-03-29
610 reads
File Growths
I hinted at file growths in my previous posts about shrinking data and log files. Then I talked about growing log files in my post Database Log VLFs. However,...
2016-03-29
33 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