Introduction to SQL Server Query Store
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and talked out new feature. In this post we'll just take a brief look at it,...
2023-05-31
30 reads
Matthew McGiffen DBA
SQL Server Backup Encryption and Compression
In SQL Server you can also compress your encrypted backups. Unlike TDE this has been possible with Backup Encryption since the feature was first made available, and there have...
2023-05-26 (first published: 2023-05-24)
109 reads
Statistics Parser
Using Statistics Parser to easily read output from STATISTICS IO and STATISTICS TIME.
2023-05-23
90 reads
Backup Encryption Performance
Unlike TDE, there is some extra CPU overhead when you take an encrypted backup as the data has to be encrypted before being written to disk – whereas with...
2023-05-22
64 reads
Why you still need DBA resource in the cloud
Why a DBA, rather then being redundant, is even more valuable when your databases run in the cloud.
2023-05-31 (first published: 2023-05-19)
366 reads
Backup Encryption in SQL Server
In this post we look at how you work with the Backup Encryption Feature in SQL Server.
2023-05-18
41 reads
2023-05-17
47 reads
Top Tools for SQL Server Performance Troubleshooting
When you've got the symptoms of a database issue you can run a series of diagnostic queries to try and drill down on the problem and then start figuring...
2023-05-26 (first published: 2023-05-16)
484 reads
TDE: Database Backups and High Availability
Database backups continue to work without change when you have TDE enabled. The only difference is that the backups contain encrypted data that cannot be read without the certificate...
2023-05-15
12 reads
The Importance of SQL Server Performance Tuning in the Cloud
Make sure your cloud SQL Server databases are optimized and achieve significant cost savings.
2023-05-12
63 reads
Blogs
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it...
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
A New Word: Jouska
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Forums
partitioning a huge table
Hi folks I would like to get your views about partitioning a huge table...
SQL Website Development: A Comprehensive Guide to Building Dynamic Web Applicati
Introduction to SQL Website Development What is SQL? Importance of SQL in web development...
Ask SSC