Sites anglophones


[Video] Office Hours 2017/1/4 (With Transcriptions)

Publié le 9 janvier 2017 sur brentozar.com
 

On this first Office Hours call of 2017, Brent, Erik, Tara, and Richie discuss multi-server jobs, how to find motivated Junior DBAs, working with SAP databases, partitioning, AlwaysOn Availability Groups, tracking SQL users, SQL monitoring tools, data …

Using SQLite with PowerShell and SQL Server

Publié le 9 janvier 2017 sur sqlservercentral.com
 

When you combine PowerShell and SQLite, you can perform powerful magic. Phil Factor is in awe of SQLite and gives a brief demonstration of how easy it is to use. Just to encourage anyone who is unfamiliar with the database, he includes a giant-sized SQ …

Using R to Identify Key Features Quickly

Publié le 9 janvier 2017 sur sqlservercentral.com
 

Typical BI dashboards display data summaries like counts and averages. We use R to extend on these to identify key associations in a dataset.

SQL SERVER – How to get historical deadlock Information from System Health Extended Events?

Publié le 9 janvier 2017 sur journey to sqlauthority
 

Let me start off by asking a simple question. How many of you have seen this error about historical deadlock information earlier? Msg 1205, Level 13, State 45, Line 4 Transaction (Process ID 52) was deadlocked on lock resources with another process and …

An Example of Data Integration Lifecycle Management with SSIS, Part 1

Publié le 8 janvier 2017 sur sqlblog.com
 

In this post I will provide some details about the demo SSIS project. I will then focus on version control and deployment. What DILM Is and Is Not Data Integration Lifecycle Management (DILM) is not about data integration development. DILM is about eve …

How to Get Random Records from Table? – Interview Question of the Week #105

Publié le 8 janvier 2017 sur journey to sqlauthority
 

Question: How to Get Random Records from Table? Answer: This question seems to be never get old. I have previously answered this question multiple times on my blog, but I still get this question from many readers who prefer sending email over doin …

Thanks, Google

Publié le 7 janvier 2017 sur brentozar.com
 

I usually can count on Google to figure out what I want to search for, even if there’s typos in my search. But sometimes Google just doesn’t get it right. I’m not Brent Ozar. I can’t afford a Rolex! Do you have any searches …

SQL SERVER – Unable to Start SQL Service – Server TCP provider failed to listen on [‘any’ 1433]. Tcp port is already in use.

Publié le 7 janvier 2017 sur journey to sqlauthority
 

While playing with my multiple SQL instances, I realized that I was not able to start one of the SQL instance on my laptop. Here is the error which I received when I tried starting it from Start > Run > Servics.msc . This error is related to …

Announcing SSIS Catalog Compare and CatCompare Version 2

Publié le 6 janvier 2017 sur sqlblog.com
 

I am pleased to announce the release of SSIS Catalog Compare and CatCompare version 2. You can purchase a bundle that includes both products (and saves you some money) or can purchase each product separately: SSIS Catalog Compare and CatCompare . If yo …

Apache Zeppelin 0.6.2 for SQL Server Docker Image updated

Publié le 6 janvier 2017 sur sqlblog.com
 

In order to be able to keep created notebooks and interpreters configurations when upgrading the docker image to a newer version, I changed the dockerfile to use docker volumes, as described here (if you’re interested into learning more): Manage …

Build Me A Build: Assembly Olympics

Publié le 6 janvier 2017 sur brentozar.com
 

Overall, this was pretty easy I’m thankful that generations of enthusiasts have agreed (mostly) on standards, and written oodles of documentation and guides to make stuff like this easy. Seriously. To put things in some perspective, when I first …

SQL Server Ad Hoc Access to OLE DB Provider Has Been Denied Error

Publié le 6 janvier 2017 sur sqlservercentral.com
 

I was trying to use OPENROWSET to query a remote database and I experienced the following error « Ad hoc access to OLE DB provider has been denied. You must access this provider through a linked server ». When I ran this same query using a sysadmin accou …

How to run SSIS Project as a SQL Job

Publié le 6 janvier 2017 sur sqlservercentral.com
 

In this piece by Pilip Horan, learn how to create an SSIS catalog and run a project as a SQL Agent Job.

An Introduction to SQL Server Containers

Publié le 6 janvier 2017 sur sqlservercentral.com
 

Get the basics of what a container is and how this can work with SQL Server.

SQL SERVER – Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’

Publié le 6 janvier 2017 sur journey to sqlauthority
 

One of my friends was trying to configure database mirroring and was having a hard time in getting things working. The challenge was that he was using certificate for mirroring authentication because machines were workgroup not in domain. He followed o …


Pages :