List All SQL Agent Jobs on a SQL Server Instance
This post contains a SQL script that will return a list of all SQL Server Agent Jobs on a Microsoft SQL Server instance.
How to Restore a Database in SQL Server
Restoring a database in SQL Server is a straightforward task, and one that SQL Database Administrators have to perform thousands of times throughout their career.
What’s New in the SQL Server 2022 Install
SQL Server 2022 was announced last week at the Microsoft Build event, which is an annual summit aimed at those of us who are enthusiastic about Microsoft software.
Why Use WHERE 1=2 in SQL
Some time ago I wrote a blog post on why use WHERE 1=1 in SQL. This time it’s why use WHERE 1=2, but really this can be WHERE 1=9 or anything that isn’t a 1, we just want the false statement.
Get All Database Sizes & Free Space Info In SQL Server
Tracking database file sizes and free space within data and log files is an important part of monitoring SQL Server. This information, along with other metrics such as growth events, can help you to better predict and plan for future disk space provisioning needs.
Find String in Tables in SQL Server
Finding strings in SQL is usually done within a WHERE clause – you’re searching for rows in a table containing your condition which can of course include a string.
Show Only the Domain of an Email Address in SQL Server
When performing data analysis of email data in SQL, there’s often a need to show only the domain of an email address.
USE Command in SQL Server
USE [database] in SQL Server is a way to change the context to a specific database when you are running a query in Microsoft SQL Server.
Change Default Database in SQL Server
When you log into SQL Server using SQL Server Management Studio (SSMS), opening a new query window will automatically scope you within the default database set when your user was created.
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 the sizes of all tables within a database.
