Sites anglophones


New CREATE OR ALTER statement in SQL Server 2016 SP1

Publié le 20 février 2017 sur sqlservercentral.com
 

Ahmad Yaseen explains what SQL Server 2016 SP1’s new CREATE OR ALTER statement does, and how to use it. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find an …

Back to Basics: Capturing Baselines on Production SQL Servers

Publié le 20 février 2017 sur sqlservercentral.com
 

If you have not been capturing baselines on your production servers, then today is the day you can start. This article provides scripts, valid for SQL Server 2005 and higher, which anyone can use to capture basic information about a SQL Server instance …

SQL SERVER – Fix: Error 946, Severity: 14 – Cannot open database ‘DB’ version 782. Upgrade the database to the latest version

Publié le 20 février 2017 sur journey to sqlauthority
 

I was consulting a client for migration from SQL 2014 to SQL 2016. They were using methodology discussed in books online here. https://msdn.microsoft.com/en-us/library/dn178483.aspx  (Upgrading AlwaysOn Availability Group Replica Instances). Let u …

How to Keep Certain Records on Top While Ordering Data? – Interview Question of the Week #110

Publié le 19 février 2017 sur journey to sqlauthority
 

Question: How to Keep Certain Records on Top While Ordering Data? Let me elaborate this question as it is originally received. “Hi Pinal, I just returned from an interview and I faced a very strange question. I was asked following question a …

Long Poles and Critics

Publié le 18 février 2017 sur sqlblog.com
 

As a consultant, I get calls to complete projects started by someone else or extend projects completed by someone else. When I look at someone else’s work it’s sometimes tempting to say, « Wow – they did that wrong. » But I don’t. Instead I say, « I’m not …

SQL SERVER – Cannot open backup device. Operating system error 1326 (Logon failure: unknown user name or bad password.)

Publié le 18 février 2017 sur journey to sqlauthority
 

There might be various reasons for above error, but this case is very specific to a situation where SQL Server was installed on a machine which was in Workgroup whereas the backup destination was the server located in the domain.  Here is the erro …

Stopping Execution of Future Batches

Publié le 17 février 2017 sur sqlblog.com
 

  There is a command that as far as I can tell has been in the product since SQL2008 but I was woefully unaware of. Actually I find many others are unaware as well and hence the blog post. The command is SET NOEXEC which has options for ON or OFF. …

Guess the SQL Server vNext Release Date Contest

Publié le 17 février 2017 sur brentozar.com
 

They used to release doves, but that’s so John Woo We’ve been doing this a while now, and time to kick it off again. Leave one – and only one – comment here with your guess of the date. If you leave multiple comments, only the f …

Introduction to SAP HANA on Azure

Publié le 17 février 2017 sur sqlservercentral.com
 

Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, this trend has been exemplified by advancements in support for SAP-based solutions on Microsoft …

Using EXCEPT to Determine Row Differences

Publié le 17 février 2017 sur sqlservercentral.com
 

How to use the EXCEPT statement to perform row differences.

SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage

Publié le 17 février 2017 sur journey to sqlauthority
 

Few days back I wrote blog to help my blog reader and this is follow up on the same post How to Add Date to Database Backup Filename? – Interview Question of the Week #109. In this blog post we will see a powershell script for Removing Old S …

New Flagship Xeon E5 and E7 Processors

Publié le 16 février 2017 sur sqlskills.com - glen berry
 

Intel has recently released two, new “flagship” Xeon processors, one for the E7 v4 product family, and one for the E5 v4 product family. The new Intel Xeon E7-8894 v4 processor has 24 physical cores, and runs at a slightly higher base clock …

Call for Speakers for 2017 IT/Dev Connections Extended Until February 20, 2017

Publié le 16 février 2017 sur sqlmag.com
 

The 2017 IT/Dev Connections conference is coming to San Francisco, CA after many years in Las Vegas, NV. This year’s conference takes place October 23-26, 2017 at the Hilton Union Square in the heart of the San Francisco Financial District. As in …

Introducing a DevOps Workgroup to Farm Credit Services of America

Publié le 16 février 2017 sur simple-talk.com
 

My last article detailed the first, tentative steps we’d taken at Farm Credit Services of America (FCSA), in order to introduce DevOps workflows into our organization. I described the need to define a common DevOps goal, which in our case was as …

Explaining Activity Monitor

Publié le 16 février 2017 sur sqlblog.com
 

This post is not about how to use the Activity Monitor (AM) tool in SQL Server Management Studio (SSMS) – there are loads of such posts written already. Also, it is not about dissing AM, you will find such posts as well. What I want to do is to e …


Pages :