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,430 DBAs, developers and SQL Server users

Previous headlines

Streamline Log Shipping Failovers: DR Made Just For You…

A look at a SQL script solution that can help you easily fail over and back from log shipping scenarios.  Read more...
By Micah Nikkel 2018/12/14 (first published: 2015/09/08) | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 2,828 reads

Not So Forced Parameterization

If you can't get forced parameterization to work due to variables, try using a temp table instead.  Read more...
By Additional Articles 2018/12/14 | Source: MSSQLTips.com | Category: forced parameterization
Rating: (not yet rated)  Rate this |   Briefcase | 1,991 reads

Review your SQL Server permissions with SQL Census (in preview)

SQL Census allows users to gain a clear picture of SQL Server access, from SQL roles and permissions to Active Directory account and group memberships. The tool provides a simplified view of these permissions, along with the path by which they were gained. There's more to come and you can help shape the future of the tool by joining the preview now.  Read more...
By 2018/12/14 | Source: Redgate | Category: sql census
Rating: (not yet rated)  Rate this |   Briefcase | 1,664 reads

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 | 249 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 | 3,733 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 | 1,555 reads

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,484 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,556 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,894 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 | 454 reads

Question of the Day

When Statistics Update

By Kendra.Little 2018/12/14 | Category: configuration
Rating: (not yet rated) |  Discuss |   Briefcase | 379 reads

Which configuration changes the threshold at which statistics are automatically updated in SQL Server 2016 to a dynamic threshold based on the table's rowcount? (Rather than the old threshold of...  Read more...
Latest forum posts