Sites anglophones


Database Sharding – How to Identify a Shard Key?

Publié le 17 août 2016 sur journey to sqlauthority
 

I have written a number of posts in the past working on shared databases and the concepts around these can be read at Sharding or No Sharding of Database – Working on my Weekend Project for the starters point of view. In a recent discussion at a …

Biml Academy 2 Webinar Recordings are Available!

Publié le 16 août 2016 sur sqlblog.com
 

You can find the recordings for Biml Academy 2 at the links below: Cathrine Wilhelmsen [ Blog | @cathrinew ]: Biml Academy 2 – Lesson 5 – Importing Data with Biml   Andy Leonard [ @AndyLeonard ]: Biml Academy 2 – Lesson 6 – Staging Dat …

Upcoming Performance Seminars: Charlotte and Vegas!

Publié le 16 août 2016 sur sqlblog.com
 

I am happy to report two more scheduled public deliveries of my new-for-2016 seminar, Tuning Your Biggest Queries ! This seminar is all about how to approach difficult query tuning tasks by understanding exactly what the query optimizer is (and is not) …

SQL Server 2014 SP1 CU8 Available

Publié le 16 août 2016 sur sqlskills.com - glen berry
 

Microsoft has released SQL Server 2014 Service Pack 1 Cumulative Update 8, which is Build 12.0.4468. This CU has 38 hotfixes in the public fix list. Since the SQL Server 2014 RTM branch is no longer a “supported service pack”, there is no c …

Query Tuning Week: How to Start Troubleshooting Parameter Sniffing Issues

Publié le 16 août 2016 sur brentozar.com
 

I’m teaching our SQL Server Performance Tuning class out in Portland this week, so we’re running all performance posts this week. You can learn more about my upcoming classes here. When a query is sometimes fast and sometimes slow, for the …

The Recording for Loading Medical Data to the Cloud is Available!

Publié le 16 août 2016 sur sqlblog.com
 

The recording for the Enterprise Data & Analytics webinar “ Loading Medical Data to the Cloud ” is now available (registration required). Enjoy! :{> Related Training: IESSIS2: Immersion Event on Advanced SQL Server Integration Servic …

Crossing the Site Domain with JavaScript

Publié le 16 août 2016 sur sqlservercentral.com
 

Browsers try to prevent a range of malicious attacks by preventing content being accessed by a web page from a different domain to the one that the page was fetched from. If you have a legitimate need to do this, it is a bad idea to disable this method …

SQL Server 2016: built-in JSON Use case scenarios

Publié le 16 août 2016 sur sqlservercentral.com
 

There’s built-in JSON support starting with SQL Server 2016. Does that mean we should all ditch XML and start using JSON? It depends mostly on the target of your data output processing. How to fix SQL Server disk I/O bottlenecks (without a hammer)In th …

SQL Select: Top Ten Great (and Free) SQL Server eBooks

Publié le 16 août 2016 sur sqlmag.com
 

Check out these great (and totally free) SQL Server eBooks read more

PowerShell – SQL Server Paging of Memory Identification

Publié le 16 août 2016 sur journey to sqlauthority
 

In one of my recent consultation visits to a customer, there was deep performance related problems. They were unclear to what was happening and what was the actual problem. But these are some of the challenges that I love to take head-on too. In this q …

The Recording for Biml Academy 2–Lesson 5 is Now Available!

Publié le 15 août 2016 sur sqlblog.com
 

The recording for Biml Academy 2 – Lesson 5 – Importing Data with Biml by Cathrine Wilhelmsen [ Blog | @cathrinew ] is now available! Cathrine did an outstanding job walking through several methods for importing database schemas using Biml. It’s …

Query Tuning Week: How to Start Troubleshooting a Slow Stored Procedure

Publié le 15 août 2016 sur brentozar.com
 

I’m teaching our SQL Server Performance Tuning class out in Portland this week, so we’re running all performance posts this week. You can learn more about my upcoming classes here. When you need to find out why a stored procedure is running …

Bash for ETL pre-processing

Publié le 15 août 2016 sur sqlservercentral.com
 

People were doing ETL long before ETL packages were invented. Some of those facilities still have worth today

Paying Attention to Estimates

Publié le 15 août 2016 sur sqlservercentral.com
 

Aaron Bertrand follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.

SQL SERVER – A Timeout (30000 milliseconds) was Reached While Waiting for a Transaction Response from the MSSQLSERVER

Publié le 15 août 2016 sur journey to sqlauthority
 

Recently I was contacted by a client who reported very strange error in the SQL Server machine. These consulting engagements sometimes get the best out of you when it comes to troubleshooting. They reported that they see timeout error. My question was …


Pages :