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

Headlines today   December 18, 2018

Visualise SQL Server IO Stats

Visualise and compare the output of set statistics io on with Power BI to assist with performance tuning.  Read more...
By Philip Robinson 2018/12/18 | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 739 reads

SQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2

In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups.  Read more...
By Additional Articles 2018/12/18 | Source: MSSQLTips.com | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 1,486 reads

New Case Study: Ensuring HIPAA compliance with SQL Provision

New case study from Redgate. Since adopting SQL Provision, KEPRO, a leading US healthcare organization, have been able to achieve HIPAA compliance, save 15-20 hours a week in provisioning processes, and reclaim terabytes of disk space.   Read more...
By 2018/12/18 | Source: Redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,334 reads
Previous headlines

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: |  Discuss |   Briefcase | 1,275 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 | 2,075 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 | 1,414 reads

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,884 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,550 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 | 2,077 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 | 277 reads

From the SQLServerCentral Blogs

Oh Query, Query, Query

I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week. I...  Read more...
By Kenneth Fisher 2018/12/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,201 reads

Deadlocks in a SQL Server Database

Deadlocks in SQL Server happen when 2 (maybe more) processes are fighting over a resource in the database and are...  Read more...
By Justin Figg 2018/12/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,389 reads
Question of the Day

Counting Transactions

By Kendra.Little 2018/12/18
Rating: (not yet rated) |  Discuss |   Briefcase | 409 reads

Which of the following does the SQLServer: Databases\ Transactions/sec performance counter NOT count?

Latest forum posts