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,356 DBAs, developers and SQL Server users

Rss
Headlines today   February 20, 2017

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,060 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 | 1,906 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,376 reads
Previous headlines

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 | 32,880 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 | 1,975 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 | 62 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,729 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,732 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: SQLServerCentral.com | Category: vnext
Rating: |  Discuss |   Briefcase | 1,822 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: SQLPerformance.com | Category: compression
Rating: (not yet rated)  Rate this |   Briefcase | 4,394 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

SQL Clone and Encryption

I’ve been testing and working with SQL Clone for the last few months, trying to help the devs at Redgate...  Read more...
By Steve Jones 2017/02/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 533 reads
Question of the Day

Which President

By Steve Jones 2017/02/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 508 reads

For President's Day, which one of these is President George H. W. Bush? 

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
6888 54161 SSC Guru  
2.
Jeff Moden
6438 51585 SSC Guru  
3.
Steve Jones - SSC Editor
4246 40404 SSC-Forever  
4.
Lowell
2570 17529 SSCoach  
5.
Lynn Pettis
2251 26458 One Orange Chip  
Latest forum posts