SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2017/04/12 to 2017/04/19

Package Parts – First Impressions

This article gives an overview of some good and not-so-good features of SSIS package parts.  Read more...
By SPT 2017/04/19 | Source: SQLServerCentral.com | Category: package parts
Rating: |  Discuss |   Briefcase | 1,361 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 2018/04/04 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 42,613 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,280 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 | 3,350 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 | 543 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 | 3,643 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 | 3,129 reads

Performance Myths : Clustered vs. Non-Clustered Indexes

Aaron Bertrand kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.  Read more...
By Additional Articles 2017/04/17 | Source: SQLPerformance.com | Category: clustered index
Rating: (not yet rated)  Rate this |   Briefcase | 5,145 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: always on
Rating: |  Discuss |   Briefcase | 302 reads

Creating Azure SQL Data Warehouse Databases

Learn how you can create an Azure SQL Warehouse database quickly and easily.  Read more...
Rating: |  Discuss |   Briefcase | 594 reads

Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services

One of the concepts that has recently been growing rapidly in popularity, in the context of cloud technologies, is DevOps. In this article, Marcin Policht looks at using DevOps principles in regard to Azure SQL Database deployments. To implement some of the more common DevOps practices, he will rely on Visual Studio Team Services.  Read more...
By Additional Articles 2017/04/14 | Source: Database Journal | Category: dacpac
Rating: (not yet rated)  Rate this |   Briefcase | 2,188 reads

Nuance of datetime data type in SQL Server

One of the most confusing data types in SQL Server is the datetime datatype.  Read more...
By Leo Peysakhovich 2017/04/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,940 reads

Harmful, Pervasive SQL Server Performance Myths

Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance.  Read more...
By Additional Articles 2017/04/13 | Source: SQLPerformance.com | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 4,580 reads

Using PerfMon and PAL to Diagnose SQL Issues

Free tools to help you find and diagnose SQL issues   Read more...
By Jim Youmans 2017/04/12 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,560 reads

Automating database deployments to and from source control using SQL Compare and PowerShell

Phil Factor shows how you can use the SQL Compare Pro command line with PowerShell to automate the task of getting a new database into version control, creating a new database build script, and creating a database migration script.  Read more...
By Additional Articles 2017/04/12 | Source: Redgate | Category: sql compare
Rating: (not yet rated)  Rate this |   Briefcase | 3,812 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2018/03/28 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 69,185 reads