Who needs data access? Not You!
With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:
When Too Much is Not a Good Thing December 13,...
2019-12-12
5 reads
Jason Brimhall
The Gift of the SPN
Every once in a while there is an extremely valuable tool that comes along. While the footprint and use frequency of this tool may not be that big, the...
2019-12-10
11 reads
Why oh Why? Effects of Antivirus on a DB Server
At best these phantom backups cause undue headache in troubleshooting. At worst, they make it impossible to recover in the event of a database related disaster. Join me for...
2019-11-28 (first published: 2019-11-20)
1,316 reads
Why oh Why? Effects of Antivirus on a DB Server
At best these phantom backups cause undue headache in troubleshooting. At worst, they make it impossible to recover in the event of a database related disaster. Join me for...
2019-11-20
16 reads
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...
2019-08-09 (first published: 2019-07-17)
270 reads
Finding Data Gaps
Quality data is a goal we all strive to attain. Nobody wants to have bad data. Yet, despite our best efforts, the problem of bad data has its way...
2019-08-05 (first published: 2019-07-11)
523 reads
Event Files on Linux
For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...
2019-07-29 (first published: 2019-07-10)
195 reads
Is That Database in Use?
This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:
Finding Deprecated Uses in SQL Server November 7, 2016...
2019-07-22 (first published: 2019-07-03)
965 reads
Join a List of Values
There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:
Correlate Trace...
2019-07-18 (first published: 2019-07-02)
650 reads
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...
2019-07-17
7 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
Foreach Loop still executes after process and delete all the folders
I have two challenges XML source control not displaying the XML file parent node...
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
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