How to fix the error “String or binary data would be truncated”
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
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
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
In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).
Complimentary access to Gartner Guide
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?
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
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
With backup compression you can speed up our backups, while making your backups smaller.
Guide to Quickly Creating an Azure Data Lake Storage
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)
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?
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
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
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
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. 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 …