SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2012/12/03 to 2012/12/10

Disaster Recovery Planning for Data: The Cribsheet

Planning for disaster recovery and business continuity aren't amongst the most exciting IT activities. They are, however, essential and relevant to any Database Administrator who is responsible for the safety and integrity of the companies' data, since data is a key part of business continuity.  Read more...
By Additional Articles 2012/12/10 | Source: SimpleTalk | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 2,328 reads

Disaster Recovery Week

This week we highlight the practice of being prepared for disasters at SQLServerCentral.  Read more...
By Steve Jones 2012/12/14 (first published: 2012/12/10) | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 5,531 reads

What’s in YOUR Recovery Plan?

Author Craig Outcalt gives advice on preparing for the worst with a look at what you should consider putting in your disaster recovery plan and why.  Read more...
By Craig Outcalt 2012/12/10 (first published: 2011/09/26) | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 5,106 reads

Data Distribution with SQL Server Replication

This paper provides a foundation for understanding data replication as well as a discussion of the criteria for selecting an appropriate replication technology.   Read more...
By Ron Johnson 2012/12/10 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 1,972 reads

Fixing Gatekeeper Row Cardinality Estimate Issues

The Query Optimiser needs a good estimate of the number of rows likely to be returned by each physical operator in order to select the best query plan from the most likely alternatives. Sometimes these estimates can go so wildly wrong as to result in a very slow query. Joe Sack shows how it can happen with SQL Queries on a data warehouse with a star schema.  Read more...
By Additional Articles 2012/12/10 | Source: SimpleTalk | Category: cardinality estimates
Rating:  Rate this |   Briefcase | 1,158 reads

Stairway to DAX and Power BI - Level 2: The DAX COUNTROWS() and FILTER() Functions

Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series.  Read more...
By Bill Pearson 2013/09/11 (first published: 2012/12/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,711 reads

Database Deployment: The Bits - Copying Data Out

Occasionally, when deploying a database, you need to copy data out to file from all the tables in a database. Phil Factor shows how to do it, and illustrates its use by copying an entire database from one server to another.  Read more...
By Additional Articles 2012/12/07 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,672 reads

Red Gate Wins 8 Awards and You Can Get a Prize

Red Gate won 8 awards in the recent SQL Server Pro annual product reviews. As a celebration, we're giving away a few prizes.  Read more...
By Press Release 2012/12/06 | Source: SQLServerCentral.com | Category: contests
Rating:  Rate this |   Briefcase | 2,675 reads


Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.  Read more...
By Eric Wahner 2014/11/28 (first published: 2012/12/06) | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 16,610 reads

SQL Server 2012 Integration Services - Implementing Package Security using Access Control

SQL Server 2012 Integration Services offers a wide range of powerful features that allow you to streamline and automate tasks involving data extraction, transformation, and loading. However, incorporating these features into your existing business intelligence framework frequently necessitates additional security measures ensuring that data which is being processed remains protected from unauthorized access.  Read more...
By Additional Articles 2012/12/06 | Source: SimpleTalk | Category: integration services (ssis)
Rating:  Rate this |   Briefcase | 2,091 reads

Steps to add Log Shipping monitor into an existing SQL Server

I have a requirement to add the Log Shipping Monitor for an existing installation. I have heard you can only complete this by rebuilding the Log Shipping infrastructure. Is that true? Are there any other options? In this tip I will explain how we can add the Log Shipping monitor to a SQL Server 2005, 2008, 2008 R2 or 2012 environment without rebuilding the Log Shipping installation.  Read more...
By Additional Articles 2012/12/05 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 2,542 reads

Stairway to SQL Dialects Level 3: MySQL

As part of the LAMP stack, MySQL is incredibly important for providing a reliable and platform-agnostic database platform for web development. This level looks at the syntax of MySQL and how to best port SQL code to a MySQL environment.  Read more...
By Joe Celko 2012/12/05 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,040 reads

Free eBook: SQL Server Execution Plans, Second Edition

Get a free ebook from Red Gate Software and SQLServerCentral from MVP Grant Fritchey. Learn how to read and interpret execution plans.  Read more...
By Press Release 2012/12/04 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated)  Rate this |   Briefcase | 7,220 reads

Using SSIS to export data from a 64 bit server to Excel 2007

Instructions on how to set up the connection string and SSIS package to allow a 64 bit server to export to a 32 bit version of Excel  Read more...
Rating: |  Discuss |   Briefcase | 5,971 reads

Report Building 3.0: Adding Maps to Your Reports

With Report Builder and SSMS, there isn't much you can't do in the way of the common reports and visualisations. One of the more interesting visualisations uses maps, and that, combined with layers, makes for an impressive way of representing data.  Read more...
By Additional Articles 2012/12/04 | Source: SimpleTalk | Category: report builder
Rating:  Rate this |   Briefcase | 3,213 reads

How to Identify and Backup the Latest SQL Server Database in a Series

I have to support a third party application that periodically creates a new database on the fly. This obviously causes issues with our backup mechanisms. The databases have a particular pattern for naming, so I can identify the set of databases, however, I need to make sure I'm always backing up the newest one. Read this tip to ensure you are backing up your latest database in a series.  Read more...
By Additional Articles 2012/12/03 | Source: MSSQLTips.com | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 2,001 reads

SQL Saturday #172 - Washington, D.C.

A free day of training in the US nation's capital. Come join in if you are nearby.  Read more...
By Press Release 2012/12/03 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,444 reads

Tip: Resetting Identity Fields

How to reset an identity field to the next contiguous value, after deletions.  Read more...
By Banyardi Schmardi 2012/12/03 | Source: SQLServerCentral.com | Category: dbcc checkident
Rating: |  Discuss |   Briefcase | 8,442 reads