Sites anglophones


Looking for sp_whoisactive?

Publié le 26 juillet 2017 sur sqlblog.com
 

A while ago I quietly announced the new home for sp_whoisactive, whoisactive.com . Today I finished migrating all related content — including the documentation consisting of a series of 28 articles posted on this blog a while back. So if you’re lookin …

SQL-On-Hadoop: Hive – Part I

Publié le 26 juillet 2017 sur sqlservercentral.com
 

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.

SQL SERVER – Msg 1833 – File Cannot be Reused Until After the Next BACKUP LOG Operation

Publié le 26 juillet 2017 sur journey to sqlauthority
 

While preparing for a demo for an upcoming session, I came across an error which I didn’t see earlier. Here is the error in the UI and it is related to Backup Log Operation. I am also trying to add a file to the database using below command. USE …

Let’s Corrupt a Database Together, Part 3: Detecting Corruption

Publié le 25 juillet 2017 sur brentozar.com
 

So far in this series, I’ve shown you how to corrupt a clustered index, then how nonclustered indexes can be corrupted independently. If you haven’t read those, you should start there first. Let’s start again with our 50Ways database, …

Containers for enhanced Data Governance and Compliance

Publié le 25 juillet 2017 sur sqlservercentral.com
 

Complex data environments sometimes need new techniques to properly manage the information. See how Windocks can help with containers and SQL Server.

Azure DWH part 12: Permissions, roles, logins and users

Publié le 25 juillet 2017 sur sqlservercentral.com
 

In this article we will show some common roles and queries related to Azure SQL Data Warehouse.

SQL SERVER – FIX: Msg 35250 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed

Publié le 25 juillet 2017 sur journey to sqlauthority
 

Earlier I wrote a blog on same error message which you can read from below link. SQL SERVER – FIX: Msg 35250, Level 16, State 7 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed One of my blog reade …

Danger Averted: A DBA Horror Story

Publié le 24 juillet 2017 sur sqlmag.com
 

Most technical articles written explore new features of existing products or identifying a problem and providing a solution. read more

Scenic City Summit is this Friday

Publié le 24 juillet 2017 sur sqlblog.com
 

Scenic City Summit is a one day conference in Chattanooga, the Scenic City Summit is a new experience for me, although in a familiar, Devlink-esqe setting of the Chattanooga Convention Center in Chattanooga, TN. I am looking forward to attending, and s …

[Video] Office Hours 2017/07/19 (With Transcriptions)

Publié le 24 juillet 2017 sur brentozar.com
 

This week, Erik and Richie discuss performance tuning, relativity, Always On Availability Groups, parameter sniffing, technical debt, unit testing, deadlocks, testing storage performance, and more… Here’s the video on YouTube: You can regi …

Speaking @ PASS Summit 2017

Publié le 24 juillet 2017 sur sqlblog.com
 

After years and years talking about Business Intelligence and Business Analytics, this year at PASS I’ll be speaking about Application Development and how to make the best use of the data platform that Microsoft created so far. I’ve started …

Testing DML Statements for In-Memory OLTP

Publié le 24 juillet 2017 sur sqlservercentral.com
 

Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.

The Case of the Space at the End

Publié le 24 juillet 2017 sur sqlservercentral.com
 

A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting? 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 and fix the root …

Free Webcast – 3 Common Mistakes to Kill SQL Server Performance – My Best Online Presentation

Publié le 24 juillet 2017 sur journey to sqlauthority
 

Lots of people ask me what is the one thing which I am very much proud of in my life. The answer is very simple, I am very much proud of the webcast, which I have done for Group By Conference 3 Common Mistakes to Kill SQL Server Performance. You can wa …

How to Count Week Days Between Two Dates? – Interview Question of the Week #132

Publié le 23 juillet 2017 sur journey to sqlauthority
 

Question: How to Count Week Days Between Two Dates? Answer: Some questions are so simple and interesting that it is fun to build a SQL Script for them. When I searched for an answer to this question, I found quite a few answers online. Actually, a …


Pages :