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,378 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,667 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,127 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 | 884 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,758 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,078 reads

Obsoleting Unused SSRS Reports

Learn about programmatically obsoleting unused SSRS reports from your Report Server.  Read more...
Rating: |  Discuss |   Briefcase | 1,255 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,941 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 | 396 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
16454 88090 SSC Guru  
2.
GilaMonster
13582 88975 SSC Guru  
3.
Steve Jones - SSC Editor
11789 64125 SSC Guru  
4.
Grant Fritchey
10910 40923 SSC-Forever  
5.
Lynn Pettis
6046 40204 SSC-Forever  
Latest forum posts