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

Headlines today   December 17, 2018

TOP vs Max/Min: Is there a difference?

Is there a difference between using TOP and MAX/MIN to return and end value to a table?  Read more...
By Mike Byrd 2018/12/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 139 reads

Power BI Introduction: Visualizing SQL Server Audit Data — Part 9

SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results.  Read more...
By Additional Articles 2018/12/17 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 400 reads

Database DevOps without compromising the data

Database DevOps has arrived and is here to stay. However this has also brought friction with the increasing importance of data privacy and protection. Redgate’s Compliant Database DevOps whitepaper outlines how you can introduce DevOps processes and their benefits while also keeping your information and data safe.  Read more...
By 2018/12/17 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 325 reads
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,845 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 | 2,171 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,828 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 | 254 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,820 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,596 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,485 reads

From the SQLServerCentral Blogs

Adding the Constraint Name to the PK at the End of Create Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...  Read more...
By Steve Jones 2018/12/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,176 reads

Gathering all the Logs and Running the Availability Group Failover Detection Utility with PowerShell

30/11/2018 – Function has been updated to deal with named instances. Last week the Tiger Team released their Availability Group Failover Detection...  Read more...
By Rob Sewell 2018/12/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 707 reads
Question of the Day

Cost threshold for parallelism

By Kendra.Little 2018/12/17 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

What does the "cost threshold for parallelism" setting configure in SQL Server?

Latest forum posts