Sites anglophones

Announcing Erik’s First Video Class: T-SQL Level Up, Level 2

Publié le 25 avril 2017 sur

You’re confident writing queries to get the data you want, and you’ve been doing it for a couple of years. You’ve taken our free T-SQL Level Up class, mastered tally tables and windowing functions, but what else is there? In this clas …

SSRS Audit: All reports executed/not-executed during previous 30 days

Publié le 25 avril 2017 sur

This article presents a pair of queries and reports that reads the ReportServer.dbo.ExecutionLog table to list all SSRS reports that were executed or not-executed in the past 30 days, how many times they were executed, and who executed them. How to fix …

Selecting and Configuring Hardware for SQL Server 2016 Standard Edition

Publié le 25 avril 2017 sur

Glenn Berry explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.

SQL SERVER – FIX : Msg 3178, Level 16 – File SQLAuthority is Not in the Correct State to have This Differential Backup Applied to it

Publié le 25 avril 2017 sur journey to sqlauthority

Few days back I wrote a blog about error messages during differential backup restore. SQL SERVER – Msg 3136, Level 16 – This Differential Backup Cannot be Restored Because the Database has not Been Restored to the Correct Earlier State …

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

Publié le 24 avril 2017 sur

This week, Brent, Tara, Richie, and Erik discuss SQL Server 2017 CTP 2, quorum configuration for a 4-node availability group, database sharding, premature optimization, parameter sniffing, tracking query plans within cursors, and what’s coming up …

Building Dynamic React Apps with SQL Server Data

Publié le 24 avril 2017 sur

This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.

6 shades of masking your data

Publié le 24 avril 2017 sur

The Redgate Foundry team have been researching data masking, and have found that generally speaking there’s six common approaches. In this blog post, Toby Smyth runs through all six.

Should I Type * or 1 With the EXISTS Logical Operator

Publié le 24 avril 2017 sur

In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM…)). They are « * », « 1 » and even « TOP 1 1 » or « TOP 1 * ». The aim of this article to give a good explanation which option is the best.

24 Hours of PASS (May 2017) – Data Security and Data Quality Edition

Publié le 24 avril 2017 sur

Why can we say that SQL Server is the least vulnerable database system for the last seven years? Find it out from May 03 to 04, 2017 at the 24 Hours of PASS « Data Security and Data Quality » edition.  This series of one hour sessions will …

SQL SERVER – FIX : Msg 8115, Level 16, Arithmetic Overflow Error Converting IDENTITY to Data Type INT

Publié le 24 avril 2017 sur journey to sqlauthority

One of my friends who is a SharePoint expert told that he is getting overflow error while doing check-in on the document. He was confident that the error is related to SQL and that’s why he contacted me. I used profiler and found the table which …

Why SELECT HOST_NAME() Returns Empty String? – Interview Question of the Week #119

Publié le 23 avril 2017 sur journey to sqlauthority

Question: Why SELECT HOST_NAME() Returns Empty String while connected from certain .net application? Answer: This is a very popular question I have observed in the recent time. Before I answer this question, I have to be honest here. When I was as …

SQL Server vNext: query_store_wait_stats

Publié le 22 avril 2017 sur

The missing link Back when the Query Store first got announced, I was amazed. The amount of information it gathered and persisted between reboots was such a big improvement over the plan cache, plus being able to force plans was really cool. I was alwa …

SQL SERVER – FIX: Msg 3132, Level 16 – The Media Set has 2 Media Families but Only 1 are Provided. All Members Must be Provided

Publié le 22 avril 2017 sur journey to sqlauthority

This blog is a response to a comment on our blog. Have you ever encountered below error related to media set? Msg 3132, Level 16, State 1, Line 15 The media set has 2 media families but only 1 are provided. All members must be provided. Msg 3013, Level …

Generating HTML from SQL Server Queries

Publié le 21 avril 2017 sur

Can you produce HTML from SQL? Yes, very easily. Would you ever want to? I certainly have had to. The principle is very simple. HTML is really just a slightly odd dialect of XML that imparts meaning to predefined tags. SQL Server has built-in ways of o …

SQL Server 2017: Unpublished Gems

Publié le 21 avril 2017 sur

Sneaky, sneaky, sneaky Release notes never seem to tell the full story, do they? At some point, you have to take matters into your own hands and go hunting for, as Paul Harvey would say, “The Rest Of The Story”. So what did I find? New stuf …

Pages :