I recently had a friend reach out to me about database performance dropping drastically. I asked if anything had changed recently on the server, and they told me that all...
2024-01-08
52 reads
Use Dynamic Data Masking to protect your data
The post Dynamic Data Masking – SQL Server appeared first on Tim Radney.
2023-12-25 (first published: 2023-12-03)
237 reads
I get asked about Azure SQL very often. This is a topic that I’ve written about and taught many times. To be honest, this is a rather large topic...
2023-11-17 (first published: 2023-10-25)
449 reads
When I review customers database environments, I always check to see what the recovery model is for their databases and review that with the customer. I often times have...
2023-11-15
25 reads
There have been many organizations that have become victims of ransomware over the years. Occasionally we hear about some high-profile cases in the news. Most every case I’ve read...
2023-09-19
21 reads
Why should you patch your SQL Server instances? Compliance, stability, security, reliability, functionality, and more. Microsoft regularly releases updates to SQL Server known as Cumulative Updates (CUs). Cumulative updates...
2023-08-15
43 reads
My number one reason that you should test your backups is to make sure you know how to restore/recover. The absolute worst time to learn how to restore is...
2023-07-10
31 reads
I repeat the phrase “If you aren’t monitoring it, you can’t measure it” all the time. Through my IT career, this has been a constant. If you don’t have...
2023-06-14
13 reads
The OS default Power Plan for Windows is Balanced Power. This can cause degraded overall performance for SQL Server. Balanced Power is a great concept to help conserve energy...
2023-05-16
33 reads
Throughout my career, I’ve worked on a LOT of different SQL Servers. Many that were installed and configured by application administrators, developers, vendors, and data professionals. I’ve seen servers...
2023-04-11
26 reads
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers