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

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

Lists With, or Without, Ranges in both T-SQL and PowerShell

Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.  Read more...
By Additional Articles 2017/02/16 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 3,168 reads

SQL Server vs SQL Server v.Next

An introduction to the basics of current SQL Server vs v.Next Performance Testing.  Read more...
By Henrico Bekker 2017/02/15 | Source: | Category: vnext
Rating: |  Discuss |   Briefcase | 1,948 reads

What Would You Do if Your Company Was Targeted?

Today we have a guest editorial that asks what you might do if you knew a hacker was coming after your organization.  Read more...
By Andy Warren 2017/02/15 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

Compression and its Effects on Performance

Erin Stellato takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.  Read more...
By Additional Articles 2017/02/15 | Source: | Category: compression
Rating: (not yet rated)  Rate this |   Briefcase | 4,977 reads

Extending DevOps practices to SQL Server databases

In this free webinar, Steve Jones and Arneh Eskandari show how Redgate’s Database DevOps solution works with Visual Studio Team Services to improve your database delivery process. Register now.  Read more...
By 2017/02/20 (first published: 2017/02/15) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 4,346 reads

Quality Provides Traction/Velocity

Quality is a driver for productivity. Or so say I. What do you think.  Read more...
By Gary Varga 2017/02/14 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 62 reads

The Power of the Data Model

A data model is far more powerful than simply a set of build instructions for DBAs. It can be used to shape business thought and actions for the benefit of all.  Read more...
By David Poole 2017/02/14 | Source: | Category: data modeling
Rating: |  Discuss |   Briefcase | 1,582 reads

Quick Testing with SQL Clone Images

Steve Jones explains how SQL Clone can be used to create multiple copies of a database for different testing scenarios, while using just a fraction of the disk space. For example for developers to experiment in sandbox environments, with full copies of large databases, without the hassle and delays of restoring backups or copying database files.   Read more...
By Steve Jones 2017/02/14 | Source: | Category: provisioning
Rating: (not yet rated) |  Discuss |   Briefcase | 480 reads

Office Hours Webcast 2017/02/01

In this edition of Office Hours, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, their favourite high availability solutions, and more.  Read more...
By Additional Articles 2017/02/14 | Source: Brent Ozar Unlimited Blog | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 2,701 reads

How to import data to Azure SQL Data Warehouse using SSIS

In this article, we will use SSIS to import a CSV file to Azure SQL Data Warehouse.  Read more...
By Daniel Calbimonte 2017/02/13 | Source: | Category: ssis
Rating: |  Discuss |   Briefcase | 613 reads

How to Build Your First SQL Server Virtual Lab in Windows Azure

If you are a DBA who hasn't so far dived in head-first into using Azure, it is worth setting up an Azure 'Virtual Lab' environment the easy way, using a template. This will then allow you to experiment, try things out with SQL Azure, and get familiar with Resource Groups. Joshua shows how to build a virtual lab, from the ground up in the first of a series that aims to give you a grounding in Azure.  Read more...
By Additional Articles 2017/02/13 | Source: SimpleTalk | Category: azure
Rating:  Rate this |   Briefcase | 3,471 reads

Problems With Database Problems

The GitLab crisis has Steve Jones thinking about two things: competence and care.  Read more...
By Steve Jones 2017/02/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

The Second Career

From a well-built cockney who knew how to avoid wheel clamps, to an ex-member of an elite anti-riot unit, some of the best DBAs have a surprising diversity of skills and experiences, according to Phil Factor.  Read more...
By Phil Factor 2017/02/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 76 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2017/02/10 (first published: 2015/09/29) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,848 reads

Query Performance Tuning – A Methodical Approach

Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.  Read more...
By Gail Shaw 2017/02/10 (first published: 2015/06/08) | Source: | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 15,588 reads

Moving Through Five Years

An updated editorial. The five years are almost up for the prediction that IT departments would be eliminated. Read Steve Jones thoughts on where we are today.  Read more...
By Steve Jones 2017/02/10 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 93 reads

Reconciling Data Across Systems Using a Reconciliation Hub

In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task of checking and reconciling data as it flows between systems. Discrepancies in data must be detected, tracked and corrected as quickly as possible: there is no room for error in doing this. A Reconciliation Hub can provide the answer, as Rahul Gupta explains.  Read more...
By Additional Articles 2017/02/10 | Source: SimpleTalk | Category: bi
Rating:  Rate this |   Briefcase | 2,592 reads

Data masking survey and prize draw

The Foundry team at Redgate know that managing sensitive and regulated data can be both challenging and problematic. They want to solve these problems, but first need your help to better understand them in context. What do you find frustrating? What would save you time? Please fill out this short survey to let them know, and as a thanks for your time, at the end you'll be entered into a draw to win a $100 Amazon gift card.  Read more...
By 2017/02/16 (first published: 2017/02/10) | Source: Redgate | Category: survey
Rating:  Rate this |   Briefcase | 2,997 reads

Fix Commvault Backup Failures After an Upgrade

In this article, you will learn how to troubleshoot backup failures in SQL Server 2016 when you run using commvault backup tool  Read more...
By Ganapathi varma Chekuri 2017/02/09 | Source: | Category: commvault
Rating: |  Discuss |   Briefcase | 426 reads

How Incorrect SQL Server Table Statistic Estimates Can Cause Slow Query Execution

Ben Snaidero explains that if you are updating your SQL Server table statistics nightly, but still seeing occasional poor performance with some of the queries being executed against my database, statistics could be the issue.  Read more...
By Additional Articles 2017/02/09 | Source: | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 3,413 reads
<< Newer    Items 21 to 40 of 15484    Older >>