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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,907,256 DBAs, developers and SQL Server users

Previous headlines

Learning R in SQL Server

Learn about the new R Services in SQL Server 2016  Read more...
By Site Owners 2018/09/21 (first published: 2016/01/04) | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 5,515 reads

Locks Taken During Indexed View Modifications

Careful adding tables into your indexed views. 
By Additional Articles 2018/09/21 | Source: Brent Ozar Unlimited Blog | Category: locks
Rating: (not yet rated)  Rate this |   Briefcase | 1,047 reads

Adding User Comments to Reports in SQL Server Reporting Services

In this tip we look at a new feature in SQL Server Reporting Services that allows users to leave comments about reports.  Read more...
By Additional Articles 2018/09/21 | Source: MSSQLTips.com | Category: comments
Rating: (not yet rated)  Rate this |   Briefcase | 1,448 reads

Identifying the right Service tier for Azure Database

Determining the number of DTUs which will help in deciding the service tier for Azure SQL.  Read more...
By Deepak Prasad Sahu 2018/09/20 | Source: SQLServerCentral.com | Category: azure sql database
Rating: (not yet rated) |  Discuss |   Briefcase | 331 reads

Pseudonymizing a Database with Realistic Data for Development Work

In this article Phil Factor shows us how to surgically alter data from an entire database that can identify individuals but leave everything else intact.  Read more...
By 2018/09/20 | Source: Redgate | Category: sql data generator
Rating: (not yet rated)  Rate this |   Briefcase | 2,067 reads

Advanced Testing of Your PowerShell Code with Pester

Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.  Read more...
By Additional Articles 2018/09/20 | Source: SimpleTalk | Category: test
Rating: (not yet rated)  Rate this |   Briefcase | 1,317 reads

Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages

In this next level of the Stairway to Biml, we will examine how you can use the information stored in your RDBMS to build packages.  Read more...
By Andy Leonard 2018/09/19 | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 323 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2018/09/19 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 100,071 reads

The Changing Role of SQL Server Monitoring

As SQL Server estates continue to grow quickly, and change in nature, due to the ease with which new cloud-based, containerized or virtual machine-based SQL Servers can be provisioned, so too the role of the monitoring tool changes.  Read more...
By 2018/09/19 | Source: Redgate | Category: sql monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 1,668 reads

Loading CSV Files Using Dynamic SQL

In this article, we will see of a quick way to load CSV files from a directory on your computer.  Read more...
By Steven Tidwell 2018/09/18 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,494 reads

Question of the Day

Creating Strings with Replicate

By David Fundakowski 2018/09/21
Rating: (not yet rated) |  Discuss |   Briefcase | 469 reads

What will the output be of the following:

DECLARE @string NVARCHAR(max) = (

SELECT DATALENGTH(@string) 
Latest forum posts