Sites anglophones


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 …

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.

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 – AlwaysOn AG (Availability Group) and TDE Error – Please Create a Master Key

Publié le 18 janvier 2017 sur journey to sqlauthority
 

Along with performance consulting, sometimes I also get requests from a few clients to look at the AlwaysOn availability group related problems. ENVIORNMENT: Three node AlwaysOn availability group with multi-subnet cluster with two nodes (SQL-A and SQL …

Hardware Selection for a Home Lab – Part 1

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

I have long believed that if you want to be more successful as a developer, database professional, or in any technically-oriented I.T. career, it is a very good idea to have some sort of home lab environment to use for experimentation and learning. Dep …

Tips Concerning Temporal Tables

Publié le 17 janvier 2017 sur sqlmag.com
 

Here are a few tips on working with temporal tables, which were introduced in SQL Server 2016 to enable tracking history of changes to data. read more

SQL Server 2016 « Hidden Gems » – Now on a YouTube Near You

Publié le 17 janvier 2017 sur sqlblog.com
 

Sad that you missed last week’s SQL Server 2016 « Hidden Gems » GroupBy session ? Unlikely, perhaps…but no worries either way! It’s now available for free, on YouTube: https://www.youtube.com/watch?v=P4608MNM-QU Enjoy!…(read more)

More Query Tuning Training: Chicago!

Publié le 17 janvier 2017 sur sqlblog.com
 

I’m very happy to announce a third 2017 date for « Tuning Your Biggest Queries! » On March 10 I’ll deliver the seminar in one of my favorite cities, Chicago. This delivery is a pre-con for SQL Saturday Chicago , which will run on March 11. But here’s the …

Your Favorite Bugs & Enhancement Requests: #TSQL2sday 86 Roundup

Publié le 17 janvier 2017 sur brentozar.com
 

I dunno about you, but I got a big stocking full of coal. Next year, I’m gonna be better, and I plan on asking Santa for a whole bunch of Connect requests. For T-SQL Tuesday, I asked you to name your favorite SQL Server bugs & enhancement req …

SQL Server in Azure Virtual Machines – Performance Optimizations

Publié le 17 janvier 2017 sur sqlservercentral.com
 

When deploying SQL Server in an Azure virtual machine, you can take advantage of several Azure Infrastructure-as-a-Service (IaaS) features that enhance performance of the SQL Server database engine. This article explores a couple of these enhancements, …


Pages :