Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,799,956 DBAs, developers and SQL Server users

Headlines today   May 4, 2015

How to FTP a Dynamically Named Flat File

Learn how you can dynamically name a file in SSIS and then send it using the FTP task.  Read more...
Rating: |  Discuss |   Briefcase | 3,583 reads

MongoDB vs. Azure DocumentDB

There’s a new kid on the block in the NoSQL world – Azure DocumentDB. Released in preview back in August 2014 and going Generally Available this month, Azure DocumentDB is Microsoft’s initial foray into the increasingly competitive space of non-relational database management systems. Of course there is no better competitor in this space to measure up against than MongoDB. How close does DocumentDB stack up to MongoDB? Are they even close?  Read more...
By Additional Articles 2015/05/04 | Source: Just Azure | Category: nosql
Rating: (not yet rated)  Rate this |   Briefcase | 4,490 reads
Previous headlines

The new Analytic functions in SQL Server 2012

SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.  Read more...
By Wayne Sheffield 2015/05/01 (first published: 2012/01/19) | Source: | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 25,172 reads

CONCAT and STUFF Functions in SQL Server 2012

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.  Read more...
By Additional Articles 2015/05/01 | Source: Database Journal | Category: concat
Rating: (not yet rated)  Rate this |   Briefcase | 5,575 reads

Automated database deployment workshops

Redgate is offering a 1-day public workshop for anyone who’s interested in automated deployments for SQL Server databases. In the hands-on exercises, you’ll learn how to deploy with PowerShell and Octopus Deploy, work with NuGet packages, handle unexpected changes in your production database (database drift), test your changes with dry run releases, add review and rollback steps, check your deployments have worked, and how to fix things if your deployment fails. Find a workshop near you.  Read more...
By Press Release 2015/05/01 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,209 reads

SQLServerCentral Runs sp_Blitz - The Future

After examining the SQLServerCentral servers using the sp_Blitz™ script, Steve Jones now looks at how we will use the script moving forward.  Read more...
By Steve Jones 2015/04/30 | Source: | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 5,514 reads

Microservices in Promise and Practice

Are microservices the cure for the ague of monolithic applications, or do they bring their own problems with them that monolithic architectures have circumvented? Are they capable of delivering applications that are easier to maintain and develop? How can they avoid the failings of service-oriented architectures? Once more, Robert Sheldon gets to the heart of the technical issues.  Read more...
By Additional Articles 2015/04/30 | Source: SimpleTalk | Category: microservices
Rating: (not yet rated)  Rate this |   Briefcase | 5,058 reads

Stairway To Columnstore Indexes Level 2: Columnstore Storage

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.  Read more...
By Hugo Kornelis 2015/04/29 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,567 reads

Automated database deployment workshop: London, UK

Join Redgate on May 20th for a 1-day public workshop in London. This event is for anyone who’s interested in automated deployments for SQL Server databases. You'll learn how to: Deploy databases using Redgate's DLM tools; Assess the different requirements of production and non-production deployments, and; Handle database administration tasks, such as backups and security, for automated deployment. Register while space is available.  Read more...
By Press Release 2015/04/29 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,295 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2015/04/29 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 60,021 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Make Sure to Schedule Your SQL Server Replication Jobs

You setup SQL Server Replication and everything looks fine. Rows are flowing between the servers and you think you’re done. Right? Wrong.. At...  Read more...
By Matan_Yungman 2015/05/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,833 reads

Ruminations on Writing Great T-SQL

Today we’re going to try to extend some advice that I once heard from SQL MVP Jeff Moden, which I...  Read more...
By Dwain Camps 2015/05/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,786 reads
Question of the Day

Server Logins

By Steve Jones 2015/05/04 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 687 reads

The Login object in SMO, can be accessed from PowerShell. It contains a property that can get or set the authentication message. Which property is used? 

Top Members (last 30 days)
# Name Score Level
30 days All-time
Eirikur Eiriksson
416 3624 Hall of Fame  
Grant Fritchey
288 15137 SSCoach  
287 959 SSC Eights!  
273 1264 Ten Centuries  
Jeff Moden
255 37148 SSC-Dedicated  
Latest forum posts