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

Headlines today   May 29, 2015

Big Data for SQL folks: The Technologies (Part II)

SQL Server Big Data. Is the end Near for ETL as we know is? Will RDBMs be obsolete? What is NoSQL? What is Hadoop? Big Data-the whole story.  Read more...
By Frank A. Banin 2015/05/29 (first published: 2013/11/21) | Source: | Category: business intelligence
Rating: |  Discuss |   Briefcase | 6,366 reads

A Plethora of PowerShell Pitfalls: Part 2

There are some pitfalls in PowerShell for the unwary. Many people who are learning PowerShell come across quirks that can cause frustration. Michael Sorens continues his series, warning abut four of the most common PowerShell pitfalls and explains how to avoid them.  Read more...
By Additional Articles 2015/05/29 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 639 reads
Previous headlines

Retrieving a Binary File from Your Database

In this second article I provide the means to restore a binary file to its original state.   Read more...
By Eric Notheisen 2015/05/28 | Source: | Category: clr
Rating: |  Discuss |   Briefcase | 3,030 reads

Take our SQLServerCentral Users Survey

Each year SQLServerCentral runs a survey to get some insight into what who our readers are, what they like about the site, and what can be improved. Please take a few minutes to complete this survey by June 12 and get the opportunity to win one of three $50 Amazon vouchers.  Read more...
By Press Release 2015/05/28 (first published: 2015/05/26) | Source: | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 5,211 reads

Converting and Using Text Dates as SQL Server Dates

This tip describes some T-SQL techniques for converting a mmddyyyy string to a SQL Server date, handling rows with missing date strings, and comparing converted date strings.  Read more...
By Additional Articles 2015/05/28 | Source: | Category: dates and conversion
Rating: (not yet rated)  Rate this |   Briefcase | 3,079 reads

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.   Read more...
By Gregory Larsen 2015/05/27 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,953 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2015/05/27 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 56,397 reads

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower values. They are now easier to calculate in SQL, and are useful for reporting; but are the new analytic functions faster and more efficient than the older methods? Dwain Camps demonstrates, and investigates their relative performance.   Read more...
By Additional Articles 2015/05/27 | Source: SimpleTalk | Category: percent_rank
Rating: (not yet rated)  Rate this |   Briefcase | 3,273 reads

Storing a Binary File in a Database

In this article you will see how to convert a file to a binary stream and insert it into SQL Server with SQLCLR.  Read more...
By Eric Notheisen 2015/05/26 | Source: | Category: binary conversion
Rating: |  Discuss |   Briefcase | 5,912 reads

Webinar: How to safely manage application and database changes with continuous delivery

Join Brian A. Randell, Grant Fritchey and Steve Jones in this panel discussion to hear tips, ideas and share your questions on managing application and database deployments with continuous delivery. This Free webinar will be on May 27th at 4PM BST, register while space is available.  Read more...
By Press Release 2015/05/26 (first published: 2015/05/21) | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 7,632 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Refactoring Mistakes Are Why We Write Tests

I wrote a short piece the other day trying to show how one can use tSQLt to test code. It’s...  Read more...
By Steve Jones 2015/05/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 711 reads

Book Review: Connected

I heard about Connected from a show on NPR (Yes, I listen to NPR, why do people keep saying that?)....  Read more...
By Grant Fritchey 2015/05/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 648 reads
Question of the Day

DBCC InputBuffer Permissions

By Steve Jones 2015/05/29 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Other than sysadmin, what permission set would you grant to allow a developer to view the results of DBCC INPUTBUFFER (non SQL Azure Database)?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Jacob Wilkins
560 870 SSC Eights!  
Junior Galvão - MVP
467 780 Right there with Babe  
458 1449 Ten Centuries  
Shiva N
450 1843 SSCommitted  
Jeff Moden
365 37470 SSC-Dedicated  
Latest forum posts