Sites anglophones


24 Hours of PASS (April 2019): 20 Years of PASS!

Publié le 24 mars 2019 sur sqlblog.com
 

The next 24 Hours of PASS will have the opportunity to celebrate the first 20 years of the international association of professionals and data management experts. PASS is the acronym of Professional Association of SQL Server, PASS was established on 19 …

How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217

Publié le 24 mars 2019 sur journey to sqlauthority
 

Question: How Does QUOTED_IDENTIFIER Works in SQL Server? Answer: If you search on the internet, you may find quite lots of notes about it. So in this blog post, I will explain in very simple words. First, let us see the following example where I have …

SQL SERVER – Read Only Routing Error: Client Unable to Establish Connection Because an Error was Encountered During Handshakes Before Login

Publié le 23 mars 2019 sur journey to sqlauthority
 

I have helped many clients in deploying Always On Availability Group. Based on their requirement they keep using additional features provided by availability groups. This time they wanted to use always-on availability group read-only routing feature. T …

SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions

Publié le 22 mars 2019 sur sqlservercentral.com
 

I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.

SQL in the City Summits – UK, US & Down Under

Publié le 22 mars 2019 sur sqlservercentral.com
 

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in April, May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database De …

SQL SERVER – When You Should Not Attend SQL Server Performance Tuning Practical Workshop for EVERYONE?

Publié le 22 mars 2019 sur journey to sqlauthority
 

So far many of you know that my SQL Server Performance Tuning Practical Workshop for EVERYONE is extremely popular and it is almost full when I am writing this email. I can now accommodate a maximum of 5 individuals in the class as we are reaching capa …

Updated First Responder Kit and Consultant Toolkit for March 2019

Publié le 21 mars 2019 sur brentozar.com
 

This month, just half a dozen bug fixes, plus a new parameter for sp_BlitzCache to search the plan cache for specific strings. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit …

Backup your Reporting Services Encryption Key

Publié le 21 mars 2019 sur sqlskills - jonathan kehayas
 

If you run SQL Server Reporting Services, part of your DR plan needs to include a backup of the encryption key for SSRS. This sadly is an all to often overlooked part of the solution, even though it is incredibly easy to do. If you don’t have a b …

Help us define the state of SQL Server monitoring in 2019

Publié le 21 mars 2019 sur sqlservercentral.com
 

Last year we ran the industry’s first ever state of SQL Server monitoring survey, the results not only gave great insight for the community but helped us shape our product development to ensure we were meeting the needs that you were asking for. …

Dynamically Generate Replication Tasks with Biml and Custom Connectors

Publié le 21 mars 2019 sur sqlservercentral.com
 

This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS.

Microsoft Unveils Azure Backup for SQL Server

Publié le 21 mars 2019 sur sqlmag.com
 

Azure Backup for SQL Server allows organizations to centralize backup and restore across a fleet of SQL Server instances.

SQL SERVER – Stretch Database – Free Trial Subscriptions Can Provision Basic, Standard S0 through S3 Databases, up to 100 eDTU Basic or Standard Elastic Pools and DW100 Through DW400 Data Warehouses

Publié le 21 mars 2019 sur journey to sqlauthority
 

I wrote a blog earlier about my first experience (and error encountered) with “Stretch Database” feature. In this blog I would talk about the error – Free Trial subscriptions can provision Basic, Standard S0 through S3 databases, up t …

The Curious Case of… unstoppable DBCC CHECKDB

Publié le 20 mars 2019 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

Glenn’s Tech Insights For March 20, 2019

Publié le 20 mars 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …

How to fix the error “String or binary data would be truncated”

Publié le 20 mars 2019 sur brentozar.com
 

First, let’s see the error happen: let’s create a table with small fields, and then try to insert more data than it holds.CREATE TABLE dbo.CoolPeople(PersonName VARCHAR(20), PrimaryCar VARCHAR(20)); GO INSERT INTO dbo.CoolPeople(PersonName, …


Pages :