Sites anglophones


Saving a Few Lines of Code by Performing Multiple Operations in a Single Command

Publié le 20 janvier 2017 sur sqlblog.com
 

I was in Mike Byrd’s session on in-memory technologies the other day and I saw him do something I had never seen and it prompted me to write this blog today. It has nothing to do with in-memory, as the title notes, but has to do with stacking commands …

The 2017 Data Professional Salary Survey Results

Publié le 19 janvier 2017 sur brentozar.com
 

We asked to see your papers, and 2,898 people from 66 countries answered. Download the raw data in Excel, and you can slice and dice by country, years of experience, whether you manage staff or not, education, and more. Community bloggers have already …

What’s New in Reporting Services 2016 Service Pack 1

Publié le 19 janvier 2017 sur sqlservercentral.com
 

SQL Server 2016 was been released the first of June 2016, but at the recent Connect event Microsoft announced the first service pack. Aside from numerous fixes, this service pack also comes packed with some notable enhancements for Reporting Services. …

Free Webinar: An Introduction to DevOps

Publié le 19 janvier 2017 sur sqlservercentral.com
 

Despite its growing popularity, there is still some confusion over what DevOps actually means, how organizations should do it and what the best way is to get started. Redgate have invited James Betteley, Head of Education at the DevOpsGuys, to run thro …

Keeping Fact Tables Online while Loading via Partition Switching

Publié le 19 janvier 2017 sur sqlservercentral.com
 

Provides overview of steps that can be used to keep fact tables online during loading process.

SQL SERVER – Understanding JSON Use is Case-Sensitive

Publié le 19 janvier 2017 sur journey to sqlauthority
 

The things I get to learn from my daughter is amazing. I think all of us need to constantly explore without any prejudice and set biases. Whenever I get a new toy for some occasion, I see there is at least a half hour of exploration to understand how t …

Code to show rolled back transactions after a crash

Publié le 19 janvier 2017 sur sqlskills.com - paul randall
 

In Monday’s Insider newsletter I discussed an email question I’d been sent about how to identify the transactions that had rolled back because of a crash, and I said I’d blog some code to do it. First of all you need to know …

Cumulative Updates for SQL Server 2012 / 2016

Publié le 19 janvier 2017 sur sqlblog.com
 

  Hello Things are happening! SQL Server 2012 SP2 has CU16 released. You can reach the KB article here and download the update There have been 5 issues resolved. The build number is 11.0.5678.0   SQL Server 2012 SP3 has CU7 released. You can …

SQL Server 2012 Cumulative Updates Available

Publié le 18 janvier 2017 sur sqlskills.com - glen berry
 

Microsoft has released SQL Server 2012 SP3 CU7 (Build 11.0.6579.0). According to the associated cumulative KB article, KB3205051, 12 issues have been resolved with this update. Microsoft has also released SQL Server 2016 SP2 CU16 (Build 11.0.5678.0). A …

SQL Server 2016 Cumulative Updates Available

Publié le 18 janvier 2017 sur sqlskills.com - glen berry
 

Microsoft has released SQL Server 2016 SP1 CU1 (Build 13.0.4411.0). According to the associated cumulative KB article, KB3208177, 63 issues have been resolved with this update. A number of them look to be pretty significant. Microsoft has also released …

Latest SQL Server Updates

Publié le 18 janvier 2017 sur sqlblog.com
 

  There are some new updates for SQL Server 2012 and SQL Server 2016 that were released today. I am not sure what happened to SQL 2014 but I suspect those will be out shortly as well. Here are the links and the associated KB’s. SQL Server 20 …

Indexes For Kids

Publié le 18 janvier 2017 sur brentozar.com
 

Kid Tested When you work with something a lot, you tend to extrapolate concepts from it out to everything you see. That one person collecting tickets is a serial zone. That food truck line is a HEAP. The empty subway car that smells like a toilet is Re …

Put your Database under Source Control

Publié le 18 janvier 2017 sur sqlservercentral.com
 

This article will walk you through a demostration on linking your DB to SubVersion with RedGate SQL Source Control.

SQL Server v.Next : STRING_AGG() performance

Publié le 18 janvier 2017 sur sqlservercentral.com
 

Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.

Five Useful SQL Server Management Practices

Publié le 18 janvier 2017 sur sqlservercentral.com
 

This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.


Pages :