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

Headlines today   May 5, 2015

DDL Auditing using the Default trace

This article explains how default trace can be used for auditing purposes when combined with PowerShell scripts  Read more...
By Nagaraj Venkatesan 2015/05/05 | Source: | Category: audit
Rating: (not yet rated) |  Discuss |   Briefcase | 314 reads

Time Slots - An Essential Extension to Calendar Tables

After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. Here is Dwain's dream made reality.  Read more...
By Additional Articles 2015/05/05 | Source: SimpleTalk | Category: calendar table
Rating: (not yet rated)  Rate this |   Briefcase | 898 reads

How do you work with databases?

How do you use SQL Server, and how do you expect this to change next year? Fill in Redgate's survey by May 15 and enter a prize draw to win one of 4 $50 Amazon vouchers.  Read more...
By Press Release 2015/05/05 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 826 reads
Previous headlines

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,729 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,633 reads

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,238 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,640 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,247 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,537 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,101 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

How Many SQL Log Files Do You Keep?

Reading Time: 2 minutes Ever have this happen? You (on vacation): I’ll have another piña colada please. Yes, in the coconut....  Read more...
By WaterOx 2015/05/05 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 689 reads

A Tale of SQL Server Disk Space Trials and Tribulations

#SQLNewBlogger Details: System: 5.5GB of RAM, Windows 2008 R2, vmware, 4 cores, SQL Server 2012 Standard Edition. The database currently has the...  Read more...
By todd 32417 2015/05/05 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 690 reads
Question of the Day

Numeric Data Types

By Orlando Colamatteo 2015/05/05 | Category: data modeling
Rating: (not yet rated) |  Discuss |   Briefcase | 175 reads

How many distinct data types are represented in this list?

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