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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,900,073 DBAs, developers and SQL Server users

Rss
Headlines today   April 24, 2018

Packaged-Application Database Nightmares - A Horror Story

The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare?  Read more...
By John F. Tamburo 2018/04/24 (first published: 2015/12/22) | Source: SQLServerCentral.com | Category: packaged applications
Rating: |  Discuss |   Briefcase | 4,999 reads

Approaches to masking email addresses

There are several ways to to anonymize / pseudonymize email addresses. This post discusses a few frequently used approaches, as well as how you can use Redgate Data Masker for SQL Server to achieve realistic masking of email columns.  Read more...
By 2018/04/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,511 reads

Alerts and Notfications for SQL Server Login, Database User and Role Membership Changes

Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.  Read more...
By Additional Articles 2018/04/24 | Source: MSSQLTips.com | Category: alerts
Rating: (not yet rated)  Rate this |   Briefcase | 1,487 reads
Previous headlines

Cancelling DBCC SHRINKFILE with EMPTYFILE

A fun experiment using DBCC SHRINKFILE to rebalance data.  Read more...
By Steve Jones 2018/04/23 | Source: SQLServerCentral.com | Category: dbcc shrinkfile
Rating: |  Discuss |   Briefcase | 671 reads

How to Programmatically Identify When Your SQL Server Was Last Started

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.  Read more...
By Additional Articles 2018/04/23 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 2,435 reads

Spring into the Latest Features at the Luxemborg User Group

The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.  Read more...
By Additional Articles 2018/04/23 | Source: SQLServerCentral.com | Category: user groups
Rating: |  Discuss |   Briefcase | 63 reads

Custom Metrics for Detecting Problems with Ad-hoc Queries

A common SQL Server crime is the unnecessary overuse of ad-hoc queries by applications. In this article, Phil Factor shares some custom queries for monitoring problems that can be caused by this.  Read more...
By 2018/04/23 | Source: SimpleTalk | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 1,804 reads

Making Deployments Simpler with Re-runnable Scripts

Make sure your SQL Server database release scripts to make life easier.  Read more...
By Ed Elliott 2018/04/20 (first published: 2015/11/17) | Source: SQLServerCentral.com | Category: releases
Rating: |  Discuss |   Briefcase | 5,331 reads

How to Show the Execution Plan of a Running Query

By looking at a query execution plan, you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the queries that are currently running?  Read more...
By Additional Articles 2018/04/20 | Source: Database Journal | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 3,244 reads

Do you check your backups?

Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.  Read more...
By Michael Higgins 2018/04/19 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 759 reads
 

From the SQLServerCentral Blogs

Azure SQL Database vCore

vCore based performance levels are very new, currently in preview and not yet rolled out to all Azure regions (The...  Read more...
By Arun Sirpal 2018/04/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,354 reads

24 Hours of PASS – April 25th–26th

Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours...  Read more...
By Thomas LeBlanc 2018/04/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,680 reads
Question of the Day

Starting Extended Events

By Steve Jones 2018/04/24 | Category: extended events (xe)
Rating: (not yet rated) |  Discuss |   Briefcase | 358 reads

I have an Extended Event (XE) session called "QueryTuning". How do I start this session on my instance in T-SQL?

  Read more...
Latest forum posts