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!
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 […]
SQL Server 2016 SP3, the last service pack ever is out. Steve comments on how the world of software patches has changed.
In this article we cover how to implement a batch Databricks Change Data Feed process through an end-to-end exercise.
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.
Steve notes that there are differences between state based development and migration based development, but neither is necessarily better.
In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.
Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group by rollup, cube and grouping sets.
Join Kevin Davis, DBA Manager at Tower Loan to hear their playbook for successful distributed estate monitoring, and the role of SQL Monitor.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
Hi all, I recently moved to a new employer who have their HA setup...
Comments posted to this topic are about the item Semantic Search in SQL Server...
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers