Sites anglophones


Election Injection

Publié le 20 juillet 2018 sur brentozar.com
 

Setting politics aside (Lord knows I’d like to), this ABC 7 Chicago news story covers how Russians hacked the Illinois State Board of Election in 2016: SQL, an acronym for Structured Query Language, is a database programming language. An “S …

New Pluralsight course: SQL Server 2017: Diagnosing Configuration Issues with DMVs

Publié le 20 juillet 2018 sur sqlskills.com - paul randall
 

Glenn’s latest Pluralsight course has been published: SQL Server 2017: Diagnosing Configuration Issues with DMVs. It’s just under 2 hours long, and from the course description: It is very common for SQL Server instances to be …

SQL Server Migration

Publié le 20 juillet 2018 sur sqlservercentral.com
 

Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.

SQL Code Analysis from a PowerShell Deployment Script

Publié le 20 juillet 2018 sur sqlservercentral.com
 

Database code analysis becomes more important as the team doing the database development gets bigger and more diverse in skills. In this article Phil Factor discusses SQL Code Analysis from a PowerShell Deployment Script How to fix SQL Server disk I/O …

SQL SERVER – Installation Error: The Specified Value ‘Install’ for ACTION is Invalid

Publié le 20 juillet 2018 sur journey to sqlauthority
 

I was helping a client to install SQL Server using script/automation (without using UI). They wanted to do command-line install rather than hitting next, next, fill values in the UI as they have to deploy more than 100 servers with SQL installed on it. …

Announcing “Great Post, Erik” – A Book of Erik’s Best Work

Publié le 19 juillet 2018 sur brentozar.com
 

Erik Darling blogs a lot. Not lightweight stuff, either, but ambitious posts with a lot of demo scripts, screenshots, and detailed explanations about why SQL Server does what it does. So as he approached his 300th blog post, we decided to build a best- …

Segment Data into Deciles

Publié le 19 juillet 2018 sur sqlservercentral.com
 

This short article shows a simple example of how to segment data into deciles

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 …


Pages :