Sites anglophones


Advanced Analytics with R and SQL Part II – Data Science Scenarios

Publié le 27 juillet 2017 sur sqlservercentral.com
 

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.

SQL SERVER – FIX: RequireKerberos Error During SQL 2008 Installation on Windows 2008 R2 Cluster

Publié le 27 juillet 2017 sur journey to sqlauthority
 

Today the progress made in technology is astounding and beyond our imaginations, but still there are clients who can’t move to higher, latest and greatest version of SQL so easily. They are still stuck with SQL 2005 and SQL 2008 SQL servers. In t …

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 …


Pages :