Sites anglophones


How to Determine Read Intensive and Write Intensive Tables in SQL Server? – Interview Question of the Week #251

Publié le 17 novembre 2019 sur journey to sqlauthority
 

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.

Publié le 16 novembre 2019 sur brentozar.com
 

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

Publié le 16 novembre 2019 sur journey to sqlauthority
 

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

Publié le 15 novembre 2019 sur sqlskills.com - glen berry
 

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.

Publié le 15 novembre 2019 sur brentozar.com
 

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

Publié le 15 novembre 2019 sur journey to sqlauthority
 

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

Publié le 15 novembre 2019 sur sqlservercentral.com
 

The post New release: SQL Prompt 10 appeared first on SQLServerCentral.

How to Configure CI/CD in AzureDevOps

Publié le 15 novembre 2019 sur sqlservercentral.com
 

The post How to Configure CI/CD in AzureDevOps appeared first on SQLServerCentral.

SQL ConstantCare® Now Gives Index Advice, Too.

Publié le 14 novembre 2019 sur brentozar.com
 

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

Publié le 14 novembre 2019 sur journey to sqlauthority
 

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

Publié le 14 novembre 2019 sur sqlservercentral.com
 

The post Unwrapping, Unboxing and Installing SQL Clone appeared first on SQLServerCentral.

Power BI Workbooks

Publié le 14 novembre 2019 sur sqlservercentral.com
 

The post Power BI Workbooks appeared first on SQLServerCentral.

How to Decipher @@Options

Publié le 14 novembre 2019 sur sqlservercentral.com
 

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

Publié le 13 novembre 2019 sur brentozar.com
 

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

Publié le 13 novembre 2019 sur journey to sqlauthority
 

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 …


Pages :