Checking CHECKDB
Everyone should be running DBCC CHECKDB on their systems. We not have some help in determining if we are doing this.
Scheduling a PowerShell Script Using SQL Server Agent
This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.
Why Are You Dropping and Recreating Your Indexes?
Do you have data load processes that drop indexes to optimize the load process? Are you dropping those indexes in one step, then loading data into your table, only to recreate the indexes in a post data load step?
SQL Server Gets Smarter and Smarter
With each recent version of SQL Server, Microsoft has added features that can be used to improve query performance with much less effort than traditional index and query tuning require. First was Query Store, introduced with 2016. When enabled, this feature allows you to easily find regression in query performance due to changing execution plans. […]
SQL Server on Linux, does it have Microsoft's full attention?
SQL Server on Linux doesn't support Ubuntu 18.04 LTS. Why weren't Microsoft ready for the next LTS release?
Working with Windows Containers and Docker: Save the Data
Docker continues to make improvements in their products running on Windows. In this article, Nicolas Prigent explains how to share data between Windows containers and the container host. As a bonus, he also shows how to run a Linux container on Windows Server 2016.
Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.
Mercenary
Steve Jones talks about making deliberate career choices, or just moving from place to place without any worry about the job. Do you care about what work you do? Or is it just a job?
Transaction Locking and Row Versioning Guide
This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers