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

Previous headlines

Display SSIS package version on the Control Flow design surface

In this article I will show a simple trick to display version information on the Control Flow surface, so we immediately see which version and build we are modifying.  Read more...
By Herman van Midden 2017/04/28 (first published: 2015/08/04) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 3,711 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/28 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,241 reads

Getting Started with Azure SQL Data Warehouse - Part 3

Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this article, Arshad Ali discusses the different types of tables you can create in SQL Data Warehouse, how they impact performance and the best practices around them.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,524 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 | 913 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:  Rate this |   Briefcase | 3,170 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 | 1,282 reads

Obsoleting Unused SSRS Reports

Learn about programmatically obsoleting unused SSRS reports from your Report Server.  Read more...
Rating: |  Discuss |   Briefcase | 1,383 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 | 63,063 reads

Ask SQL Server Central

Question of the Day

With Redgate tools installed, how do you auto format SQL statements?

By Ben Kubicek 2017/04/28 | Category: auto format sql
Rating: (not yet rated) |  Discuss |   Briefcase | 423 reads

When Redgate Data Tools are installed in Visual Studio 2017 Enterprise, what key combination can you use to auto format SQL statements?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Jeff Moden
18299 90439 SSC Guru  
15304 91271 SSC Guru  
Steve Jones - SSC Editor
13018 65731 SSC Guru  
Grant Fritchey
12125 42417 SSC-Forever  
Lynn Pettis
6799 41186 SSC-Forever  
Latest forum posts