Sites anglophones


Inventory SQL Server Agent Jobs for all Instances with PowerShell

Publié le 25 octobre 2019 sur sqlservercentral.com
 

The post Inventory SQL Server Agent Jobs for all Instances with PowerShell appeared first on SQLServerCentral.

DevOps falling short?

Publié le 25 octobre 2019 sur sqlservercentral.com
 

The post DevOps falling short? appeared first on SQLServerCentral.

SQL SERVER – 2 SQL Server Courses on Pluralsight

Publié le 24 octobre 2019 sur journey to sqlauthority
 

The year 2019 has been wonderful for me as I was fortunate to publish 2 SQL Server Courses on Pluralsight.Analyzing SQL Server Query PlansUsing Memory-optimized Tables and Native Stored ProceduresIf you are into the area of the SQL Server Performance T …

Fixing MLS Python Services to Load the Runtime

Publié le 24 octobre 2019 sur sqlservercentral.com
 

Recently I went to work on a SQL Server 2017 instance and couldn’t get the Python runtime to load. I’d keep getting this error: A strange error for me to see, and one that didn’t quite make sense. How can the runtime not launch? However, restarting the …

Where SQL Server monitoring fits into your tech stack

Publié le 24 octobre 2019 sur sqlservercentral.com
 

The post Where SQL Server monitoring fits into your tech stack appeared first on SQLServerCentral.

Glenn’s Tech Insights For October 23, 2019

Publié le 23 octobre 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 Think Like the SQL Server Engine: What’s the Tipping Point?

Publié le 23 octobre 2019 sur brentozar.com
 

In our last episode, I’d expanded our query to include DisplayName and Age – two columns that weren’t in our nonclustered index:SELECT LastAccessDate, Id, DisplayName, Age FROM dbo.Users WHERE LastAccessDate > ‘2018-09-02 04:00’ OR …

SQL SERVER – Group By Orders Data by Columns Ascending

Publié le 23 octobre 2019 sur journey to sqlauthority
 

SQL Server fundamentals can never get old. Just the other day, while working with a client on Comprehensive Database Performance Health Check, the DBA asked me an interesting question referring to my older blog post How to Know If Index is Forced on Qu …

Troubleshoot Slow RDS SQL Servers with Performance Insights

Publié le 23 octobre 2019 sur sqlservercentral.com
 

The post Troubleshoot Slow RDS SQL Servers with Performance Insights appeared first on SQLServerCentral.

Spring 2020 classes in Chicago, early-bird through end of 2019

Publié le 22 octobre 2019 sur sqlskills.com - paul randall
 

I’ve just released our Spring 2020 in-person classes in Chicago for registration! They will be at our main event hotel as usual in Oakbrook Terrace, and all classes have an early-bird price that expires on 1/1/2020, with an extra $100 discou …

How to Think Like the SQL Server Engine: What’s a Key Lookup?

Publié le 22 octobre 2019 sur brentozar.com
 

In our last couple of queries, we’ve been using a simple query to find the Ids of everyone who accessed the system since mid-2014:SELECT Id FROM dbo.Users WHERE LastAccessDate > ‘2014-07-01′ ORDER BY LastAccessDate; But Ids alone aren’t …

SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as an Installed Service

Publié le 22 octobre 2019 sur journey to sqlauthority
 

Even though SQL 2008 R2 support has been ended there are many clients running this version. Few of my clients are planning to upgrade as soon as possible. One of my clients was doing an in-place upgrade of SQL Server 2008 R2 instance to SQL Server 2014 …

Introduction to the Partition By Window Function

Publié le 22 octobre 2019 sur sqlservercentral.com
 

The post Introduction to the Partition By Window Function appeared first on SQLServerCentral.

Automating Schema Comparisons with SQL Compare Projects and PowerShell

Publié le 22 octobre 2019 sur sqlservercentral.com
 

The post Automating Schema Comparisons with SQL Compare Projects and PowerShell appeared first on SQLServerCentral.

Digging into Azure SQL Database Hyperscale Edition

Publié le 22 octobre 2019 sur sqlservercentral.com
 

This article will look deeper at the Azure SQL Database – Hyperscale edition, which was moved into General Availability (GA) in May 2019. This followed a bit of a preview time, when I first learned about how it worked in detail. I was impressed with th …


Pages :