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

Rss
Headlines today   February 22, 2017

Stairway to Exploring Database Metadata Level 7: Extended Properties

In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.   Read more...
By Phil Factor 2017/02/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 265 reads

Questions About the Use of PowerShell That you were Too Shy to Ask

Let's forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did it come from? Why did it take so long to arrive? These and many other basic questions are answered in William Brewer's latest addition to the series that answers those seemingly simple questions that you were too shy to ask in public.  Read more...
By Additional Articles 2017/02/22 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 1,134 reads
Previous headlines

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 | 672 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 | 2,286 reads

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,586 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,994 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,026 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,099 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,182 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 | 79 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Estimated Costs of All Queries

One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty...  Read more...
By Grant Fritchey 2017/02/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 595 reads

How to sign a SQL Server CLR Assembly in Visual Studio 2015

It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR...  Read more...
By Jeffrey Yao 2017/02/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 364 reads
Question of the Day

The default differential

By Steve Jones 2017/02/22 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 245 reads

I run this command:


Backup-SqlDatabase -ServerInstance .\SQL2014 -Database sandbox -Incremental

What is the name of my differential backup file?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
7361 54749 SSC Guru  
2.
Jeff Moden
6714 52023 SSC Guru  
3.
Steve Jones - SSC Editor
4397 40701 SSC-Forever  
4.
Lowell
2791 17766 SSCoach  
5.
Lynn Pettis
2381 26640 One Orange Chip  
Latest forum posts