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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,910,331 DBAs, developers and SQL Server users

Headlines today   December 13, 2018

Native SQL Backups for Amazon RDS Databases

Use native SQL Server backups with Amazon RDS databases to easily import and export data between local server and the AWS cloud.  Read more...
By Bill Brightman 2018/12/13 | Source: SQLServerCentral.com | Category: amazon
Rating: |  Discuss |   Briefcase | 174 reads

There is a New COUNT in Town

Now that SQL Server 2019 is on the way, it’s time to start learning about the new capabilities. In this article, Greg Larson tests the new APPROX_COUNT_DISTINCT function for performance and accuracy.  Read more...
By Additional Articles 2018/12/13 | Source: SimpleTalk | Category: sql server 2019
Rating: (not yet rated)  Rate this |   Briefcase | 2,621 reads

Whitepaper: Data Catalogs - the case for SQL Server

This whitepaper discusses the importance of data catalogs, the benefits they bring to businesses, and the capabilities and features required. It also outlines how data catalogs help organisations comply with data privacy regulations such as HIPAA, SOX and the GDPR  Read more...
By 2018/12/13 | Source: Redgate | Category: data catalogs
Rating: (not yet rated)  Rate this |   Briefcase | 924 reads
Previous headlines

Stairway to SQL Server Security Level 11: Auditing

By defining server- and database-level audits, you can record just about any kind of event that occurs in SQL Server, which can be an invaluable source of security troubleshooting and forensic information when security breaches occur. In this stairway level you’ll learn how to define the various audit specification objects, how to capture audit data, and how to explore and use the data.  Read more...
By Don Kiely 2018/12/12 (first published: 2015/09/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,447 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2018/12/12 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 103,258 reads

PowerShell Module to Read Directory Contents and Store in a SQL Server Table

In this tip we will walk through how to create a PowerShell module to get a list of files and subfolders of a Windows folder and store this information in a SQL Server table.  Read more...
By Additional Articles 2018/12/12 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,596 reads

Database Snapshot Use Case: Service Migration

In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.  Read more...
By Kenneth Igiri 2018/12/11 | Source: SQLServerCentral.com | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 430 reads

Adopting Compliant Database DevOps at PASS

To help meet the requirements of the GDPR, PASS teamed up with Redgate to implement Compliant Database DevOps. This benchmark process has streamlined PASS’ database development pipeline, and strengthened their ability to uphold data privacy regulations such as the GDPR.   Read more...
By 2018/12/11 (first published: 2018/11/14) | Source: Redgate
Rating: (not yet rated)  Rate this |   Briefcase | 6,061 reads

SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now

Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!  Read more...
By Additional Articles 2018/12/11 | Source: Database Journal | Category: sql server 2019
Rating: (not yet rated)  Rate this |   Briefcase | 1,647 reads

An Overview of STRING_SPLIT()

Learn how to use the STRING_SPLIT() function in T-SQL.  Read more...
By Steve Jones 2018/12/10 | Source: SQLServerCentral.com | Category: string_split()
Rating: |  Discuss |   Briefcase | 1,315 reads

From the SQLServerCentral Blogs


Someone asked a question about TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking), which are two different technologies that...  Read more...
By Steve Jones 2018/12/13 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,497 reads

New Resumable Online Index Create SQL Server 2019

SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of...  Read more...
By SQLEspresso 2018/12/13 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,485 reads
Question of the Day

Temporary Tables and Stored Procedures

By Kendra.Little 2018/12/13 | Category: temporary tables
Rating: (not yet rated) |  Discuss |   Briefcase | 485 reads

Which of the following is TRUE about temporary tables used in stored procedures?

Latest forum posts