Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/02/22 to 2013/03/01

New Free Event for Database Professionals in Virginia

SQL Server developers and database administrators have the chance to attend a free half-day event, in Richmond, VA - hosted by SQL Server experts Steve Jones and Grant Fritchey.   Read more...
By Press Release 2013/03/01 (first published: 2013/02/20) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 452 reads

SQL Server Statistics Questions We Were Too Shy to Ask

If you need to optimise SQL Server performance, it pays to understand SQL Server Statistics. Grant Fritchey answers some frequently-asked questions about SQL Server Statistics: the ones we somehow feel silly asking in public, and think twice about doing so.  Read more...
By Additional Articles 2013/03/01 | Source: SimpleTalk | Category: statistics
Rating:  Rate this |   Briefcase | 3,610 reads

SQL Server Central Webinar Series #22 – What counts for a DBA (Wednesday, March 13 2013 5:00pm - 6:00pm GMT)

In this session, Louis Davidson, Microsoft MVP, will discuss how being observant of the environment you work in can help you make sure that you are aware of the health of your database systems, as well as your career.  Read more...
By Press Release 2013/03/12 (first published: 2013/02/22) | Source: Red-Gate | Category: webinar
Rating:  Rate this |   Briefcase | 5,071 reads

Using a Variable for an IN Predicate

How to use a passed string variable for an IN type predicate in your queries as a way to more efficiently handle an array of strings.  Read more...
By Todd Fifield 2013/03/01 (first published: 2011/06/21) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 25,618 reads

SSIS Basics: Using the Conditional Split

The Conditional Split can route data rows to different outputs depending on whatever criteria of the data that you wish. It works rather like the SWITCH block in a procedural language. Annette shows how to add a conditional split to your data flow.  Read more...
By Additional Articles 2013/02/28 | Source: SimpleTalk | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 2,673 reads

15 Quick Short Interview Questions Useful When Hiring SQL Developers

Here is a useful exam that you can administer in either 10 or 15 minutes, either oral or written, when you interview for hiring permanent or contract workers for jobs in SQL Server development or support. (This is not a test for SQL Data Base Administrators.)   Read more...
By Thomas Kovarik 2013/02/28 | Source: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 7,866 reads

Universal Product Codes: a Database Primer

An introduction to Universal Product Codes with code to help you use them in your database.  Read more...
By Hakim Ali 2013/02/28 | Source: SQLServerCentral.com | Category: retail
Rating: |  Discuss |   Briefcase | 4,881 reads

Standardize SQL Server Installations with Configuration Files

If you have a requirement to install multiple SQL Server instances with the same settings, you most likely want to do it without following the numerous manual installation steps. The below tip will guide you through how to install a SQL Server instance with less effort.  Read more...
By Additional Articles 2013/02/27 | Source: MSSQLTips.com | Category: installation
Rating: (not yet rated)  Rate this |   Briefcase | 1,939 reads

Shred XML column using SSIS

This article describes a way using SSIS to shred a XML column from a source table into its respective columns in the destination table.  Read more...
Rating: |  Discuss |   Briefcase | 4,342 reads

SQL Saturday #187 - Richmond

A free day of training in Richmond, VA. Come along and see Steve Jones, Grant Fritchey and more.  Read more...
By Press Release 2013/03/04 (first published: 2013/02/27) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,052 reads

SQL Bits XI

The popular UK conference heads to Nottingham from May 2-4, 2013. Both Grant Fritchey and Steve Jones will be speaking, along with lots of talented SQL Server professionals. Register today.  Read more...
By Press Release 2013/03/11 (first published: 2013/02/06) | Source: SQLServerCentral.com | Category: sql bits
Rating:  Rate this |   Briefcase | 4,211 reads

SQL Saturday #192 - Tampa

Come and join SQL Saturday Tampa in their new venue (HCC) now that they've outgrown K-Force!  Read more...
By Press Release 2013/02/26 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 217 reads

Full Text Searches on Documents in FileTables

SQL Server's FileTable technology is an intriguing way of accomodating file-based text data in a database, and allowing for complex searches. As with most technologies, the best way of learning them is to try it out and experiment. Feodor shows how to set it up, add some sample data and set up full-text search.  Read more...
By Additional Articles 2013/02/26 | Source: SimpleTalk | Category: text
Rating:  Rate this |   Briefcase | 1,849 reads

Stairway to PowerPivot and DAX - Level 3: The DAX DISTINCT() Function and Basic Distinct Counts

Bill Pearson, Business Intelligence architect and author, exposes the DAX DISTINCT() function, and then provides some hands-on exposure to its use in generating distinct counts. Moreover, he further explores working with measures in the PivotTable in this, the third Level of our new Stairway to PowerPivot and DAX series.  Read more...
By Bill Pearson 2013/10/09 (first published: 2013/02/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,516 reads

Backing Up SQL Server Databases Participating In Availability Groups

So I am using this new technology called Availability Groups that was introduced in SQL Server 2012. I have heard I can offload my backups to a secondary replica, but I am not sure how that works or how to configure those backups. Are there any limitations? Check out this tip to learn more.  Read more...
By Additional Articles 2013/02/25 | Source: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,318 reads

Data Profiling with T-SQL

Need to understand new data? This article explains why - and how you can profile it efficiently  Read more...
By Adam Aspin 2013/02/25 | Source: SQLServerCentral.com | Category: data profiling
Rating: |  Discuss |   Briefcase | 1,802 reads

NoSQL for the MSSQL Soul

The buzz around NoSQL solutions has reached stratospheric heights. This buzz has led many Microsoft SQL Server development shops to start looking at how and where a NoSQL solution can fit into their business.  Read more...
By Additional Articles 2013/02/22 | Source: developer.com | Category: nosql
Rating:  Rate this |   Briefcase | 4,758 reads

PowerShell Basics

Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.  Read more...
By Shawn Melton 2013/02/22 (first published: 2011/01/24) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 23,605 reads