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

Previous headlines

Stairway to Columnstore Indexes Level 2: Columnstore Storage

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.  Read more...
By Hugo Kornelis 2017/04/21 (first published: 2015/04/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,633 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/21 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 998 reads

Extending DevOps practices to SQL Server databases

In this free demo webinar, Grant Fritchey and Arneh Eskandari will show how Redgate tools enable you to push and pull database changes in Git, then set up an automated database build and deployment process using TeamCity and Octopus Deploy.   Read more...
By 2017/04/21 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,553 reads

Performance Tuning Using Extended Events: Part 1

In this article, learn how to identify performance tuning opportunities using Extended Events.  Read more...
By Brian Davey 2017/04/20 | Source: SQLServerCentral.com | Category: extended events
Rating: |  Discuss |   Briefcase | 1,050 reads

The right way to approach a legacy code base

Andrea Angella shares what he learned from attending Michael Feather's workshop on working effectively with legacy code.  Read more...
By Additional Articles 2017/04/20 | Source: Redgate | Category: software development
Rating: (not yet rated)  Rate this |   Briefcase | 2,410 reads

Package Parts – First Impressions

This article gives an overview of some good and not-so-good features of SSIS package parts.  Read more...
By Shubhankar Thatte 2017/04/19 | Source: SQLServerCentral.com | Category: package parts
Rating: |  Discuss |   Briefcase | 1,085 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2017/04/19 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 23,283 reads

Working with the BigInt Type in Node and SQL Server

Node.JS and SQL Server are a good match for creating non-blocking, event-driven database applications. Though you can use ODBC or JDBC to communicate between the two, it is possible to run such applications on platforms such as Azure, Linux, OSX and iOS by using Node together with the JavaScript TDS library called 'Tedious'. 'Tedious' is a mature product but it is still possible to get things wrong in converting SQL Server datatypes such as BigInt to native Javascript data.  Read more...
By Additional Articles 2017/04/19 | Source: SimpleTalk | Category: bigint
Rating: (not yet rated)  Rate this |   Briefcase | 2,074 reads
 


Ask SQL Server Central

Question of the Day

Window Functions for Row Number

By Jeff Atherton 2017/04/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 611 reads

Which one of the following has the correct syntax for the Row Number function and will not generate an error?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jeff Moden
17704 84449 SSC Guru  
2.
GilaMonster
15219 86116 SSC Guru  
3.
Grant Fritchey
12792 39001 SSC-Dedicated  
4.
Steve Jones - SSC Editor
11981 61393 SSC Guru  
5.
Lynn Pettis
6683 38885 SSC-Dedicated  
Latest forum posts