Product Review: GenesisOne T-SQL Source Code Unscrambler
MVP Jody Roberts reviews GenesisOne T-SQL Source Code Unscrambler, a tool that aims to clarify code and server environments with simple diagrams and plain English.
Stairway to Columnstore Indexes Level 4: Catalog Views
In this level, we will first take a look at how to recognize columnstore indexes in some of the generic catalog views. After that we will investigate the new catalog views that have been added just for columnstore indexes.
Microsoft and Database Lifecycle Management (DLM): The DacPac
The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-drift. As such, it seems to provide an obvious cost-free start for tackling automated Database Delivery as part of Database Lifecycle Management (DLM). We asked Phil Factor if it is ready for Prime-time.
Cloud Security Issues
The cloud is always going to be a challenge for security, but is it harder or easier than on premises? Steve Jones has a few comments.
Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations
There are unique considerations that apply to virtual machines that run SQL Server workloads in such environments. This document provides insight into considerations and best practices for running SQL Server in Hyper-V Dynamic Memory configurations on Windows Server.
But we've always done it that way…
Inspired by his visit to the battlefield of Waterloo, Grant Fritchey explains the dangers of doing things the way you've always done them and the need to challenge constantly your beliefs and understanding of how the technology you manage works.
Do It Yourself Load Balancing with SSIS
This article takes a simple look at loading data in parallel from a single data source, be it a flat file of a database
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers