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.
What If You Really DO Need to Shrink a Database?
You’ve heard that shrinking a database is bad because it introduces both external and internal fragmentation, it causes blocking, it causes transaction log growth while it runs, and it’s slow and single-threaded. You understand that if it’s just a matter of 10-20-30% of a database, and the database is only 100-200GB, you might as well just leave the space there, because you’re gonna end up using it anyway.
Access external data from Azure Synapse Analytics using Polybase
Learn how you can use Polybase technology in Azure Synapse to load data into your warehouse.
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
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
AI Database Central
Comments posted to this topic are about the item AI Database Central
The Grafana Alternative to SSRS and Power BI
Comments posted to this topic are about the item The Grafana Alternative to SSRS...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers