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,388 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,672 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,238 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,176 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 | 889 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 | 2,789 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,094 reads

Obsoleting Unused SSRS Reports

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

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

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jeff Moden
16561 88262 SSC Guru  
2.
GilaMonster
13698 89121 SSC Guru  
3.
Steve Jones - SSC Editor
11893 64263 SSC Guru  
4.
Grant Fritchey
10991 41023 SSC-Forever  
5.
Lynn Pettis
6106 40276 SSC-Forever  
Latest forum posts