Sites anglophones


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.

Introduction to DevOps: DevOps and the Database

Publié le 8 août 2019 sur simple-talk.com
 

The series so far: Introduction to DevOps: The Evolving World of Application Delivery Introduction to DevOps: The Application Delivery Pipeline Introduction to DevOps: DevOps and the Database DevOps has been gaining steady ground in the world of applic …

SQLskills SQL101: Upgrading to a Different Edition of SQL Server

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

SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologies used the wrong way, or where there are many misunderstandings that …

What columns are in that index?

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

I’ve been helping several customers with tuning lately, which typically means I’m also looking at indexes and asking questions. A pattern I’ve noticed is columns from the clustering key being added to the key definition for the nonclu …

SQL SERVER – DELETE Qualified Rows From Multiple Tables – Part 2

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

Earlier this week, I had announced a contest to get Recorded PASS of my extremely popular training SQL Server Performance Tuning Practical Workshop – Recorded Classes. As the price of this class high, I wanted to keep my contest difficult as …

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

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

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to on …

Problems Caused by Use of the SQL_VARIANT Datatype

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

The post Problems Caused by Use of the SQL_VARIANT Datatype appeared first on SQLServerCentral.

SQL Server Diagnostic Information Queries for August 2019

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

This month, I have added a new set of queries for SQL Managed Instance. If you are using SQL Managed instance, please try it out and let me know what you think.I have a T-SQL script that you can use to check whether your instance of SQL Server has been …

Yes and No Questions Are Not So Simple

Publié le 7 août 2019 sur simple-talk.com
 

Yes! We Have No Bananas Song by Frank Silver and Irving Cohn There’s a fruit store on our street It’s run by a Greek. And he keeps good things to eat But you should hear him speak! When you ask him anything, he never answers “no …

SQL SERVER – Best Value for Max Worker Count

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

I have been working as a SQL Server Performance Tuning Consultant for over 10 years. During the last 10 years, I have worked with over 100s of clients helping them with Comprehensive Database Performance Health Check. My experience says that most of th …

Relational Databases vs Graph Databases

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

The post Relational Databases vs Graph Databases appeared first on SQLServerCentral.


Pages :