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,777,688 DBAs, developers and SQL Server users

Headlines today   January 27, 2015

Data Mining Part 23: Security

In this chapter we will talk about security recommendations for SQL Server Data Mining.  Read more...
By Daniel Calbimonte 2015/01/27 | Source: | Category: roles
Rating: |  Discuss |   Briefcase | 1,196 reads

Grant Fritchey Reviews Minion Reindex

Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.   Read more...
By Grant Fritchey 2015/01/27 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 896 reads

Finding Encrypted Data in a SQL Server Database

The easiest way to determine if there is encrypted data in a database is to get that information from whoever wrote the application. Aside from that, there are a few things you can look for which would suggest that you have encrypted data in a given database.  Read more...
By Additional Articles 2015/01/27 | Source: | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 3,475 reads
Previous headlines

Selecting from sub-queries as tables

Using sub-queries as tables only requires an alias 
By Ben Kubicek 2015/01/26 | Source: | Category: sub-queries
Rating: |  Discuss |   Briefcase | 8,558 reads

SQL Prompt Tip #7 - Begin End Highlighting

This SQL Prompt tip shows you how code highlighting makes it easier to find which items match up with each other.  Read more...
By Steve Jones 2015/01/26 | Source: | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,652 reads

Discrete and Continuous Data in SQL

Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constraints and the results of queries. Joe Celko explains.  Read more...
By Additional Articles 2015/01/26 | Source: SimpleTalk | Category: data
Rating: (not yet rated)  Rate this |   Briefcase | 5,112 reads

Removing Duplicates

How to remove identify and remove duplicate data from your tables  Read more...
By Sioban Krzywicki 2015/01/23 (first published: 2013/10/08) | Source: | Category: duplicate data
Rating: |  Discuss |   Briefcase | 26,360 reads

Going to Extremes to Release Bug Fixes and New Features

Extreme Programming (XP) is no general panacea; but for the right team, and for a product that needs to release bug fixes and new features as fast as possible, its benefits are obvious. Working on one of Red Gate's most popular tools, SQL Prompt, Aaron Law and David Priddle use XP. But is their adherence to XP a personal preference or does it bring real benefits?   Read more...
By Additional Articles 2015/01/23 | Source: SimpleTalk | Category: extreme programming
Rating: (not yet rated)  Rate this |   Briefcase | 6,197 reads

Webinar: Oracle Exadata & In-Memory Real-World Performance

On January 28th 3PM GMT, Randolf Geist will present a free, one-hour webinar analyzing different database query profiles based on a real-world customer case. He'll also look at how these different profiles influence the efficiency of Exadata's features and the new Oracle In-Memory column store option. Register now.   Read more...
By Press Release 2015/01/23 | Source: Red-Gate | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 6,013 reads

Tracking Database DDL Changes with SQLVer

Presents an open-source T-SQL based version tracking system for MSSQL  Read more...
By David Rueter 2015/01/22 | Source: | Category: version tracking
Rating: |  Discuss |   Briefcase | 4,738 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Exam Prep 70-463: Data Flow Destination Adapters

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...  Read more...
By Colleen M. Morrow 2015/01/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,107 reads
Question of the Day


By Steve Jones 2015/01/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 999 reads

I am looking to PIVOT some sales data for a series of customers. I'd like to get the customer sales by year, by type. My data looks like this:

Customer Salesyear... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
630 833 SSC Eights!  
514 618 SSChasing Mays  
Jeff Moden
454 36311 SSC-Dedicated  
RK Mandava
372 2327 SSCrazy  
361 1975 SSCommitted  
Latest forum posts