Building an ETL with PowerShell
There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work.
State of Database Monitoring Report 2
We’re sharing the results of our State of Database Monitoring survey in four insights reports this year – and the second one is out now. In The value of a monitoring tool for the entire organization you’ll learn why more businesses than ever are using a monitoring tool and how doing so can help the entire business to reduce costs, enhance security and collaborate more efficiently. DBAs - download a copy and send it to your boss, today!
PASS Data Community Summit Pre-cons
This year PASS Data Community Summit is a free virtual event, and I encourage you to register even if you are interested in just a handful of sessions. One of the Learning Pathways might be just what you are looking for, from Query Basics to Power BI to DevOps. What I’m most excited about this […]
The Last SQL Server Service Pack
SQL Server 2016 SP3, the last service pack ever is out. Steve comments on how the world of software patches has changed.
Databricks Delta Change Data Feed
In this article we cover how to implement a batch Databricks Change Data Feed process through an end-to-end exercise.
Estimating Data Compression Savings in SQL Server
This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not.
Choosing State Over Migrations
Steve notes that there are differences between state based development and migration based development, but neither is necessarily better.
Stairway to SSAS Tabular Level 1: Why use Analysis Services
In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.
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...
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
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