L'actualité technique MS SQL Server en France (et ailleurs)

journey to sqlauthority

Maximize the Business Impact with Quest EMPOWER
You do not want to miss out on signing up with Quest EMPOWER. I will be there […]

19 septembre 2022 dans Sites anglophones étiqueté Quest / SQL par journey to sqlauthority

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 […]

24 août 2022 dans Sites anglophones étiqueté Shrinking Database / SQL Log / SQL Server / SQL Tips and Tricks / System Database par journey to sqlauthority

Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is […]

2 août 2022 dans Sites anglophones étiqueté SQL Column / SQL in Sixty Seconds / SQL Video par journey to sqlauthority

Accessing Relational Databases in Go at Pluralsight
I just released my 42nd course on the learning platform Pluralsight. It was fun to build this […]

25 juillet 2022 dans Sites anglophones étiqueté Go Lang / Pluralsight / SQL par journey to sqlauthority

Hybrid Cloud Monitoring
For years database server’s were hosted on either on-premises or colocation data centers. It was straightforward to […]

28 juin 2022 dans Sites anglophones étiqueté Idera / MySQL / SQL par journey to sqlauthority

Real-Time Monitoring of MySQL Server
When an application runs without any glitch in business, no one bothers. However, as soon as the […]

23 juin 2022 dans Sites anglophones étiqueté Idera / MySQL / SQL par journey to sqlauthority

File-Based Log Monitoring on AWS MYSQL RDS
We have often seen that one solution often does not have multiple different scenarios in the real […]

21 juin 2022 dans Sites anglophones étiqueté Idera / MySQL / SQL par journey to sqlauthority

MYSQL Long Running Queries
When any business or application begins, the amount of the data is limited, and the complexity of […]

16 juin 2022 dans Sites anglophones étiqueté Idera / MySQL / SQL par journey to sqlauthority

Find Database File Latency – SQL in Sixty Seconds #198
Lots of people asked me to create a video on my earlier blog post SQL SERVER – […]

15 juin 2022 dans Sites anglophones étiqueté SQL DMV / SQL in Sixty Seconds / SQL IO / SQL Performance / SQL Server Files / SQL Video par journey to sqlauthority

Tracking Changes in MySQL Configuration
What will you do if your system working perfectly fine, suddenly starts slowing down to the point […]

14 juin 2022 dans Sites anglophones étiqueté Idera / MySQL / SQL par journey to sqlauthority

Challenges Monitoring MySQL Performance
MySQL is one of the most popular relational database management systems (RDBMS). Applications are now becoming more […]

9 juin 2022 dans Sites anglophones étiqueté Idera / MySQL / SQL par journey to sqlauthority

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 […]

7 juin 2022 dans Sites anglophones étiqueté Disk / SQL DMV / SQL IO / SQL Performance / SQL Scripts / SQL Server par journey to sqlauthority

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 […]

13 mai 2022 dans Sites anglophones étiqueté SQL Index / SQL Performance / SQL Server / SQL Video par journey to sqlauthority

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 […]

3 mai 2022 dans Sites anglophones étiqueté SQL Scripts / SQL Server / SQL Server Security / SQL Tips and Tricks par journey to sqlauthority

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 […]

12 avril 2022 dans Sites anglophones étiqueté SQL Backup / SQL in Sixty Seconds / SQL Restore / SQL Server / SQL Video par journey to sqlauthority

Quest Database Training Days 2022 are Back
Quest Database Training Days 2022 are Back! Join free, interactive sessions led by Brent Ozar, Pinal Dave, […]

4 avril 2022 dans Sites anglophones étiqueté Quest / SQLAuthority News par journey to sqlauthority

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 […]

21 mars 2022 dans Sites anglophones étiqueté SQL Backup / SQL Scripts / SQL Server / SQL Tips and Tricks par journey to sqlauthority

Pinned Tab – SSMS Efficiency Tip – SQL in Sixty ...
This is a follow up of my earlier blog which got instant popular Split Screen for SSMS […]

9 septembre 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Server / SQL Server Management Studio / SQL Tips and Tricks / SSMS par journey to sqlauthority

Split Screen for SSMS Efficiency – SQL in Sixty Seconds ...
I do Comprehensive Database Performance Health Check for living, I work with the SSMS most of the […]

8 septembre 2020 dans Sites anglophones étiqueté SQL Server / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

Nonclustered Primary Key – SQL in Sixty Seconds #119
One of my clients of Comprehensive Database Performance Health Check recently faced a very interesting situation. I […]

7 septembre 2020 dans Sites anglophones étiqueté Primary Key / SQL Constraint and Keys / SQL Index / SQL Scripts / SQL Server / SQL Video par journey to sqlauthority

When was Stored Procedure Last Compiled? – Interview Question of ...
Question: When was Stored Procedure Last Compiled? Answer: Honestly, it is difficult to figure out when was […]

6 septembre 2020 dans Sites anglophones étiqueté SQL Cache / SQL Interview Questions and Answers / SQL Performance / SQL Scripts / SQL Server / SQL Stored Procedure par journey to sqlauthority

Recent Execution of Stored Procedure – SQL in Sixty Seconds ...
What I enjoy the most is working with different clients on Comprehensive Database Performance Health Check. Every […]

