Ten tips for building a collaborative DevOps culture
There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.
Upgrade and Migrate SSRS Report Server and Retain Server Name
In this article we look at how to do a side by side install of SQL Server Reporting Services to minimize downtime for the migration.
Working in a Distributed Fashion
With many of us working in a distributed fashion, Steve wonders if things have changed for the process flow you follow.
Five facts about the SQL Server Tempdb Database
In this article we cover some interesting facts about the SQL Server TempDB database that could be useful to know.
SQL Templates and Code Snippets in SSMS and SQL Prompt
Phil Factor explains the uses and limitations of native SSMS templates and snippets, and then demonstrates the extra versatility that SQL Prompt snippets provide.
Why Doesn't Database Software Help Us?
Databases don't manage themselves, but Steve sees this as an opportunity, not a problem.
How to deploy and execute an SSIS package from the SSISDB catalog
Beginning with SQL Server 2012, SQL Server Integration Services packages can be deployed and executed from a SQL Server database named SSISDB, which serves as a repository for SSIS packages.
Tool Limits
Today Steve asks about the tools you use for your job and if they help or hurt your productivity.
Azure AD Authentication for Azure SQL Databases
In this article we walk through how to connect to Azure SQL Database using Azure Active Directory authentication along with multi-factor authentication.
Documenting a SQL Server Data Catalog in HTML and Git Markdown
Dave Poole explains the need for high quality database documentation and then demonstrates how to document the SQL Server database for a data catalog, in both HTML and Git Markdown, using SQL Doc, SQL Data Catalog, PowerShell, and a few helper scripts to ensure consistency and correctness.
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