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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,880,426 DBAs, developers and SQL Server users

Rss
Headlines today   February 21, 2017

In Search of Elasticity

An Evaluation of the Azure SQL Database Ecosystem.  Read more...
By Alex Chamchourine 2017/02/21 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 512 reads

Getting Started with Azure SQL Data Warehouse - Part 1

As the demand for data analytics grows so does the need for a technology or platform to process large amounts of different types of data in timely manner. Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just a few minutes. Read on to learn more about this data warehouse-as-a-service offering from Microsoft.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,690 reads
Previous headlines

Back to Basics: Capturing Baselines on Production SQL Servers

If you have not been capturing baselines on your production servers, then today is the day you can start. This article provides scripts, valid for SQL Server 2005 and higher, which anyone can use to capture basic information about a SQL Server instance.  Read more...
By Erin Stellato 2017/02/20 (first published: 2012/11/27) | Source: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 29,502 reads

New CREATE OR ALTER statement in SQL Server 2016 SP1

Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.  Read more...
By Additional Articles 2017/02/20 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,808 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 | 3,858 reads

Using EXCEPT to Determine Row Differences

How to use the EXCEPT statement to perform row differences.  Read more...
By M. Douglas Bowan II 2017/02/17 (first published: 2014/03/25) | Source: SQLServerCentral.com | Category: except
Rating: |  Discuss |   Briefcase | 33,051 reads

Introduction to SAP HANA on Azure

Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, this trend has been exemplified by advancements in support for SAP-based solutions on Microsoft Azure. Marcin Policht provides an overview, focusing in particular on support for SAP HANA on Azure.  Read more...
By Additional Articles 2017/02/17 | Source: Database Journal | Category: sap hana
Rating: (not yet rated)  Rate this |   Briefcase | 2,110 reads

vCenter Server fails to start, Purge and Shrink Vcenter SQL Database

In this article, you will learn how to troubleshoot If your vCenter Server fails to start and and manually purge the Vcenter database if required.  Read more...
By Ganapathi varma Chekuri 2017/02/16 | Source: SQLServerCentral.com | Category: vcenter
Rating: |  Discuss |   Briefcase | 77 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,839 reads

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 | 2,866 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Power BI in SSRS – T-SQL Tuseday

T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 1,922 reads

Managing Bad Data

In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL...  Read more...
By Tim Mitchell 2017/02/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 953 reads
Question of the Day

Data import files

By Steve Jones 2017/02/21 | Category: bulk insert
Rating: (not yet rated) |  Discuss |   Briefcase | 444 reads

I have a SQL Server 2016 instance and want to use BULK INSERT to load data. What file types can I import? Note that native refers to the native binary...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
7210 54521 SSC Guru  
2.
Jeff Moden
6648 51863 SSC Guru  
3.
Steve Jones - SSC Editor
4361 40593 SSC-Forever  
4.
Lowell
2718 17691 SSCoach  
5.
Lynn Pettis
2333 26578 One Orange Chip  
Latest forum posts