The 20th Anniversary of the SQL Slammer Worm
Twenty years ago this month (next Wednesday to be exact), sysadmins and database administrators started noticing extremely high […]
SQL Server
Should You Use SQL Server 2022’s GREATEST and LEAST?
If you’ve been following along with this week’s posts on DATETRUNC and STRING_SPLIT, you’re probably going to think […]
The Black Friday Sale Has Been Extended!
I got a *lot* of last minute emails this year from companies whose purchasing processes were moving slowly. […]
#PASSdataCommunitySummit Keynote Day 3 Live Blog
Today at the PASS Data Community Summit in Seattle, Kimberly Tripp is doing the first-ever in-person community keynote. […]
Office Hours: Read This, Watch This Edition
This week, a lot of the questions you posted at https://pollgab.com/room/brento just need pointers to resources at other […]
Trop d’index tue l’index : supprimez les index inutiles !
Je découvre souvent beaucoup trop d’index dans les bases de données des clients que j’audite… Or tout index […]
Generating Repeatable Sets Of Test Rows
In order to test graph structures, I needed a large set of random data. In some ways, […]
Free Live Webcast: Why is One Query Sometimes Slow and ...
Sometimes the exact same query goes slow out of nowhere. Your current fix is to update statistics, rebuild […]
Un « GREP » pour rechercher un motif dans tous les codes ...
Il est parfois nécessaire de rechercher dans toute l’étendue du code Transact SQL (vues, procédures stockées, fonctions UDF, […]
SQL SERVER – Reasons – Not Able to Shrink the ...
Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they […]
Business Analytics from Application Logs and SQL Server Database using ...
Introduction Splunk is a well-known log management tool. Splunk mines log from different machines in real-time and can […]
How to install SQL Server 2022 step by step
The post How to install SQL Server 2022 step by step appeared first on SQLServerCentral.
sqlserver.exe.config – Invalid XML Syntax
Un bref article afin de relater un cas de figure rencontré récemment chez un client. Pour des raisons […]
SQL Server 2022: Backup Database Options to AWS S3 Bucket ...
The post SQL Server 2022: Backup Database Options to AWS S3 Bucket – Part 2 appeared first on […]
SQL Server 2022: Backup and Restore database to AWS S3 ...
The post SQL Server 2022: Backup and Restore database to AWS S3 bucket – Part 1 appeared first […]
SQL Server Sample Databases
Northwind, Pubs, Aventureworks, AdventureworksDW, WideWordImporters, etc are important sample databases used in SQL Server. In this article, we […]
L’accès aux jeux de données des rapports Power BI dans ...
Dans Power BI Service (le service dans le cloud public de Microsoft), il est assez facile d’accéder […]
SQL SERVER – Script to List Database File Latency
Today, we will see a very interesting script to list database file latency. I use this script […]
Meetup du Club Power BI de Strasbourg, mai 2022
Le 17 mai 2022, le Club Power BI de Strasbourg a organisé un nouveau Meetup sur le […]
Indexing for Delete – SQL in Sixty Seconds #197
In Comprehensive Database Performance Health Check, I often discuss that indexes can reduce the performance of your […]
The Top Feature Requests for SQL Server
If you want to get a look at where Microsoft SQL Server is heading in the future, it […]
SQL SERVER – Find Owner of Database – Change Owner ...
Recently I had the opportunity to help a client with Comprehensive Database Performance Health Check, and while […]
SQL Saturday 1024 – Haiti 2022 – Les AGs par ...
Ce week-end avait lieu le SQL Saturday Haiti, seconde édition. J’ai eu le plaisir de participer à l’évènement […]
SQL Server Graph Tables – Cross Database Surprises
The post SQL Server Graph Tables – Cross Database Surprises appeared first on SQLServerCentral.
Compressed Backup and Performance – SQL in Sixty Seconds #196
During Comprehensive Database Performance Health Check, I was recently asked if I have a handy script that can […]
Arrêt et re-démarrage d’instance SQL Server… Bonne pratique ou pas ...
Parmi les pires pratique que l’on rencontre encore couramment au sujet de Microsoft SQL Server, il y a […]
SQL SERVER – Sample Script for Compressed and Uncompressed Backup
During Comprehensive Database Performance Health Check, I was recently asked if I have a handy script that […]
Can We Please Stop Sending Passwords Over the Wire?
While analyzing SQL Server’s network protocol, I came across a weird fact: when a database client logs in […]
Big Data Clusters: Out of Aces
When this feature was announced in 2018, I wrote: <sarcasm> It’s like linked servers, but since they don’t […]
Running SQL Server on Oracle and Google Cloud
Introduction In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure (OCI) and Google […]
Meet us at SQLBits 2022 and level up as a ...
It has been over two years since we have had the opportunity to meet face-to-face with our data […]
SQL Server Monitoring Using Free Tools
Do you sometimes wonder how the pieces of your SQL Server systems are doing over time? Do you […]
How to replace an identity column with a sequence number
The post How to replace an identity column with a sequence number appeared first on SQLServerCentral.
Performance Tuning Using Free Tools, Part 2
Does the cost of running SQL Server often surprise you? The cost may come from buying on-premises hardware […]
Error Handling Quiz Week: Will a Transaction Help?
In yesterday’s post, we tried a TRY/CATCH, and those of us who actually ran the demo scripts were […]
Query control made easy
Overview As we all know, data security is a never-ending battle. Every day, we hear of new data […]
The SQL Server Posts You Read the Most in 2021
I think of my blog posts in a few different categories: Posts that will only be read at […]
Unity state machine behaviours
The post Unity state machine behaviours appeared first on SQLServerCentral.
Performance Tuning Using Free Tools
Do you frequently upgrade your on-premises hardware in order to keep a certain level of performance? Are your […]
SQL Server Data Classification Comes Alive
Overview Microsoft SQL Server 2012 introduced a feature called data classification, which allows you to mark certain columns […]
Contest: SQL Server 2022 Needs a Slogan.
Now that Microsoft has announced that SQL Server 2022 is coming, it’s time for us to talk about […]
What’s New in SQL Server 2022
Today at Microsoft Ignite, Microsoft started dropping new details on the next version of SQL Server, 2022. Here’s […]
SQL ConstantCare® is Now Available in the UK & EU.
Earlier this year, we opened up training class sales to the EU and UK. Now, we’re taking it […]
SQL Server VM Best Practices
The post SQL Server VM Best Practices appeared first on SQLServerCentral.
SQL Server identity column
The post SQL Server identity column appeared first on SQLServerCentral.
Graphing SQL Server wait stats on Prometheus and Grafana
Wait stats are essential performance metrics for diagnosing SQL Server Performance problems. Related metrics can be monitored […]
Open sourcing the .NET 5 C# Language Extension for SQL ...
For over two decades, the C# programming language has allowed developers to build secure and robust applications within […]
Disable or Enable All SQL Server Agent Jobs
The post Disable or Enable All SQL Server Agent Jobs appeared first on SQLServerCentral.
Register Now For PASS Data Community Summit 2021
The post Register Now For PASS Data Community Summit 2021 appeared first on SQLServerCentral.
Create, Populate, and Subset a Pandas Dataframe from a CSV ...
The post Create, Populate, and Subset a Pandas Dataframe from a CSV File appeared first on SQLServerCentral.