Setting up Management Studio for remote SQL Server
Learn how to configure SQL Server and Windows to allow others to connect to an instance remotely.
ASP.NET Core with GitOps: Orchestrating Your Containers with Kubernetes
Kubernetes can be used to deploy, scale, and manage containers. In this article, Mircea Oprea builds on the previous example in the series to show you how deploy your contains in the Elastic Kubernetes Service in AWS.
The Art of Commenting
This week Steve talks about the ways in which comments are important in our code.
SQL Server Unit Testing in Visual Studio
Unit test stored procedures in Visual Studio using an existing database or new SQL scripts
The Time to Patch
Microsoft has spent years working on building a reliable and dependable patch process for their software. While some products have had more sporadic updates, SQL Server has moved to a fairly regular schedule. Not quite a predictable "Patch Tuesday" schedule, but you can count on a CU arriving every month or two for SQL Server. […]
SQL Server Best Practices for Data Quality
Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a regular basis. Unfortunately, cleansing and validating data is difficult with the native SQL Server toolset. How do we leverage the SQL Server tool set to achieve these goals?
Exporting Data with PowerShell
Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a short tutorial on exporting data from SQL Server […]
Building a Countdown Timer with PowerShell
Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that can create a window for a countdown timer.
Using SQL Change Automation in SSMS to Track Static Data Changes
SQL Change Automation 4.1 now allows users to develop static data changes from SQL Server Management Studio.
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers