Sites anglophones


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 …

SQL SERVER – Detecting CPU Pressure with Wait Statistics

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

Last week, I had a very interesting situation where client believed they had an issue their slow running server. They sent me a few initial details about their server and after looking at that I told them that they have a CPU pressure issue. They were …

Measuring the Right Things

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

measure The post Measuring the Right Things appeared first on SQLServerCentral.

How to boost team productivity with SQL Clone 4

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

The post How to boost team productivity with SQL Clone 4 appeared first on SQLServerCentral.

Dynamic SQL for beginners in 33 minutes

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

Dynamic SQL is SQL that created and executed at run-time. It sounds complicated, but it really isn’t. Dynamic SQL is useful in solving many tasks. But it does bring with it risks. About the advantages and threats of dynamic SQL will be this artic …

Glenn’s Tech Insights For August 11, 2019

Publié le 11 août 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …

How to Skip Top N Rows in SQL Server? – Interview Question of the Week #237

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

Question: How to skip top N Rows in SQL Server and retrieve the rest of the rows?Answer: I had asked the above question in one of the interviews last week and to my surprise, I have received a lot of solution with the help of Ranking Function, TempTabl …

SQL SERVER – Patch Install Rule Error – Not Clustered or the Cluster Service is Up and Online

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

As they say, there are many ways to bell a cat. But in my consulting career, I have seen the same error due to multiple causes. In this blog, we would talk about one such error which can be seen during the installation of a service pack or cumulative u …

SQLskills at the PASS Summit

Publié le 9 août 2019 sur SQLSkills.com - Erin Stellato
 

The PASS Summit is coming up this fall in Seattle, and it will be here before you know it.  Though I want to mention that I am thoroughly enjoying summer and really not ready for pumpkin anything!  I’m returning to Summit this year, as …

SQL SERVER – Changing Max Worker Count for Performance

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

Earlier this week, I wrote a blog post about SQL SERVER – Best Value for Max Worker Count, after reading this blog post, I got quite a lots of questions via email, LinkedIn and on Twitter to share my when it is appropriate to change Max Worker Co …

Power BI Bubble Map, Shape Map and Filled Map Examples

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

powe The post Power BI Bubble Map, Shape Map and Filled Map Examples appeared first on SQLServerCentral.

Find out exactly what SQL Monitor can save you

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

The post Find out exactly what SQL Monitor can save you appeared first on SQLServerCentral.


Pages :