SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 21 to 40 of 15666    Older >>
 

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,782 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,169 reads

How do you come up with creative ideas?

It takes a creative mind to come up with new ideas. So how do you do it?  Read more...
By Ben Kubicek 2017/04/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 56 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 | 2,380 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,348 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,169 reads

Python in SQL Server

The Python language has been added to SQL Server 2017.  Read more...
By Steve Jones 2017/04/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 123 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 | 3,208 reads

Byte Me: Functional Fashion

By Bob Lang 2017/04/19 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 103 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,169 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,169 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,638 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,684 reads

Working with Tables in Azure SQL Data Warehouse

In this next installment of our series on Azure SQL Data Warehouse, we'll look at tables and the options for how we decide to create them for optimum performance.  Read more...
Rating: |  Discuss |   Briefcase | 426 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,169 reads

SQL Server Telemetry

SQL Server captures information about usage and send it to Microsoft. Is that a problem? Not for Steve Jones.  Read more...
By Steve Jones 2017/04/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Moving from application automation to true DevOps by including the database

Tom Austin talks about the challenges that arise from trying to include the database in your DevOps process.  Read more...
By Additional Articles 2017/04/18 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,540 reads

Scaling out SSRS on SQL Server Standard Edition 

The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is an Enterprise Edition-only feature. So when Rodney Landrum was tasked with implementing a scale-out solution, with failover, for SSRS on SQL Server Standard Edition, it required some creative thinking. This article describes his solution, its merits and drawbacks.  Read more...
By Additional Articles 2017/04/18 | Source: SimpleTalk | Category: reporting services (ssrs)
Rating:  Rate this |   Briefcase | 2,855 reads

The Connection to the Primary Replica is not Active

In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.  Read more...
By Ganapathi varma Chekuri 2017/04/17 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 113 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,169 reads
<< Newer    Items 21 to 40 of 15666    Older >>