Sites anglophones


SQL SERVER – Parallel Redo on AlwaysOn Secondary – DIRTY_PAGE_TABLE_LOCK

Publié le 24 mai 2018 sur journey to sqlauthority
 

As most of you might know that my expert area in SQL Server in performance tuning. But, I also deal with almost every issue related to SQL Server engine. Many times, it so happens then clients call me for performance tuning and while fixing, we see som …

SQLskills SQL101: Why do some wait types need to be ignored?

Publié le 23 mai 2018 sur sqlskills.com - paul randall
 

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 man …

How to Reduce the CPU Overhead of Dynamic SQL

Publié le 23 mai 2018 sur brentozar.com
 

Dynamic SQL is a good choice for catch-all type queries, but you have to be careful how you execute the dynamic string. For frequently executed queries, “EXEC sp_executesql @sql”is a good choice but at the risk of encountering parameter sni …

SQL SERVER – Setup / Installation Error – Updating Permission Setting for File ResumeKeyFilter.Store Failed

Publié le 23 mai 2018 sur journey to sqlauthority
 

My client contacted me for a quick assistance in a setup trouble. She informed me that it’s a brand-new install and its failing at the end. She was installing SQL Server 2016 on Windows Server 2016. Let us learn about how to fix Installation …

Trivial Plans, Simple Parameterization and Check Constraints

Publié le 22 mai 2018 sur brentozar.com
 

Trivial Plans Are Weird They’re the optimizer’s “Yes, Dear”.  The thing is, sometimes “Yes, Dear” can miss some important details. Cost based decisions about operators Potential index improvements Contradiction …

Why Are You Dropping and Recreating Your Indexes?

Publié le 22 mai 2018 sur sqlservercentral.com
 

Do you have data load processes that drop indexes to optimize the load process? Are you dropping those indexes in one step, then loading data into your table, only to recreate the indexes in a post data load step?

2018 State of DevOps Report

Publié le 22 mai 2018 sur sqlservercentral.com
 

Redgate is joining forces with DevOps Research and Assessment (DORA) and Google Cloud to support the pursuit of DevOps excellence. The research aim is to better understand the DevOps landscape, and to surface new findings that provide guidance for impr …

Scheduling a PowerShell Script Using SQL Server Agent

Publié le 22 mai 2018 sur sqlservercentral.com
 

This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.

Monitoring Distributed SQL Servers using SQL Monitor

Publié le 22 mai 2018 sur sqlservercentral.com
 

Many organizations are experiencing rapid expansion and diversification of their SQL Server estate to include Cloud, VMWare and other platforms, alongside traditional on-premise servers. This article explains the basic architecture and components of SQ …

SQL SERVER – Maintenance Plan Error: Failed to Acquire Connection “Local Server Connection”.

Publié le 22 mai 2018 sur journey to sqlauthority
 

One of my clients had an interesting situation where none of the SQL Maintenance plans were working. The example what I am using here is a SQL Server backup maintenance plan failing. I also saw a behavior where all the individual jobs were working fine …

Building SQL ConstantCare®: Adding Daily Emails and Recognizing Your Work

Publié le 21 mai 2018 sur brentozar.com
 

When we first launched SQL ConstantCare®, the workflow was: You sent in data about your SQL Servers daily Our systems sent us (not you) recommendations on what to do Once a week, we reviewed those recommendations, made sure they made sense, ad …

The State of SQL Server Monitoring 2018

Publié le 21 mai 2018 sur sqlservercentral.com
 

Over 600 technology professionals who work in organizations that use SQL Server recently responded to our survey to discover the current state of SQL Server monitoring.

SQL Server on Linux, does it have Microsoft’s full attention?

Publié le 21 mai 2018 sur sqlservercentral.com
 

SQL Server on Linux doesn’t support Ubuntu 18.04 LTS. Why weren’t Microsoft ready for the next LTS release?

Working with Windows Containers and Docker: Save the Data

Publié le 21 mai 2018 sur sqlservercentral.com
 

Docker continues to make improvements in their products running on Windows. In this article, Nicolas Prigent explains how to share data between Windows containers and the container host. As a bonus, he also shows how to run a Linux container on Windows …

SQL SERVER – Unable to Bring SQL Cluster Online – Reason: The Account is Disabled

Publié le 21 mai 2018 sur journey to sqlauthority
 

This was one of an interesting issue reported by my client. They informed that after some hardening by the security team, they are not able to bring SQL resource online in the cluster. In this blog, we would learn about how to fix the issue where SQL c …


Pages :