Removing Extended Properties
With the new labeling and classificiation options in SQL Server, there might be a need to remove these labels before deploying the database.
Research on the Changing Workplace
The workplace is certainly changing with the COVID-19 pandemic. Steve shares a few learnings from Microsoft's work from home experiment.
Install SQL Server Integration Services in Visual Studio 2019
Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.
Tracking use of Deprecated SQL Server Features
Phil Factor explains how to use SQL Prompt, or SQL Change Automation, to detect use of deprecated SQL Server syntax, during development, and Dynamic Management Views and Extended Events to track its use on working databases.
Honorifics in the 21st century
As data professionals, we should understand how language and forms of address can impact our data model. In the 21st century, we should also learn how to communicate with colleagues in a respectful and professional manner.
Getting Started with Azure Blueprints
Learn about Azure Blueprints, available in the Azure portal, which is a new method of deploying Azure Resources through ARM templates.
The Old Way or the New Way
Learning to adapt the way we work is important for advancing our career, but this can be harder than we expect.
Creating a Simple Development Harness with SQL Compare and SQL Data Generator
There is no single, correct approach to developing and testing your SQL batches and routines. It depends on the requirement. For simple tasks, like modifying and testing a view or stored procedure, SQL Compare and SQL Data Generator, combined, provide a useful, lightweight development harness.
Blogs
SQL Server Journey (Part 1)- Enterprise Database 2016
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
Forums
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Is Your Time "Free"?
Comments posted to this topic are about the item Is Your Time "Free"?
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers