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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,884,322 DBAs, developers and SQL Server users

Headlines today   April 27, 2017

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/27 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,199 reads

Performance Tuning Using Extended Events: Part 2

Part 2 of identifying performance puning opportunities using Extended Events. Learn how about shredding XML.  Read more...
By Brian Davey 2017/04/27 | Source: SQLServerCentral.com | Category: extended events
Rating: |  Discuss |   Briefcase | 712 reads

Doing Fuzzy Searches in SQL Server

A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.  Read more...
By Additional Articles 2017/04/27 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,085 reads

Free webinar: dealing with SQL Server asset management

In this interactive webinar, Microsoft Data Platform MVP Steve Jones and members of Redgate’s R&D division, Foundry, will lead a group discussion with attendees to take an in-depth look at the challenges of managing a SQL Server estate. They’ll cover the strategies for discovering the full extent of your estate, and look at how to mitigate security risks, ensure consistent server configurations, and respond to and prevent incidents. We’ll also share some horror stories on the way.   Read more...
By 2017/04/27 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 783 reads
Previous headlines

Obsoleting Unused SSRS Reports

Learn about programmatically obsoleting unused SSRS reports from your Report Server.  Read more...
Rating: |  Discuss |   Briefcase | 1,191 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2017/04/26 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 62,787 reads

How to setup a tabular data model in SSAS Azure

Microsoft announced the availability of SQL Server Analysis Services (SSAS) on Azure late last year. Siddharth Mehta walks through how to quickly set up a tabular data model in SSAS Azure.  Read more...
By Additional Articles 2017/04/26 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 938 reads

SSRS Audit: All reports executed/not-executed during previous 30 days

This article presents a pair of queries and reports that reads the ReportServer.dbo.ExecutionLog table to list all SSRS reports that were executed or not-executed in the past 30 days, how many times they were executed, and who executed them.  Read more...
By Stan Kulp 2017/04/25 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 1,112 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

Thoughts about the Microsoft Data Amp Announcements

Microsoft conducted a live event called Microsoft Data Amp to announce a number of key features and releases for SQL...  Read more...
By DataOnWheels 2017/04/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 843 reads

The Dead Tree Database

“We have all of that information. It’s in a database in my office.” This phrase was music to my ears....  Read more...
By Tim Mitchell 2017/04/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 892 reads
Question of the Day

Encrypting the data

Rating: (not yet rated) |  Discuss |   Briefcase | 415 reads

I am creating a Database Encryption Key for use in TDE. What are the options for an algorithm in SQL Server 2016?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Jeff Moden
15560 86897 SSC Guru  
12906 87992 SSC Guru  
Steve Jones - SSC Editor
11162 63196 SSC Guru  
Grant Fritchey
10362 40278 SSC-Forever  
Lynn Pettis
5666 39686 SSC-Dedicated  
Latest forum posts