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

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,684 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,747 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 | 36 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,607 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,520 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,712 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 | 3,986 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/15 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,741 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: SQLServerCentral.com | Category: data modeling
Rating: |  Discuss |   Briefcase | 1,490 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: SQLServerCentral.com | Category: provisioning
Rating: (not yet rated) |  Discuss |   Briefcase | 448 reads
 
Ask SQL Server Central



Question of the Day

Table Privileges

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

What does sp_table_privileges_ex do?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
6566 53821 SSC Guru  
2.
Jeff Moden
6177 51287 SSC Guru  
3.
Steve Jones - SSC Editor
4020 40163 SSC-Forever  
4.
Lowell
2442 17400 SSCoach  
5.
Lynn Pettis
2172 26372 One Orange Chip  
Latest forum posts