Sites anglophones

How Inferred Linking in Matched Records Digs Deeper into Your Data

Publié le 18 juillet 2017 sur

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to …

Auto Starting SQL Server Agent

Publié le 17 juillet 2017 sur

I faced this problem some years ago. The company I was working for had a lot of clients with very low-quality communications, so each client needed its own local server and BI solutions. A very small DBA team had the task to deal remotely with hundreds …

SQL Server 2017 Release Candidate 1 Available for Download

Publié le 17 juillet 2017 sur

Today Microsoft announced the first public release candidate of their flagship relational database platform, SQL Server 2017 (RC1), which is readily available to download today. read more

SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server

Publié le 17 juillet 2017 sur

In this article, I will demonstrate how to build a SQLCLR stored procedure that extends the functionality of the procedure sp_send_dbmail that is provided in SQL Server. I will be including the code, which is on Github here. The main purpose of th …

The Best of Both Worlds: Using Excel and Power BI Together

Publié le 17 juillet 2017 sur

There are many IT technologies available for storing data, but Excel remains the most popular data tool for users of IT in businesses. Excel is just so versatile, but the downside is that everything remains in your local machine. You can’t share …

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

Publié le 17 juillet 2017 sur

Catching them in the act There are plenty of ways of finding out those queries that are killing your database’s performance. With SQL Server 2016 and Query Store, it’s become so much easier to monitor performance in SQL Server, but there ar …

SQL Server R Services: Digging into the R Language

Publié le 17 juillet 2017 sur

The series so far: SQL Server R Services: The Basics SQL Server R Services: Digging into the R Language In SQL Server 2016, Microsoft added support for the R language in two different forms: SQL Server R Server, a stand-alone product that provides para …

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

Publié le 17 juillet 2017 sur

This week, Brent, Richie, Erik, and Tara discuss partitioning tables, native backups vs 3rd party agent backups, page life expectancy, query tuning, deadlocks, drawbacks of RCSI, triggers, replication, Always On Availability Groups, and forest fires. H …

SQL Data Aggregation Aggravation

Publié le 17 juillet 2017 sur

Raw data is usually bulky, so we like to aggregate it into smaller chunks to make it easier to digest, but there are a lot of subtle problems with aggregating data. We like to aggregate data in such a way that when we put the small chunks back together …

Getting Started with Azure SQL Data Warehouse – Part 6

Publié le 17 juillet 2017 sur

Azure SQL Data Warehouse is Microsoft’s new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this installment, Arshad Ali covers the different ways to load …

Are your automated tests slowing you down?

Publié le 17 juillet 2017 sur

Slow, unreliable tests prevent teams doing great work, and make continuous delivery impossible. So what can you do to improve your automated tests?

Azure DWH part 11: Data Warehouse Migration Utility

Publié le 17 juillet 2017 sur

There is a new utility to import data from SQL Server on premises or Azure SQL to Azure SQL Data Warehouse (ASDW)

SQL SERVER – Why Edition Upgrade is Not Upgrading Edition of SQL Server?

Publié le 17 juillet 2017 sur journey to sqlauthority

Sometimes many DBAs are so expert in many areas like performance tuning or backup/restore, they miss simple stuff. One of my DBA friends was running Standard Edition of SQL Server 2016 in production and want to upgrade the edition to Enterprise – …

SQLintersection Fall 2017

Publié le 16 juillet 2017 sur - paul randall

As we head towards our 10th SQLintersection in October, I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear over and over is that attendees love SQLinter …

What is the Default Datatype of NULL? – Interview Question of the Week #131

Publié le 16 juillet 2017 sur journey to sqlauthority

Question: What is the Default Datatype of NULL? Answer: This is a very popular question to ask to various DBA and developers. The most common answer I usually receive is – there is no datatype for the NULL value. A very fair point. However, pleas …

Pages :