Sites anglophones


Making the database key to DevOps with comprehensive, customizable monitoring

Publié le 19 juillet 2018 sur sqlservercentral.com
 

The speed of business today demands that the development and deployment of applications is fast-moving, with frequent yet error-free releases. That’s why the adoption of DevOps is trickling down from Amazon, Facebook, Google and the other usual s …

SQL SERVER – Backup Error: 3636 – An Error Occurred While Processing BackupMetadata

Publié le 19 juillet 2018 sur journey to sqlauthority
 

Recently one of my old clients contacted me and informed that they are having an issue with database backup on the secondary replica. In this blog we would learn about how to fix error 3636 – An error occurred while processing BackupMetadata. I h …

SQL Server 2016 SP2 CU2 Available

Publié le 18 juillet 2018 sur sqlskills.com - glen berry
 

On July 16, 2018, Microsoft released SQL Server 2016 SP2 CU2, which is Build 13.0.5153.0. There are 21 fixes in the public fix list, including a number of fixes in the SQL performance, SQL Engine, and High Availability fix areas. Microsoft has also rel …

A Quirk In Parallel Hash Join Plans

Publié le 18 juillet 2018 sur brentozar.com
 

Bailing, Takes Me Away Both of these queries will return zero rows, in the 2010 version of the Stack Overflow database.SELECT COUNT(*) AS records FROM dbo.Votes AS v JOIN dbo.Posts AS p ON v.UserId = p.OwnerUserId WHERE v.CreationDate >= ‘2011-01-01 …

Creating a Logical SQL Server: Level 2 of the Stairway to Azure SQL Database

Publié le 18 juillet 2018 sur sqlservercentral.com
 

In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.

SQL Server Reporting Services Rest API

Publié le 18 juillet 2018 sur sqlservercentral.com
 

What functionality is available in the SQL Server Reporting Services REST API and how should you use it?

SQL SERVER – Backup to URL – Script to Perform Stripped Backup using Shared Access Signature (SAS)

Publié le 18 juillet 2018 sur journey to sqlauthority
 

Here are my previous blogs about Backup to URL, I have share scripts to take backup using Access Keys and SAS Token. One of my blog readers wanted to take stripped backup to Azure Blob. In this blog, I am sharing the script to perform a stripped backup …

Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5

Publié le 17 juillet 2018 sur simple-talk.com
 

The series so far: Power BI Introduction: Tour of Power BI — Part 1 Power BI Introduction: Working with Power BI Desktop — Part 2 Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3 Power BI Introduction: Workin …

A New tempdb Trace Flag Appears!

Publié le 17 juillet 2018 sur brentozar.com
 

Coming Around Microsoft has been doing a good job of taking stuff that used to be Wizard Hat and making it part of out of the box functionality. Starting with SQL Server 2016, you didn’t need to keep these in your setup checklist: Trace flag 1118 …

Setting Permissions to Drop a Database

Publié le 17 juillet 2018 sur sqlservercentral.com
 

Learn which permissions are required to drop a database and see a test to show that these apply.

Using SQL Server’s Default Trace to Identify Autogrow Events in tempdb

Publié le 17 juillet 2018 sur sqlservercentral.com
 

We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases yo …

SQL SERVER – Backup to URL – Script to Generate Credential and Backup using Shared Access Signature (SAS)

Publié le 17 juillet 2018 sur journey to sqlauthority
 

As I mentioned in my earlier blog, backup to URL is one of the common methods used in SQL Server performs a backup to Azure Blob Storage. In this blog, I am going to share a script to generate the create credential and backup command using Shared Acces …

Building SQL ConstantCare®: What Cloud Hosting Costs

Publié le 16 juillet 2018 sur brentozar.com
 

In our behind-the-scenes posts about building SQL ConstantCare®, I’ve written about how we picked serverless architecture for the application layer, and how picked AWS Aurora for the database layer. Hosting costs were a big driving factor in …

What Do You Want to Learn This Fall?

Publié le 16 juillet 2018 sur brentozar.com
 

New class survey We’re designing a new round of courses for the fall. Let us know what you want to learn in this short survey. After you take it, you get to see the answers, too, so you can learn what other folks wanna learn. What do you want to …

Fixing ‘A required Privilege is not held by client’ Error

Publié le 16 juillet 2018 sur sqlservercentral.com
 

This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out . A required privilege is not held by the client. The step failed.


Pages :