Sites anglophones

Monitoring Distributed SQL Servers using SQL Monitor

Publié le 22 mai 2018 sur

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

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

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

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

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

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

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

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

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 …

[Video] Office Hours 2018/5/16 (With Transcriptions)

Publié le 20 mai 2018 sur

This week, Brent, Erik, Tara, and Richie are back in action again to and are discussing sys.dm_db usage stats, Availability Group troubleshooting, ASYNC Network IO issue, reasons for using a contained database, whether you need to add more CPUs if faci …

How to Generate Fibonacci Series for the First 1000 Values? – Interview Question of the Week #174

Publié le 20 mai 2018 sur journey to sqlauthority

Question: How to Generate Fibonacci Series for the First 1000 Values? The reason, behind this question, is very simple, if you search online you will find the most of the answers only find the first 70 or maximum 80 values of the Fibonacci series. …

SQL SERVER – SQL Server Cluster Resource Doesn’t Come Online Randomly

Publié le 19 mai 2018 sur journey to sqlauthority

This was another interesting situation where client reported that their SQL Server Cluster resource, sometimes, fail to come online when they perform failover of SQL Server from one node to another. In this blog, we would learn how to fix ” SQL S …

Stuff People Tell Me Is The Default

Publié le 18 mai 2018 sur

Playing The Odds Assuming that life carries on as usual for a couple more weeks, I’ll have been a consultant here for three years. In that time, I’ve had some really interesting conversations with people, mostly about why things are the way …

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

Publié le 18 mai 2018 sur

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL’s rich metadata makes this very easy to automate in a robust fashion.

Pages :