Sites anglophones


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, …

Transfer Data to the Cloud Using Azure Data Factory

Publié le 20 mars 2019 sur sqlservercentral.com
 

In this tip we look at how to configure Azure Data Factory to move data from an on-premises SQL Server database to an Azure SQL Database.

Free eBook: Inside the SQL Server Query Optimizer

Publié le 20 mars 2019 sur sqlservercentral.com
 

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic l …

Stairway to AlwaysOn Level 5: Analyse and Deploy a Failover Cluster Instance

Publié le 20 mars 2019 sur sqlservercentral.com
 

In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).

Complimentary access to Gartner Guide

Publié le 20 mars 2019 sur sqlservercentral.com
 

Redgate has been acknowledged as a representative vendor in the Gartner 2018 Market Guide for Data Masking. For Gartner’s insights, analysis and recommendations on data masking you can get your complimentary copy of the report from Redgate.

How to Track Data Platform Service Level and Performance Before and After Consolidation?

Publié le 20 mars 2019 sur journey to sqlauthority
 

When you are planning data platform consolidation, it is very important to track down the changes in the overall system performance after the actual migration is done. You should understand the differences in the configurations and performance of the i …

Registration Open for My SQLSaturday Boston Pre-Con

Publié le 19 mars 2019 sur brentozar.com
 

I’m coming to Boston this year for SQLSaturday #877. On Friday, I’ll be teaching a one-day pre-con: Performance Tuning in 21 Demos – You’re a developer or DBA who wants to tune indexes and queries to make your application go fas …

Shrinking SQL Server Backup Files and Speeding Up Backups

Publié le 19 mars 2019 sur sqlservercentral.com
 

With backup compression you can speed up our backups, while making your backups smaller.

Guide to Quickly Creating an Azure Data Lake Storage

Publié le 19 mars 2019 sur sqlservercentral.com
 

Read a step by step guide to setting up an Azure Data Lake Storage account.

SQL SERVER – Error: 825 – A Read of the File at Offset Succeeded After Failing 1 Time(s)

Publié le 19 mars 2019 sur journey to sqlauthority
 

One of my clients contacted me to give advice about an error. In this blog, we would discuss error message – A read of the file at offset succeeded after failing 1 time(s) Here is the complete error message they were seeing while all of the sched …

Poll Results: What Conference Schedule Did You Prefer?

Publié le 18 mars 2019 sur brentozar.com
 

Last week, I asked you a couple of questions: When you attend a 1-day conference like a SQLSaturday or SQL Relay, what is your preferred session schedule? You said: 31.8% (211 votes): 6 60-minute sessions 31.3% (208 votes): A mix of 45-minute and 90-mi …

Have your say on the state of SQL Server monitoring

Publié le 18 mars 2019 sur sqlservercentral.com
 

In this blog, we review the key insights from last year’s State of SQL Server Monitoring report. One year on, how has this changed? Read the blog to find out how you can help us define the state of 2019 plus a chance to win a $250 Amazon voucher.

Migrating SQL Server Reporting Services

Publié le 18 mars 2019 sur sqlservercentral.com
 

Learn how to migrate SSRS by following a walk through of migrating SSRS 2014 to SSRS 2016.

SQL SERVER – Stretch Database – ERROR: The Provided Location is Not Available for Resource Group

Publié le 18 mars 2019 sur journey to sqlauthority
 

This was my first experiment with this feature called Stretch Database. I have started the wizard and encountered at the very end. Here is the error message. And here is the text of error message. Operation to create resource group stretchgroup-austral …

Data Quake

Publié le 18 mars 2019 sur sqlblog.com
 

Data Quake. That’s what it is. Dave Wells have just gave this great definition that clearly describes what’s happening in the data management world during the recent years.I am greatly enjoying Dave’s session today at Enterprise Data World s …


Pages :