Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities
The post Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities appeared first on SQLServerCentral.
The Value of Conference Speaking
Editor note: The call for speakers is open at on the Pass Data Community Summit 2024 Site, so join Jason in throwing your hat into the ring for this year’s Summit coming up in Seattle November 4-8! My Power BI Speaking Tour: This is the Way Over …
Evolving Role of Data Professionals in Artificial Intelligence Era
This image is generated by Google Gemini Introduction The way we work is about to change drastically. Generative AI tools like Gemini, ChatGPT and their underlying large language models (LLMs) have reached unprecedented levels of sophistication. From m …
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. …