Managed Vs Unmanaged Tables – Data Engineering with Fabric
Managed Vs Unmanaged Tables Microsoft Fabric was released as general availability on November 15th, 2023. I will be […]
Archives de l’année : 2024
Upcoming changes for SQL Server Management Studio (SSMS) – Part ...
Hey all! This is the final post in a series of three covering SQL Server Management Studio (SSMS), […]
SSMSInfoReports : nouvelle release v9.2
Encore une nouvelle version de mes rapports custom pour SQL Server Management Studio, la 9.2 ! Avec dans […]
Free Live Webcasts: Slide & Demo Versions of How to ...
You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it […]
Networking errors when enabling SQL Server by Azure Arc
When onboarding your SQL Server instance to Azure Arc, there are some networking prerequisites that need to be […]
Department of Redundancy Department
Ever wonder all the reasons that we use databases instead of file systems? While we don’t think […]
Correct SQL Server Transactional Replication Issues with T-SQL and SSMS
The post Correct SQL Server Transactional Replication Issues with T-SQL and SSMS appeared first on SQLServerCentral.
Find Unused or Backup Tables
In this article, I am going to demonstrate how we can identify the unused tables of a given […]
The difference between BIN2 and Case-Sensitive collations in SQL
A common question that arises in SQL Server collation discussions is whether a binary collation (BIN2) is functionally […]
Cumulative Update #12 for SQL Server 2022 RTM
The 12th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
The Benefits of Volunteering at SQL Saturdays
Editor note: The call for volunteer and speakers is open at on the Pass Data Community Summit […]
[Video] Office Hours: Speed Round
Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded answers. Let’s conquer 22 questions in 15 […]
Visual Studio 17.10 Preview 2 améliore le travail avec GitHub ...
Microsoft a annoncé la disponibilité de Visual Studio 17.10 une mouture qui améliore notamment le travail avec […]
SQL Server to PostgreSQL Database Schema Conversion
The post SQL Server to PostgreSQL Database Schema Conversion appeared first on SQLServerCentral.
Option Recompile is a Magic Turbo Button That Actually Works.
I didn’t say that – Guy Glantser did. Guy Glantser is an Israeli SQL Server guru with a […]
Transforming and Analyzing Data in PostgreSQL
In our data hungry world, knowing how to effectively load and transform data from various sources is […]
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 […]
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 […]
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 […]
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. […]