
How to Determine Read Intensive and Write Intensive Tables in SQL Server? – Interview Question of the Week #251
Question: How to Determine Read Intensive and Write Intensive Tables in SQL Server?Answer: I was really asked this question in the recent consulting engagement. What I love most about my job as a Comprehensive Database Performance Health Check is …

So, uh, you can, like, draw me in SSMS.
Adrian Sullivan and Michael J. Swart have way too much time on their hands, because Adrian just posted this T-SQL gist, which draws … me: It uses the spatial results feature in SSMS. My mind is blown. I’m totally going to use that in a dem …

SQL SERVER – Create Index Without Locking Table
Indexes are the last option we consider when we do a Comprehensive Database Performance Health Check. 3 out of 4 clients, I work on the health check, we end up not creating new indexes. Most of the time we spend time looking at the indexes when removed …

AMD Ryzen 9 3950X Processor Released
IntroductionOn November 14, 2019, the review embargo for the AMD Ryzen 9 3950X mainstream desktop processor expired. As a result, there were a flood of written and video reviews of AMD’s new flagship processor for the mainstream market segment. T …

I’m coming to SQL Saturday Stockholm! Registration is open now.
Hello again, Sweden! I’m coming to SQL Saturday Stockholm in May 2020. I’ll be teaching my Performance Tuning in 21 Demos workshop: You’re a developer or DBA who wants to tune indexes and queries to make your application go faster. Yo …

MariaDB Learning Path – Five Online Pluralsight Courses
I am very delighted to announce that I have just published five video courses on the Pluralsight about Learning MariaDB. I am indeed very delighted to share my suggestion about MariaDB Learning Path.MariaDB Learning PathCourse 1: Querying Data from Mar …
New release: SQL Prompt 10
The post New release: SQL Prompt 10 appeared first on SQLServerCentral.
How to Configure CI/CD in AzureDevOps
The post How to Configure CI/CD in AzureDevOps appeared first on SQLServerCentral.

SQL ConstantCare® Now Gives Index Advice, Too.
When I was a DBA, I got so sick and tired of monitoring tools and scripts yelling at me to make a million different changes – most of which didn’t really have any measurable impact on performance or reliability. Sure, I want things to go fa …

SQL SERVER – Find the Growth Size for All files in All Databases – Part 2
A few years ago, I had written a blog post Find the Growth Size for All files in All Databases. The original script had some error related to counting the size as pointed out by the SQL Server expert John Fowler, however, I never got around to correct …
Unwrapping, Unboxing and Installing SQL Clone
The post Unwrapping, Unboxing and Installing SQL Clone appeared first on SQLServerCentral.
Power BI Workbooks
The post Power BI Workbooks appeared first on SQLServerCentral.
How to Decipher @@Options
There is a variable in SQL Server called @@OPTIONS. This contains all of the settings that you have configured using the SET command. However, understanding the values inside of this variable can be a bit cumbersome. This article will show you a quick …

The Many Problems with SQL Server’s Index Recommendations
These days, I jump back & forth a lot between SQL Server and Postgres. (We use AWS Aurora Postgres to store SQL ConstantCare®‘s data.) Whenever I come back to the sweet, sweet graphical execution plans in SQL Server Management Studio, I b …

SQL SERVER 2019 – Supports Compatibility Level from 2008 to 2019
Earlier last week SQL SERVER 2019 is Released. It has been an amazing experience to download and work with this new version. As I have been working for almost 20 years with SQL Server, I want SQL Server to be robust and stable, while performing better …