Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 41 to 60 of 15575    Older >>
 

DevOps Isn't Perfect

Mistakes will still be made with a DevOps process, but the benefits outweigh the mistakes.  Read more...
By Steve Jones 2017/03/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 46 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...
Rating: (not yet rated)  Rate this |   Briefcase | 4,335 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 | 1,803 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 | 2,494 reads

GUI or CLI

The debate over the CLI or GUI is an age old debate.  Read more...
By Steve Jones 2017/03/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 77 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,617 reads

Change Your SQL Server Oil

Regular maintenance for your instance is important.  Read more...
By Steve Jones 2017/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 115 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: (not yet rated)  Rate this |   Briefcase | 2,543 reads

The Details are in the Small Print

Phil Factor on the rewards of learning the zen-like skill of writing, reading and understanding IT documentation.  Read more...
By Phil Factor 2017/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 33 reads

Only as Good as Your Auditor

Today we have a guest editorial from Andy Warren that talks about auditing your organization.  Read more...
By Andy Warren 2017/03/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 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 | 28,590 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,365 reads

How to work with the command line in Azure SQL Data Warehouse

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 | 369 reads

Database Cattle

Steve Jones says you should treat your database servers like cattle. It makes life easier.  Read more...
By Steve Jones 2017/03/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 99 reads

SQL Migrator (Part 2)

Automated Upgrade\Migration Tool for SQL Server  Read more...
By Datamate Technology 2017/03/09 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 423 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: (not yet rated)  Rate this |   Briefcase | 2,366 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 | 4,412 reads

The Migration Checklist

Today Steve Jones talks about the checklist you would want if you needed to move a SQL Server instance to new hardware.  Read more...
By Steve Jones 2017/03/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 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,049 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 | 643 reads
<< Newer    Items 41 to 60 of 15575    Older >>