Sites anglophones


SQL SERVER – How to Shrink tempDB Database?

Publié le 15 août 2019 sur journey to sqlauthority
 

Just yesterday, I received an email from a client who had hired me last year for Comprehensive Database Performance Health Check. While I worked with them last year, they were struggling with the performance of the server. We scientifically and strateg …

How Often Do You Give Your Server a Physical?

Publié le 15 août 2019 sur sqlservercentral.com
 

A good doctor knows their patients – literally – inside out.  They know the history of health and illness, what the patient has continuing issues with (maybe allergies, sinuses, or in more serious cases, diabetes or cancer), and how we …

SQL Server Logon Trigger Examples

Publié le 15 août 2019 sur sqlservercentral.com
 

The post SQL Server Logon Trigger Examples appeared first on SQLServerCentral.

Making the switch to SQL Monitor

Publié le 15 août 2019 sur sqlservercentral.com
 

The post Making the switch to SQL Monitor appeared first on SQLServerCentral.

DBA Training Plan 11: The Basics of Executing a Query

Publié le 14 août 2019 sur brentozar.com
 

Up til now in the DBA Training Plan, we’ve been taking inventory of our servers, making sure the data’s well-protected, and understanding the basics of how the data’s stored in indexes inside those data files. Now, let’s start l …

SQL SERVER – Show Primary Key for a Single Table – sp_pkeys

Publié le 14 août 2019 sur journey to sqlauthority
 

When I work with Comprehensive Database Performance Health Check, I get all sort of questions and I love answering them. Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored …

Find SQL Server Integer Columns to Make Skinnier

Publié le 14 août 2019 sur sqlservercentral.com
 

The post Find SQL Server Integer Columns to Make Skinnier appeared first on SQLServerCentral.

How to stop standardization being a stumbling block in database DevOps

Publié le 14 août 2019 sur sqlservercentral.com
 

The post How to stop standardization being a stumbling block in database DevOps appeared first on SQLServerCentral.

DBA Training Plan 10: Managing Index Fragmentation

Publié le 13 août 2019 sur brentozar.com
 

In the last episode, we looked at your index designs with the output of sp_BlitzIndex. You might have gotten a little overwhelmed what with all the different warnings (and all the learning resources!) You might have thought, “Is there an easier w …

SQL SERVER – Power Options, Power Plans and Database Performance

Publié le 13 août 2019 sur journey to sqlauthority
 

Everyone knows that I love my job and particularly solving SQL Server Performance Problems. Recently I ended up a very interesting scenario when working with my client on Comprehensive Database Performance Health Check. After a careful investigation in …

How to convince your boss you need SQL Server monitoring

Publié le 13 août 2019 sur sqlservercentral.com
 

The post How to convince your boss you need SQL Server monitoring appeared first on SQLServerCentral.

Contribute to the SQLCop Project

Publié le 13 août 2019 sur sqlservercentral.com
 

The SQL Cop project is an open source set of tests that help promote code quality by looking for common poor T-SQL coding practices. These tests are based on the tsqlt framework and run within its structure. You can add the SQL Cop tests to your databa …

Executing Dynamic SQL Using sp_executesql

Publié le 13 août 2019 sur sqlservercentral.com
 

The post Executing Dynamic SQL Using sp_executesql appeared first on SQLServerCentral.

Redgate Takes over the SQLCop Project

Publié le 13 août 2019 sur sqlservercentral.com
 

I am happy to announce the Redgate Software and I are supporting and taking over stewardship of the SQL Cop project at this point. With permission from its founder, George Mastros, we will host the main repository for the project at https://www.github. …

DBA Training Plan 9: My 3 Index Guidelines

Publié le 12 août 2019 sur brentozar.com
 

In our last episode, we used sp_BlitzIndex @Mode = 2 to get to know the contents of our database, sorted our indexes from biggest to smallest, and started asking questions about leftover backup tables that we probably didn’t need to keep around a …


Pages :