Sites anglophones


Using a Server List to Control PowerShell Scripts

Publié le 29 janvier 2019 sur simple-talk.com
 

As I started to use PowerShell more and more, one of the reasons I found it useful, as have many DBAs, is that it permits running the same script across multiple servers. The scripts in my last article took advantage of this capability. One of the reas …

Announcing the Official Release of the Consultant Toolkit

Publié le 29 janvier 2019 sur brentozar.com
 

You’re a consultant, and you need to get diagnostic data from your clients’ SQL Servers. You’ve been copy/pasting queries and results from SSMS, trying to save execution plans one by one, wasting time doing manual labor. That stops ri …

Overview of Azure SQL Database Performance Monitoring

Publié le 29 janvier 2019 sur sqlservercentral.com
 

Transitioning to the Platform-as-a-Service model typically implies relinquishing certain degree of control over your computing environment. One of the primary concerns related to this transition is diminished level of transparency providing insights in …

Database Development in Visual Studio using SQL Change Automation: Getting Started

Publié le 29 janvier 2019 sur sqlservercentral.com
 

SQL Change Automation (SCA) is a tool designed to help you automate and optimize the way you develop, build, test, and release SQL Server databases, including integration with source control. In this article, the first in a short series, Steve show’s y …

SSRS Scale Out with Standard Edition Containers and Instances

Publié le 29 janvier 2019 sur sqlservercentral.com
 

Learn how to use database cloning to scale out your reporting services workload.

SQL Server Integration Services (SSIS) – There Was an Exception While Loading Script Task from XML

Publié le 29 janvier 2019 sur journey to sqlauthority
 

Recently one of my old clients contacted me for an error execution via SQL Agent Job. They informed that it runs fine when they invoke the package from Visual Studio (SSDT). In this blog post, we will discuss Exception While Loading Script Task from XM …

Updated First Responder Kit with Your January Code Resolutions

Publié le 28 janvier 2019 sur brentozar.com
 

I have a sneaking suspicion that a bunch of you made New Year’s Resolutions to contribute to open source, because y’all got started with a bang this year. We’ve even got improvements from Microsoft folks for Azure Managed Instances! Y …

How to do Accurate Address Masking using Data Masker

Publié le 28 janvier 2019 sur sqlservercentral.com
 

Grant outlines a set of methods in SQL Data Masker that achieve both fake and accurate address data, and data distribution.

Stairway to SSAS Tabular Level 5: Cleaning up Dimensions

Publié le 28 janvier 2019 sur sqlservercentral.com
 

In this fifth level of the SSAS Tabular stairway, learn how to clean up dimensions.

SSMS – Azure Storage Error – A Connection Attempt Failed Because the Connected Party did not Properly Respond After a Period of Time

Publié le 28 janvier 2019 sur journey to sqlauthority
 

This was an interesting situation where I learned something new. In this blog we would learn about error – “A connection attempt failed because the connected party did not properly respond after a period of time.” while using “A …

What is Trusted Constraint in SQL Server? – Interview Question of the Week #210

Publié le 27 janvier 2019 sur journey to sqlauthority
 

Question: What is Trusted Constraint in SQL Server? Answer: I received this question during my recent SQL Server Performance Tuning Practical Workshop. I think it is a very interesting concept and I have seen many experts also do not know abo …

SQL SERVER – Error 0x800f081e or ErrorCode: – 2146498530 While Installing SQL Server Management Studio (SSMS)

Publié le 26 janvier 2019 sur journey to sqlauthority
 

While installing SQL Server Management Studio 18.0 (Preview) on my lab server, I got an error. In this blog, we would learn about error 0x800f081e which you also might see while installing other software also. Here is the screenshot of the error 0x800f …

How to Think Like the Engine – 2019 Edition

Publié le 25 janvier 2019 sur brentozar.com
 

You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this series of videos, you’ll learn how t …

Protecting Production Data in Non-Production Environments

Publié le 25 janvier 2019 sur sqlservercentral.com
 

How can you best keep production data secure when it is outside the production environment? Microsoft MVP Grant Fritchey discusses the use of dynamic data masking in production and pre-production servers, and then the strategies that can help us protec …

SQL SERVER – Fix: 400 – Bad Request Authentication Failed for Account and the Provided Key. Please Provide a Valid Key and Try Again

Publié le 25 janvier 2019 sur journey to sqlauthority
 

While helping a client with Azure environment, I came across an interesting error. I this blog I would explain cause and fix of error “Authentication failed for account sqlauthprembackup and the provided key. Please provide a valid key and try ag …


Pages :