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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,805,499 DBAs, developers and SQL Server users

Rss
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: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 9,067 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 | 2,132 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: SQLServerCentral.com | Category: clr
Rating: |  Discuss |   Briefcase | 3,267 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: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 5,438 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: MSSQLTips.com | Category: dates and conversion
Rating: (not yet rated)  Rate this |   Briefcase | 3,286 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,127 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,536 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,402 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: SQLServerCentral.com | Category: binary conversion
Rating: |  Discuss |   Briefcase | 6,030 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,812 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 | 1,792 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 | 1,575 reads
Question of the Day

DBCC InputBuffer Permissions

By Steve Jones 2015/05/29 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 538 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)?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jacob Wilkins
558 870 SSC Eights!  
2.
Junior Galvão - MVP
459 780 Right there with Babe  
3.
SimonH
458 1449 Ten Centuries  
4.
Shiva N
450 1843 SSCommitted  
5.
Jeff Moden
363 37472 SSC-Dedicated  
Latest forum posts