SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/02/20 to 2013/02/27

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 | 2,453 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 | 5,060 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,142 reads


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: sqlbits
Rating:  Rate this |   Briefcase | 4,601 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 | 220 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 | 2,134 reads

Stairway to DAX and Power BI - 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 | 8,754 reads

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 | 456 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: always on
Rating: (not yet rated)  Rate this |   Briefcase | 2,115 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 | 2,900 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: Redgate | Category: webinar
Rating:  Rate this |   Briefcase | 5,195 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 | 5,135 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 | 24,483 reads

Resource Governor in SQL Server 2012

SQL Server 2012 delivers enhancements to the Resource Governor that reflect a growing need for centrally managed database services to provide multitenancy to customers who require isolated workloads. This document describes the enhancements and why they were added. It includes a self-contained walk through that you can try in order to gain familiarity with the new features.  Read more...
By Additional Articles 2013/02/21 | Source: TechNet Blogs | Category: resource governor
Rating:  Rate this |   Briefcase | 2,776 reads

Filtered Indexes - Simple Partitioning without Enterprise Edition?

This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition  Read more...
By Nigel Maneffa 2013/02/21 | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 6,183 reads

SQL Server Analysis Services-Lead, Lag, OpeningPeriod, ClosingPeriod Time Related Functions

Working with SSAS time related accounting functions can be tricky. SQL Server 2012 now offers Lag and Lead functions. Are these functions available in SSAS? What other related functions are available?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,976 reads

Tablix Tutorial – Level 4 in the Stairway to Reporting Services

This article shows how to group information, adjust for dynamic column and row groups, and generally use the tablix in Reporting Services.  Read more...
By Jessica M. Moss 2013/02/20 (first published: 2011/04/13) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 31,013 reads