SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Batch SSIS pkg execution from Business Intelligence Development Studio

The Execute Package Task and a second instance of Business Intelligence Development Studio can be a satisfactory method of background execution of SSIS packages in batch mode when you don't have access to Integration Services.  Read more...
By Stan Kulp 2017/07/11 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 701 reads

Continuous Database Deployment with Confidence

To achieve gains from Database Lifecycle Management in general, and in Continuous Deployment in particular, it pays to aim for lightweight but consistent techniques and processes, refining them iteratively in the light of experience. Edward Elliott describes a Test-driven development process for developing SQL Server databases that worked for CD, based on a series of steps. Though the tools for CD may be necessary, they are not sufficient, without an effective structured process.  Read more...
By Additional Articles 2017/07/11 | Source: SimpleTalk | Category: continuous deployment (cd)
Rating:  Rate this |   Briefcase | 2,892 reads

Top 10 DevOps Operational Requirements

One of the key tenets in DevOps is to involve the Operations team in the full software development lifecycle and, in particular, to ensure that operational requirements are incorporated into the design and build phases.  Read more...
By Additional Articles 2017/07/11 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,939 reads

Birds of a Feather

What makes SQL Server professionals stick together? Can we draw any conclusions from this?  Read more...
By Hakim Ali 2017/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 80 reads

The Panjandrum Conundrum

With progress thwarted by a committee of panjandrums, will T-SQL forever remain in the doldrums? So wonders Phil Factor.  Read more...
By Phil Factor 2017/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 64 reads

What You Need To Know About DR Testing

Practice makes perfect. That’s true of everything, including disaster recovery. If you aren’t already testing your DR plan, you should be - here’s what you need to know to get started.  Read more...
By Tim Mullahy 2017/07/10 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 395 reads

Introduction to Azure SQL Datab Sync

The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Preview since its introduction 7 years ago. Fortunately, there are signs that this service might be finally reaching production-ready state. In this article, Martin Pollicht introduces its main characteristics.  Read more...
By Additional Articles 2017/07/10 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,287 reads

Azure DWH part 10: WPF and Azure SQL Data Warehouse

In this article, we will show how to create a WPF application and show how to insert data to ASDW.  Read more...
Rating: |  Discuss |   Briefcase | 377 reads

PowerShell Tool Time: The Tool Framework

Start learning Powershell (PoSh) for SQL Server and improve your ability to write utilities that will make your job easier.  Read more...
By Mike Fal 2017/07/07 (first published: 2015/08/19) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 8,508 reads

Troubleshooting CPU Performance on VMware

Jonathan Kehayias discusses SQL Server on VMware, and how to monitor CPU performance – with or without access to vCenter.  Read more...
By Additional Articles 2017/07/07 | Source: SQLPerformance.com | Category: cpu performance
Rating: (not yet rated)  Rate this |   Briefcase | 4,488 reads

Learning Data Modeling

Today Steve Jones is looking for database design resources.  Read more...
By Steve Jones 2017/07/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 100 reads

SSIS - Execute Package Task

The Execute Package Task is an essential tool for any SSIS developer. Learn how to get the most from it.  Read more...
Rating: |  Discuss |   Briefcase | 1,174 reads

The March of AI

Steve Jones talks about the changes that AI may bring to our jobs.  Read more...
By Steve Jones 2017/07/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads

How to Generate a Restore Script

There are multiple ways to accomplish a database restore. But if you wanted to restore a database from a script how might you accomplish that task quickly and accurately?  Read more...
By Additional Articles 2017/07/06 | Source: Database Journal | Category: restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,522 reads

You’re not delivering DevOps to the database

"There have been, and, in our increasingly connected and interconnected world, will continue to be, a large number of spectacular failures with technology. I want to point the finger at all of us for these failures. It’s not Development. It’s not Operations. It’s us. We’re in it together. If we don’t communicate with each other, share our knowledge, we’re going to mess up horribly."  Read more...
By Grant Fritchey 2017/07/06 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,792 reads

Byte Me: Paranormal Presence

By Bob Lang 2017/07/05 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

Machine Learning for Outlier Detection in R

A look into clustering to detect outliers in R. An extension on univariate statistical tests to include multivariate data.  Read more...
By Nick Burns 2017/07/05 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 571 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2017/07/05 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 65,943 reads

The Basics of Good T-SQL Coding Style

TSQL Code must work properly and efficiently. That's not enough though. Unless you are working alone, have perfect memory and plan to never change job, then you need to comment and document your code, it must be inherently readable, well laid out, use informative and obvious names, and it must be robust and resilient; written defensively. It must not rely on deprecated features of SQL Server, or assume particular database settings. Robert Sheldon starts a series of articles that explains the basics.  Read more...
By Additional Articles 2017/07/05 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 5,247 reads

Independence Day 2017

A holiday in the US has Steve Jones thinking about compromise and communication.  Read more...
By Steve Jones 2017/07/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads
<< Newer    Items 41 to 60 of 15929    Older >>