In November, Microsoft released version 18.4 for the SQL Server Management Studio (SSMS), introducing some key features such as support for materialized view scripts in SQL Data Warehouse. It also ...

Microsoft's SQL Server database software includes a job scheduling system which lets you perform routine business activities such as reporting and database management on an automatic schedule.

I'm down on SQL Server Management Studio right now. I basically just spent a day trying to swap out the evaluation version of SQL Server 2008 R2 with the Express version, and SSMS just wouldn't ...

Open up new reporting options for your SQL Server with these PowerShell tips.

SQL Server 2025 preview debuts with Ubuntu 24.04 support and TLS 1.3 encryption for stronger security and Linux flexibility.

Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data.

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

PowerShell offers a lightweight and efficient solution for backing up SQL Server Express databases on local workstations without the need for full system backups.