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

Enable Trace Flags in SQL Server

Learn how to enable trace flags to change the behavior of your SQL Server instance.  Read more...
By Steve Jones 2017/03/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,528 reads

Deployment Automation for SQL Server Integration Services (SSIS)

SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages needs a way of scripting the deployment of them if the database is to be deployed rapidly, or via a build server. Nat Sundar shows a technique that can be extended to manage the scripted deployment of SSIS projects.  Read more...
By Additional Articles 2017/03/15 | Source: SimpleTalk | Category: integration services (ssis)
Rating:  Rate this |   Briefcase | 5,640 reads

Adding Years, Months and Days

Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.  Read more...
By Pete Revell 2017/03/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,262 reads

Managing Azure SQL Database Recovery

Azure SQL Database offers several benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy. You can take advantage of this functionality to facilitate failover and failback in response to events that affect availability of an Azure region.  Read more...
By Additional Articles 2017/03/14 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 3,410 reads

2016 Salary Survey in PowerBI

A PowerBI Presentation using the data from the 2016 Salary Survey  Read more...
By Christopher Huntley 2017/03/13 | Source: SQLServerCentral.com | Category: salary survey
Rating: |  Discuss |   Briefcase | 1,704 reads

Introducing DevOps to Farm Credit Services of America

Identifying a need for better collaboration between teams is only the first step to introducing DevOps workflows into your organization. You also need to define a common DevOps goal, a strategy to achieve it, and then to break down this strategy into series of manageable tasks for each team. Bob Walker describes how Farm Services of America started to "do DevOps".  Read more...
By Additional Articles 2017/03/13 | Source: SimpleTalk | Category: devops
Rating:  Rate this |   Briefcase | 2,876 reads

Understanding Graphical Execution Plans - Part 1: Explaining the Plan

Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.  Read more...
By Darren White 2017/03/10 (first published: 2014/02/18) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 29,825 reads

TroubleShooting SQL Server Memory Consumption

Satnam Singh walks through the steps he took to troubleshoot a recent issue with memory consumption on a staging server.  Read more...
By Additional Articles 2017/03/10 | Source: SQL Server Performance | Category: troubleshooting
Rating: (not yet rated)  Rate this |   Briefcase | 5,874 reads

Azure DWH Part 5: How to work with the command line in Azure SQL DW

This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse  Read more...
By Daniel Calbimonte 2017/03/09 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 569 reads

Redgate Data Tools in Visual Studio 2017 Enterprise

Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.  Read more...
By Additional Articles 2017/03/09 | Source: SQLServerCentral.com | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 5,064 reads

SQL Migrator (Part 2)

Automated Upgrade\Migration Tool for SQL Server 
By Datamate Technology 2017/03/09 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 465 reads

Exploring Azure Storage for SQL Server DBAs

If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a great effect on its performance. If performance is important, you are likely to discover complications and barriers in the storage options when you come to provision the server. If you get it wrong, you could end up with an expensive service. Joshua explains the value of using a lab environment to allow you to make well-informed VM storage decisions when the time comes to provision your production system.  Read more...
By Additional Articles 2017/03/09 | Source: SimpleTalk | Category: azure storage
Rating:  Rate this |   Briefcase | 2,690 reads

TempDB Database On a Local Disk for an FCI

The article is about Configuring TempDB Database on Local Disk in SQL Server 2012/2014 Failover Cluster to improve performance.  Read more...
By Sadan Kumar Budde 2017/03/08 | Source: SQLServerCentral.com | Category: failover
Rating: |  Discuss |   Briefcase | 1,151 reads

SQL Migrator (Part 1)

Read about a free automated Upgrade\Migration Tool for SQL Server.  Read more...
By Datamate Technology 2017/03/08 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 693 reads

Move Azure SQL Databases using the Export and Import PowerShell cmdlets

John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.  Read more...
By Additional Articles 2017/03/08 | Source: MSSQLTips.com | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 3,493 reads