Azure and Windows PowerShell: Using VM Extensions
In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during the provisioning process.
5th annual “Seattle Freecon”
On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day. That’s right, absolutely FREE.
Index Tuning Week: How Many Indexes Are Too Many?
When you're not sure, start by aiming for 5 or less indexes per table, with 5 or less fields each.
Embrace Stored Procedures
Developers working with SQL Server should learn to embrace stored procedures. They really, really do work well.
HIPAA and Database Administration – Part 2
HIPAA was signed into law in the United States in 1996. In this article, Robert Sheldon discusses how the act affects the day-to-day responsibilities of database administrators.
Software Engineering in Practice
Is there a need for apprenticeships in the data world? Should we consciously seek to view our first year as an apprenticeship? Should companies provide learning paths for new hires?
What is ADF? Level 1 of the Stairway to Azure Data Factory
Azure Data Factory is a new way of moving data around, and this first level gives you a good overview of what the service can do.
Skills for Everyone in Tech
Today Kathi talks about the skills that all of us need to succeed in our careers.
SSIS Basics: Data cleansing using derived columns
On this article I will show you how to perform a basic data cleansing using the derived column data transformation
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