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

Headlines today   April 27, 2017

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 | 576 reads

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,192 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 | 1,646 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 | 634 reads
Previous headlines

Obsoleting Unused SSRS Reports

Learn about programmatically obsoleting unused SSRS reports from your Report Server.  Read more...
Rating: |  Discuss |   Briefcase | 1,164 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,748 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 | 921 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,095 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 | 734 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 | 740 reads
Question of the Day

Encrypting the data

Rating: (not yet rated) |  Discuss |   Briefcase | 346 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
15537 86692 SSC Guru  
12906 87823 SSC Guru  
Steve Jones - SSC Editor
11147 63035 SSC Guru  
Grant Fritchey
10324 40188 SSC-Forever  
Lynn Pettis
5687 39613 SSC-Dedicated  
Latest forum posts