Disk Usage by Top Tables Report in SQL Server
The Disk Usage by Top Tables Report in SQL Server is a quick way to get sizes of all tables within a database.
Show Last Backup Times in SQL Server
One of the first things you’d want to know about a SQL Server if you’re touching it for the first time, is when the databases were last backed up.
Why use WHERE 1=1 in SQL Queries
A common SQL question is, why does anyone use WHERE 1=1 in their queries? And what does it do? The condition means WHERE TRUE, so it’s just bringing back the same query result as it would without.
Creating a Linked Server with a MySQL Database
This is my 3rd Linked Server post, and this time it’s to a MySQL database. Noteworthy weblinks: # My Linked Server Blog Posts.# Microsoft Docs – Linked Servers.
Check & Restart SQL Server Services on Linux
Restarting services is a simple one, although it could be an unfamiliar environment for pre-SQL Server 2017 (only) administrators; which was the edition that allowed SQL Server to run on Linux.
Forcing Encryption in SQL Server
If you’re ever planning to allow external connections to a SQL Server, one of the first things to ensure is that the data is encrypted at rest and in-transit.
Include Execution Trace Messages in SQL Server Error Logs
Logs are always important if you’re supporting systems. The SQL Server Agent has always been a heavily used tool in my experience, so writing execution trace messages to the logs might help investigate an issue one day.
Backing up a SQL Server Database with Encryption
Backing up a SQL Server Database with Encryption is the secure way of performing your SQL Server backups. If you’re ever worried about the data within your databases, you may consider this option when performing database backups.
Backing up a SQL Server Certificate
It’s important to backup SQL Server Certificates, but only if you’re using them really. If for example, your SQL Server database backups are encrypted and you need to restore it on another server, then you will need both the certificate and private key that was used.
How to Check What Features are Installed in SQL Server
This is a quick guide on how to check which features are installed on a SQL Server. Open your SQL Server installation files.
