Get the most out of SQL Server Agent logs
If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on […]
Sites anglophones
Will AI end with SQL, Is this the end of ...
Introduction to the End of SQL Will the AI end with SQL? That is the question. The AI […]
Why Test-Driven Development? (Part 2)
The post Why Test-Driven Development? (Part 2) appeared first on SQLServerCentral.
SSRS 2022 Install, Setup and Configuration
The post SSRS 2022 Install, Setup and Configuration appeared first on SQLServerCentral.
Power BI Auto Detect Relationship Failure
In this article, we will talk about how to manually create a relationship by identifying the primary and […]
What Happens When Multiple Queries Compile at Once?
An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution […]
Reverse Creating the PBIP file from Source Control
On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […]
Finding Sister Locations to Help Each Other: Answers & Discussion
This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database: Locations […]
Writing your 2024 PASS Data Community Summit Submission
It is time again for the PASS Data Community Summit Call For Speakers. Some of you are […]
[Video] Office Hours From the Future
To answer today’s questions from https://pollgab.com/room/brento, I strapped on my Apple Vision Pro and recorded my persona as […]
Serverless Authentication methods in web apps.
Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional […]
Read This Before Your Users Install SSMS 20
SQL Server Management Studio 20 Preview 1 is out, and the new connection dialog has a big change: […]
Dynamically Move Multiple Tables in Bulk using Azure Data Factory ...
The post Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities appeared first […]
The Value of Conference Speaking
Editor note: The call for speakers is open at on the Pass Data Community Summit 2024 Site, […]
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 […]
Building MongoDB Aggregations
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
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 […]
Friendly Deletes in SQL Server
One of the first things you learn when working with SQL Server, and other transactional based SQL […]
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 […]
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 […]
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 […]
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. […]
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 […]
Finding Long Values Faster: Answers & Discussion
In last week’s Query Exercise, our developers had a query that wasn’t going as fast as they’d like: […]
Dynamically Create Tables in Power BI with DAX Functions
The post Dynamically Create Tables in Power BI with DAX Functions appeared first on SQLServerCentral.
Forget the Models, Your Data is the Secret Sauce for ...
Credit: Image generated by Google Bard Generative AI (GenAI) models like GPT, Gemini, PaLM, DALL-E, and others offer […]
#TSQL2sday Roundup: The Most Recent Issues You Closed.
For this month’s TSQLTuesday, I asked y’all to describe the most recent issues you closed. If you ask […]
Database Feature Toggles
In software development the concept of feature toggles are used to selectively turn on and off features. […]
Tutorial: Using the hierarchyid Data Type
The post Tutorial: Using the hierarchyid Data Type appeared first on SQLServerCentral.
[Video] Office Hours: Ask Me Anything About Microsoft Databases
Post your database questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss on the […]
JQ – Tool for Querying JSON documents using the CLI
In my role as a Data Engineer, I have an ever-increasing need for Querying JSON documents using the […]
Functions and Procedures: Learning PostgreSQL with Grant
One of the most useful constructs in SQL Server is the stored procedure. It gives you a […]
Query Exercise: Finding Long Values Faster
Our developers have come to us with a problem query that isn’t as fast as they’d like. Using […]
Improving Cardinality Estimation: Answers & Discussion
Your challenge for last week was to take this Stack Overflow database query to show the top-ranking users […]
Attention SQLBits 2024 Attendees!
Get ready to soar into SQLBits 2024 with us in Farnborough, UK March 19th – 23rd! Join keynote […]
Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, ...
The post Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more appeared first on […]
The Last Ticket/Issue I Closed #TSQL2sday
For this month’s T-SQL Tuesday, I asked y’all to write about the most recent ticket or issue that […]
SQL ConstantCare® Population Report: Winter 2023
The short story: SQL Server 2019 continues its utter domination of the Microsoft data platform landscape this quarter. […]
Leave it better than you found it
This is for the folks who still have to log into remote machines and do work manually […]