A Good Reason to use a VCS
Steve has a good reason to use a version control system. It's a different kind of backup that you might need.
PowerShell To Get Active Directory Users And Groups into SQL
Use Powershell to query AD for Users, Groups and GroupMembers
SQL Server Datetime vs. Datetime2
Read a short comparison of datetime and datetime2 types. Learn about their structure, as well as the advantages and disadvantages of each.
Understanding the OVER Clause in SQL Server
Having a solid knowledge of the window functions if vital to high performance T-SQL Code. The key to these functions is how the OVER clause is used. This article will dive into how to use the OVER clause.
How to Stop a SSIS Package Execution from Code
In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.
Beware, More Ransomware is Coming
Ransomware has become a large problem in the last few years, and Steve thinks this will continue to increase because of insurance payouts.
SQL Server Management Studio Tips
A complete guide to the hidden gems of SQL Server Management Studio (SSMS), covering shortcuts, tips and tricks, useful scripts, and more.
SQL Server Security: Fixed Database Roles
Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.
The Difference between Truncate and Delete in SQL Server
This article explains the differences between the Truncate and Delete commands in SQL Server.
Backup Techniques Available Exclusively When Using Azure VMs
Learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads.
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers