Sites anglophones


Equifax Breach Displays Every Bad Security Practice

Publié le 8 septembre 2017 sur sqlmag.com
 

Between plaintext passwords and delayed disclosure, Equifax has ignored even the most basic security measures.

Creatures of habit, snowflakes, and integration tax

Publié le 8 septembre 2017 sur sqlservercentral.com
 

Why are practices like version control, continuous integration and automated deployment being introduced to application development but left on the shelf when it comes to the database? In search of some answers, Redgate spoke to Donovan Brown, Principa …

Setup and Implement SQL Server 2016 Always On Distributed Availability Groups

Publié le 8 septembre 2017 sur sqlservercentral.com
 

SQL Server 2016 introduced a new feature called Distributed Availability Group. A Distributed Availability Group is a special type of Availability Group that spans two separate Availability Groups. Edwin Sarmiento explains.

SQL SERVER – How to Find UNIQUE Key Columns? – sp_special_columns customers

Publié le 8 septembre 2017 sur journey to sqlauthority
 

Unique key on a column is used to identify a particular row easily. It is created either by explicitly mentioning it either part of the definition or when defined as Primary key (By default it is unique and not null). Let us learn about special stored …

Creating Basic Indexes on the Stack Overflow Public Database

Publié le 7 septembre 2017 sur brentozar.com
 

My public SQL Server database copy of the Stack Overflow data dump only includes clustered indexes by default. I want to keep your database size as small as possible for quick downloading. But like any database – when you create it, should you ad …

Why don’t you unit test SQL Server code?

Publié le 7 septembre 2017 sur sqlservercentral.com
 

This post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. Even if you have a large code base and no existing unit tests, you can start introducing tests now to make your da …

The Shortcomings of Predictive Accuracy

Publié le 7 septembre 2017 sur sqlservercentral.com
 

In prediction, accuracy is key. But it’s not all it’s cracked up to be as we will explore.

SQL SERVER – System Procedure to List Out Table From Linked Server

Publié le 7 septembre 2017 sur journey to sqlauthority
 

There is a system procedure named sp_tables which is used to list out the tables available in the CURRENT database of the CURRENT server. But did you know that th …

Six Scary SQL Surprises

Publié le 6 septembre 2017 sur simple-talk.com
 

In the Happy Database movies, SQL Server is benign and friendly, with no scary surprises lurking around the next corner. In these movies: People work together No-one but the DBA can make changes to production People tell us in advance when they want to …

SQL Server R Services: Working with Data Frames

Publié le 6 septembre 2017 sur simple-talk.com
 

The series so far: SQL Server R Services: The Basics SQL Server R Services: Digging into the R Language SQL Server R Services: Working with ggplot2 Statistical Graphics SQL Server R Services: Working with Data Frames In the first article in this series …

SQL Server on Linux is the New SQL Server on Windows Core

Publié le 6 septembre 2017 sur brentozar.com
 

When Windows Server 2012 came out with Core, I heard some rather suspicious things at conferences like: “I’ll be able to take way less patching outages!” “It’ll be so much faster because it has less overhead!” …

SQL server 2016 Sp1 CU4 regression error while applying permission on entity level, quick workaround

Publié le 6 septembre 2017 sur sqlblog.com
 

Sql Server 2016 Sp1 CU4 was recently released here https://support.microsoft.com/en-us/help/4024305/cumulative-update-4-for-sql-server-2016-sp1 . we made a significant improvement in terms of performance when working on Models tree view control which i …

SQL SERVER – How to Get Updated Link for Code and Database Samples?sample

Publié le 6 septembre 2017 sur journey to sqlauthority
 

Some emails, indeed triggers blog posts such as the one I received the other day about database samples. “Hey Pinal, I read your earlier blog posts related to how to install sample database wideworldimports. It was good, however we would love to …

[Video] Office Hours 2017/08/30 (With Transcriptions)

Publié le 5 septembre 2017 sur brentozar.com
 

This week, Brent, Erik, and Richie discuss Availability Groups, versions of sp_BlitzIndex™, SQL Server installation issue, backing up SSRS reports, SQL Server on Linux, failovers, detaching/attaching databases, extended events, career progression …

How Much Can One Column Change A Query Plan? Part 1

Publié le 5 septembre 2017 sur brentozar.com
 

Beyond Key Lookups I’m going to show you two queries, and two query plans. The two queries are only different by one selected column, but the two query plans are wildly different. Unless I’ve talked to you in the last few days, these may su …


Pages :