Sites anglophones


How DevOps can automate the repayment of technical debt

Publié le 24 mai 2018 sur sqlservercentral.com
 

Looking to DevOps automation to try to create the breathing room needed to break out of the vicious cycle of technical debt.

SQL in the City Streamed – Compliant DevOps: June 20 2018

Publié le 24 mai 2018 sur sqlservercentral.com
 

Join Redgate’s livestream on June 20 and learn from Microsoft Data Platform MVPs, Steve Jones, Grant Fritchey, and Kathi Kellenberger. The schedule will include sessions to help you learn how to demonstrate compliance with regulations such as the …

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 …

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 …

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 …

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?


Pages :