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

Welcome to

A Microsoft SQL Server community of 1,874,206 DBAs, developers and SQL Server users

Headlines today   December 5, 2016

Maintenance Routines for AlwaysOn

How to determine what replica(s) to perform maintenance routines  Read more...
By Ginger Keys 2016/12/05 | Source: | Category: always on
Rating: |  Discuss |   Briefcase | 602 reads

Representing Hierarchical Data for Mere Mortals

Why is it that we use XML, but with so little enthusiasm when it does so much, and is so feature-rich? Phil Factor argues that there are better ways of doing it, more complete than JSON, but easier to read than XML. To try to convince you, he gives a set of flying demos, using PowerShell and his PSYaml module, to illustrate how YAML can let you work faster, and more accurately.  Read more...
By Additional Articles 2016/12/05 | Source: SimpleTalk | Category: hierarchical data
Rating: (not yet rated)  Rate this |   Briefcase | 1,583 reads

Use SSMS and Visual Studio?

Redgate is running a short survey to better understand the tools you're using for database development. There are eleven questions, and three $50 Amazon gift cards up for grabs as a thank you for responding.  Read more...
By 2016/12/05 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 1,483 reads
Previous headlines

Hadoop For SQL Folks: Architecture, MapReduce and Powering IoT

As the de-facto big data processing and analytics engine, the Hadoop ecosystem is also leading the way in powering Internet of Things (IOT)  Read more...
By Frank A. Banin 2016/12/02 (first published: 2015/08/06) | Source: | Category: hadoop
Rating: |  Discuss |   Briefcase | 9,329 reads

4 Keys to a Clean Angular Implementation

Can there be true separation of concerns with MVC? Not entirely, especially when Angular's templates allow you to so much flexibility; but there is a great deal to be gained from following guidelines to ensure that all business logic is performed in the code-behind as directed by the controller or its delegate, and that all operations on the model are done in the controller: Michael Sorens explains the four essential guidelines for an easily-maintained system.  Read more...
By Additional Articles 2016/12/02 | Source: SimpleTalk | Category: angular
Rating: (not yet rated)  Rate this |   Briefcase | 3,564 reads

Have you adopted database DevOps?

Redgate invites you to participate in a survey to uncover rates of adoption of DevOps practices among Microsoft SQL Server database users. The survey will take between 5 and 10 minutes to complete. All respondents who provide a valid email address will be sent a copy of the research report when available, as well as being entered into a prize draw to win a $250 Amazon gift card.  Read more...
By 2016/12/02 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,375 reads

How to download a file from internet using SSIS

In this example, we will show how to download a file from internet using SSIS.  Read more...
By Daniel Calbimonte 2016/12/01 | Source: | Category: ssis
Rating: |  Discuss |   Briefcase | 1,540 reads

A brief history of version control

The fledgling computer industry did not invent version control. It merely adopted practices that were already well established in other industries. In part one of three, Wibke Carstensen takes a look at where it all started.  Read more...
By 2016/12/01 | Source: Redgate | Category: version control
Rating: (not yet rated)  Rate this |   Briefcase | 1,899 reads

Script to find oldest open SQL Server transaction

In this post, Eli Leiba shares a script that can be used to find the oldest open transaction and the statement that was issued.  Read more...
By Additional Articles 2016/12/01 | Source: | Category: script
Rating: (not yet rated)  Rate this |   Briefcase | 2,157 reads

SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed

EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.  Read more...
By Kenneth Igiri 2016/11/30 | Source: | Category: space management
Rating: |  Discuss |   Briefcase | 948 reads
Redgate DevOps Survey

From the SQLServerCentral Blogs

Easy to read CHECKDB

If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC...  Read more...
By Kenneth Fisher 2016/12/05 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,074 reads
Question of the Day

Getting Modules

By Steve Jones 2016/12/05 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 462 reads

If I want to check the list of possible PowerShell Modules on my system, what should I run? 

Top Members (last 30 days)
# Name Score Level
30 days All-time
Eirikur Eiriksson
350 6552 SSCertifiable  
Jeff Moden
234 42051 SSC-Forever  
Ed Wagner
194 9935 SSCrazy Eights  
Luis Cazares
148 8205 SSCrazy Eights  
147 45619 SSC-Forever  
Latest forum posts