Sites anglophones


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 …

When THREADPOOL Waits Lead To RESOURCE_SEMAPHORE Waits

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

Your server is underpowered That’s an understatement. Your server sucks. It has four cores in a single socket, data outpaces RAM by a country mile, the disks have whiskers, and the network card still has a phone jack in it. Alright, so maybe it …

vCenter Server fails to start, Purge and Shrink Vcenter SQL Database

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

In this article, you will learn how to troubleshoot If your vCenter Server fails to start and and manually purge the Vcenter database if required.

SQL SERVER – FIX: Msg 15281- SQL Server Blocked Access to Procedure ‘sys.xp_cmdshell’ of Component ‘xp_cmdshell’

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

One of my blog readers pinged me on Skype and asked a simple question. I always thought I had a blog written about this error, but I was wrong. So, this blog is the outcome of a short interaction with my blog reader. Let us learn about how to fix block …

Who is overriding MAXDOP 1 on the instance?

Publié le 16 février 2017 sur sqlskills.com - paul randall
 

In Monday’s newsletter I discussed an email question I’d been sent and promised to blog about it. The question was “how can latch waits for ACCESS_METHODS_DATASET_PARENT occur when the instance MAXDOP is set to 1?” This shouldn …

What is Batch Requests/sec?

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

When I first look at a server, I want to know how busy it is, where its bottlenecks are, what is SQL Server waiting on and many other things. Batch Requests/sec is one of the data points that is used to measure how busy a server is. WHAT IS B …

Compression and its Effects on Performance

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

Erin Stellato takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk edit …

Extending DevOps practices to SQL Server databases

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

In this free webinar, Steve Jones and Arneh Eskandari show how Redgate’s Database DevOps solution works with Visual Studio Team Services to improve your database delivery process. Register now.


Pages :