SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,913,698 DBAs, developers and SQL Server users

Rss
Headlines today   March 21, 2019

Dynamically Generate Replication Tasks with Biml and Custom Connectors

This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS.  Read more...
By Jerod Johnson 2019/03/21 | Source: SQLServerCentral.com | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 60 reads

Resumable Online Index Create and Rebuild Operations

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.  Read more...
By Additional Articles 2019/03/21 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 628 reads

Help us define the state of SQL Server monitoring in 2019

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. So what has changed in a year? Tell us for your chance to win a $250 Amazon voucher.   Read more...
By Additional Articles 2019/03/21 | Source: Redgate | Category: monitor
Rating: (not yet rated)  Rate this |   Briefcase | 676 reads
Previous headlines

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).  Read more...
By Perry Whittle 2019/03/20 (first published: 2015/02/11) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 4,384 reads

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 look at Parameterization and Hints along the way.  Read more...
By Press Release 2019/03/20 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 54,115 reads

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.  Read more...
By Additional Articles 2019/03/20 | Source: MSSQLTips.com | Category: cloud computing
Rating: (not yet rated)  Rate this |   Briefcase | 1,321 reads

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.  Read more...
By 2019/03/20 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 355 reads

Guide to Quickly Creating an Azure Data Lake Storage

Read a step by step guide to setting up an Azure Data Lake Storage account.  Read more...
By Ashish Mahajan 2019/03/19 | Source: SQLServerCentral.com | Category: azure data lake
Rating: |  Discuss |   Briefcase | 291 reads

Shrinking SQL Server Backup Files and Speeding Up Backups

With backup compression you can speed up our backups, while making your backups smaller.  Read more...
By Additional Articles 2019/03/19 | Source: Database Journal | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,274 reads

Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning

Organizations may have many concerns about performance when migrating databases to Azure. Fortunately, Microsoft provides some great tools to help improve performance and save money. In this article, Monica Rathbun explains how to take advantage of these features.  Read more...
By Additional Articles 2019/03/19 | Source: SimpleTalk | Category: automatic tuning
Rating: (not yet rated)  Rate this |   Briefcase | 1,600 reads
 

From the SQLServerCentral Blogs

There is Now A Delete Activity in Data Factory V2!

Data Factory can be a great tool for cloud and hybrid data integration. But since its inception, it was less...  Read more...
By meaganl 2019/03/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,127 reads

SQL Server 2017 Reporting Services: The Basics Part 5

We’re now on Part 5 of our SQL Server Reporting Services Basics Series. In this installment, we’ll learn how to...  Read more...
By MarlonRibunal 2019/03/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,998 reads
Question of the Day

Using table hint TabLock

By Junior Galvão - MVP 2019/03/21 | Category: table hint
Rating: (not yet rated) |  Discuss |   Briefcase | 140 reads

You start executing the code block declared below:


BEGIN TRANSACTION TTBL;
DECLARE @Counter TINYINT = 1;
SELECT 'BEGIN...';
WHILE @COUNTER < 255
BEGIN
UPDATE
TabLockTable WITH (TABLOCK) SET
Valores = @Contador WHERE Codigo = 10;
SELECT Valores FROM TabLockTable...  Read more...
Latest forum posts