5 septembre 2020 dans Sites anglophones étiqueté SQL DMV / SQL in Sixty Seconds / SQL Server Management Studio / SQL Stored Procedure / SQL Video / SSMS par journey to sqlauthority

Full-Screen Execution Plan – SQL in Sixty Seconds #117
I spend my most of time in a day helping client improve their SQL Server Performance at […]

4 septembre 2020 dans Sites anglophones étiqueté Execution Plan / SQL Performance / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

Recover Crashed Query in SSMS – SQL in Sixty Seconds ...
Has it ever happened to you when you are working on a large SQL Server query and […]

3 septembre 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Server / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

Activity Monitor and Running Query – SQL in Sixty Seconds ...
Activity Monitor can come handy when you are in trouble as well. In this video, we will […]

2 septembre 2020 dans Sites anglophones étiqueté Execution Plan / SQL Activity Monitor / SQL in Sixty Seconds / SQL Scripts / SQL Server / SQL Tips and Tricks par journey to sqlauthority

Email an Execution Plan – SQL in Sixty Seconds #114
Most part of my day is spent doing Comprehensive Database Performance Health Check with different organizations. During […]

1 septembre 2020 dans Sites anglophones étiqueté Execution Plan / SQL in Sixty Seconds / SQL Server / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

Execution Plan – Estimated vs Actual – SQL in Sixty ...
During the Comprehensive Database Performance Health Check, I often get the question about Estimated vs Actual Execution […]

31 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL in Sixty Seconds / SQL Performance / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

What Happens If the Clustered Index is Disabled? – Interview ...
Question: What Happens If the Clustered Index is Disabled? Answer: If you disable the clustered index, you […]

30 août 2020 dans Sites anglophones étiqueté Clustered Index / SQL Error Messages / SQL Index / SQL Interview Questions and Answers / SQL Scripts / SQL Server par journey to sqlauthority

Building a Personal Brand and a Bit About SQL with ...
Recently I got the opportunity to feature on the Podcast of amazing DeveloperWeekly by Barry Luijbregts. It […]

29 août 2020 dans Sites anglophones étiqueté Podcast / SQLAuthority News par journey to sqlauthority

Who Dropped Your Table? – SQL in Sixty Seconds #112
Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. […]

28 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Reports / SQL Scripts / SQL Server / SQL Server Security / SQL Video par journey to sqlauthority

Single Column Single Row and TABLE SCAN – SQL in ...
Can a single column and single row result do an entire table scan? I recently got this […]

27 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL in Sixty Seconds / SQL Operator / SQL Performance / SQL Scripts / SQL Server / SQL Video par journey to sqlauthority

Dirty Read with NOLOCK – SQL in Sixty Seconds #110
My primary job is that help various organizations to tune their SQL Server performance Comprehensive Database Performance […]

26 août 2020 dans Sites anglophones étiqueté SQL Performance / SQL Scripts / SQL Server / SQL Video / Transaction Isolation par journey to sqlauthority

Undo Human Errors in SQL Server – SQL in Sixty ...
In this blog post, we are going to talk about how to undo human errors in SQL […]

25 août 2020 dans Sites anglophones étiqueté SQL Backup / SQL in Sixty Seconds / SQL Restore / SQL Scripts / SQL Server / SQL Video par journey to sqlauthority

Solve Puzzle about Data type – SQL in Sixty Seconds ...
A very interesting puzzle, where you see the data type conversion in action. I have previously blogged […]

24 août 2020 dans Sites anglophones étiqueté Data Type / SQL in Sixty Seconds / SQL Puzzle / SQL Scripts / SQL Server / SQL Video par journey to sqlauthority

How to Insert Multiple Values into Multiple Tables in a ...
Question: How to Insert Multiple Values into Multiple Tables in a Single Statement? Answer: One of the […]

23 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL Interview Questions and Answers / SQL Scripts / SQL Server par journey to sqlauthority

Move TempDB for Performance – SQL in Sixty Seconds #107
Just another day while working with a client Comprehensive Database Performance Health Check, we figured out that […]

22 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Performance / SQL Server / SQL TempDB / SQL Video par journey to sqlauthority

Do MAX(col) Scan Table? – SQL in Sixty Seconds #106
Query tuning and optimization is my favourite thing when I am working on a Comprehensive Database Performance […]

21 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL Operator / SQL Performance / SQL Scripts / SQL Server / SQL Table Operation / SQL Video par journey to sqlauthority

Rollback TRUNCATE – Script – SQL in Sixty Seconds #105
One of the most popular questions, I keep on receiving is that – Is it possible to […]

20 août 2020 dans Sites anglophones étiqueté SQL Performance / SQL Scripts / SQL Server / SQL Video / SSMS par journey to sqlauthority

SQL SERVER – Live Query Statistics – SQL in Sixty ...
It is very easy to know what is the queries past and future with the help of […]

19 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL in Sixty Seconds / SQL Performance / SQL Server / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

SQL SERVER – Offline, Detach and Drop – Differences – ...
During the recent consulting engagement of Comprehensive Database Performance Health Check, I was asked by my client, […]

18 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Scripts / SQL Server / SQL Video / SSMS / System Object par journey to sqlauthority