Procedure to Create New Filegroups and Files
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
287 reads
Blog Posts
Procedure to Create New Filegroups and Files
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
53 reads
Remembering Robert Davis, aka @SQLSoldier
I woke up early on Tuesday with a hundred things to do and plenty of energy to match my task list. By noon, I’d made a loaf of bread,...
2018-04-03
25 reads
2018-04-03
257 reads
TDE – Regenerating the Database Encryption Key
As discussed in the last post, with TDE (Transparent Data Encryption), you generally do not need to change the Database...
2018-04-03
1,136 reads
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...
2018-04-03
564 reads
Why Projects Fail...Free Session, Free Beer and Free Food
Why Projects Fail...Free Session, Free Beer and Free Food
Mark Williams and myself will delivering a seminar called #Not the GDPR news in...
2018-04-03
322 reads
AT TIME ZONE: The easy way to deal with time zones and daylight savings time
Many people think daylight savings time was created to help align the hours that the sun is up with our...
2018-04-02 (first published: 2018-03-27)
5,097 reads
Buggy Whips 2.0
I recently found myself rereading a very old blog post of mine, from the very beginning of this blog, discussing...
2018-04-02
276 reads
Free Webinar – DBAs vs. SysAdmins in Cloud Availability April 19
SIOS and I are proud to host a joint free webinar entitled “DBAs vs. SysAdmins in Cloud Availability” on Thursday,...
2018-04-02
283 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers