Upcoming changes for SQL Server Management Studio (SSMS) – Part ...
The second post in our series about SQL Server Management Studio (SSMS) coincides with the SSMS 20 Preview […]
Archives du mois : février 2024
Query Exercise: Finding Sister Locations to Help Each Other
For this week’s query exercise, let’s start with a brief query to get a quick preview of what […]
Find and Replace Text in Strings in T-SQL
String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts […]
Azure Data Studio 1.48 is now available
Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and […]
SQL Server Integration Services (SSIS) Change Data Capture Attunity feature ...
In December 2025, Microsoft will discontinue support for the Change Data Capture (CDC) components by Attunity and Change […]
Find Recent Superstars: Answers & Discussion
Your query exercise for this week was to write a query to find users created in the last […]
SQL Server Clustered Index Seek Operation Generates Poor Query Performance
The post SQL Server Clustered Index Seek Operation Generates Poor Query Performance appeared first on SQLServerCentral.
“As DBAs, should we be worried about our jobs because ...
The post “As DBAs, should we be worried about our jobs because of AI?” and other burning questions […]
Join Me in Orange County for Tuning Databases in One ...
You’ve got production databases in SQL Server or Azure SQL DB, and you want to make ’em faster. […]
SQL Server enabled by Azure Arc, now assists in selecting ...
Cloud migration is the process of moving workloads from on-premises or legacy systems to the cloud. It can […]
Sessions You Should Attend at SQLBits Online 2024
SQLBits 2024 is next month, and the session agenda is out, including the Microsoft-led sessions. If you’re going […]
Add Additional Nodes to SQL Server 2022 and Windows Server ...
The post Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster – Part 3 […]
Meet Claude, the new AI
Introduction to Claude This time we will meet Claude, a new AI technology. Previously, we talk about ChatGPT, […]
Upgrade SQL Server on your workstation
Lately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. […]
[Video] Office Hours: Hot Tub Edition
Today’s Office Hours comes from a very different office! I climbed into the hot tub to review your […]
What Every DBA Should Know about Always On Readable Secondaries
This article aims to demonstrate the lesser-known impact of Always On Readable secondaries. In this article, we will […]
Redgate Summit: The Database Landscape
The post Redgate Summit: The Database Landscape appeared first on SQLServerCentral.
Query Exercise: Find Recent Superstars
For this week’s Query Exercise, we’re working with the Stack Overflow database, and our business users have asked […]