Building MongoDB Aggregations
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. In the previous article in this series, I discussed how to use a find statement to retrieve data from a MongoDB collection. Howev …
Updated First Responder Kit and Consultant Toolkit for February 2024
New this month: better sp_BlitzIndex performance on databases with tens of thousands of objects, sp_DatabaseRestore can run test scripts, and David Wiseman and Sean Killeen implemented basic automated testing for the First Responder Kit. Wanna watch me …
Friendly Deletes in SQL Server
One of the first things you learn when working with SQL Server, and other transactional based SQL systems, is that set based operations perform best. If you are querying data, a cursor pulling individual rows doesn’t perform as well as a single q …
Live webinar: How to excel at managing multiple database platforms
The use of multiple database platforms is on the rise, however, managing them can be challenging, with issues such as data integration, monitoring and a requirement for greater skill diversity. So how can you thrive in this environment? Join industry e …
A Few Best Practices for Strong SQL Server Security
Databases serve as the critical infrastructure for numerous applications. They safeguard essential data that fuels both business operations and strategic decision-making. Given the significance of this role, safeguarding your database is a top priority …
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 we’re dealing with:SELECT TOP 100 Location, COUNT(*) AS Population, AVG(Reputation) AS AvgReputation FROM dbo.Users GROUP BY Location ORDER …
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 to normalize databases, eventually we are faced with some sort of text-based data stored within a relational database and need to extrac …
Find Recent Superstars: Answers & Discussion
Your query exercise for this week was to write a query to find users created in the last 90 days, with a reputation higher than 50 points, from highest reputation to lowest. Because everyone’s Stack Overflow database might be slightly different, …
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 of AI?” and other burning questions
The post “As DBAs, should we be worried about our jobs because of AI?” and other burning questions appeared first on SQLServerCentral.
Join Me in Orange County for Tuning Databases in One Day
You’ve got production databases in SQL Server or Azure SQL DB, and you want to make ’em faster. You need to identify the database’s bottleneck, prove the root cause, and then recommend fixes. You want to make the right choice for each …
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 to get the boss to buy you an online or in-person ticket, it’ll help if you have a specific list of sessions you wanna attend. …
Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster – Part 3
The post Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster – Part 3 appeared first on SQLServerCentral.
Meet Claude, the new AI
Introduction to Claude This time we will meet Claude, a new AI technology. Previously, we talk about ChatGPT, Bing and Bard. We will explain what are the advantages of this new technology and test a little bit to generate some code. Interview This is t …
Upgrade SQL Server on your workstation
Lately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. The main source of the problem is usually the web installer/wrapper, which can fail for a variety of reasons that aren’t always made …