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

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

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,468 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,563 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,326 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 | 362 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 | 422 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,360 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,402 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 | 100 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,046 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 | 637 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 | 2,550 reads

Detective Stories - Tracking Down the Database's Dependents Part 2

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.  Read more...
By Brandie Tarvin 2017/03/07 | Source: SQLServerCentral.com | Category: database dependencies
Rating: |  Discuss |   Briefcase | 754 reads

Actionable Metrics

Metrics should help you learn, or otherwise change the behavior of the system.  Read more...
By Steve Jones 2017/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 66 reads

SSIS Catalog Compare v2.0 Launch Event

Join the SSIS Catalog Compare v2.0 Launch Event on Tue, Mar 7 at 13:00 EST.  Read more...
By Press Release 2017/03/07 (first published: 2017/03/03) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 4,989 reads

Query Store and In-Memory OLTP

Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics? This is an intriguing question that Enrico explores and answers.  Read more...
By Additional Articles 2017/03/07 | Source: SimpleTalk | Category: query store
Rating: (not yet rated)  Rate this |   Briefcase | 3,951 reads

Detective Stories - Tracking Down the Database's Dependents Part I

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.  Read more...
By Brandie Tarvin 2017/03/06 | Source: SQLServerCentral.com | Category: database dependencies
Rating: |  Discuss |   Briefcase | 1,084 reads

Containing the Work

Containers are valuable in many software domains. Are there places we, as data professionals, would like to use software containment?  Read more...
By Steve Jones 2017/03/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 49 reads
<< Newer    Items 41 to 60 of 15568    Older >>