Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >> Headlines from 2013/03/02 to 2013/03/09

Help Guide the Future of SQL Compare

How changes are applied to databases differs from person to person and from organization to organization. Here at Red Gate we’re writing the next chapter for SQL Compare and we need your feedback to validate some of our ideas. To help us in this endeavour, and to enter a prize draw for one of five $50 Amazon vouchers, please complete the following survey.  Read more...
By Press Release 2013/03/13 (first published: 2013/03/06) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,318 reads

Brent Ozar's Six Scary SQL Surprises

In lesson 3 of the Top 5 Hard-earned Lessons of a DBA series, Brent Ozar exposes six common but scary surprises that can lurk behind the façade of SSMS. Read it now, and learn hard lessons the easy way.  Read more...
By Additional Articles 2013/03/08 | Source: Redgate | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 6,742 reads

Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions

The MERGE statement is powerful and multifunctional, yet it can be hard to master. SOmetimes the MERGE statement that just doesn't do what it's needed to do, like process a Type 2 slowly-changing dimension. Check out this tip to learn more.  Read more...
By Additional Articles 2013/03/08 | Source: | Category: merge
Rating:  Rate this |   Briefcase | 3,570 reads

Deleting large number of rows from a table in a VLDB

For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.  Read more...
By Nakul Vachhrajani 2013/03/08 (first published: 2011/03/24) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 23,127 reads

Securing SQL Server: Vulnerabilities You Might Not Have Considered

A short look at the vulnerabilities your data may be susceptible to outside of the database tables.   Read more...
By Ashvin Kamaraju 2013/03/07 | Source: | Category: encryption
Rating: |  Discuss |   Briefcase | 5,821 reads

Data Insecurity: A Perspective on Data Encryption

The focus of this paper is on the protection of PII data stored within a database using encryption technologies.  Read more...
By Ron Johnson 2013/03/07 | Source: | Category: encryption
Rating: |  Discuss |   Briefcase | 1,616 reads

A SQL-Based Universal Currency Formatter

SQL Server isn't usually the best place to format dates or currency as strings. It can be a complex task to conform correctly with national and cultural conventions. Just occasionally, though, you need to do it. This is easy in SQL Server 2012, but if you aren't using that, what do you do?  Read more...
By Additional Articles 2013/03/07 | Source: SimpleTalk | Category: currency
Rating:  Rate this |   Briefcase | 2,174 reads

Hidden Tricks To SQL Server Table Cleanup

How to delete millions of rows with virtually no contention.  Read more...
By Edward Polley 2015/09/04 (first published: 2013/03/06) | Source: | Category: delete
Rating: |  Discuss |   Briefcase | 22,971 reads

Using Temp Tables in SSIS

emporary tables are created in the Temporary tables are created in the TempDB database, which persists for a particular session. The objective is to maintain that session, until the temp table information is used and dump the data into a physical table.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,822 reads

SQL Saturday #194 - Exeter

A day of SQL Server training in the UK on Mar 9, 2013. Sign up if you can come.  Read more...
By Press Release 2013/03/06 | Source: | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,738 reads

An Incremental Database Development and Deployment Framework

Often, an existing database application must evolve rapidly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues.  Read more...
By Additional Articles 2013/03/05 | Source: SimpleTalk | Category: deployment
Rating: (not yet rated)  Rate this |   Briefcase | 3,000 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,164 reads

Working with SQL Server Recovery Models

The recovery models of SQL Server define how different backup and restore tasks will be performed on your database. When choosing a recovery model,   Read more...
By Prett Sons 2013/03/05 | Source: | Category: recovery model
Rating: |  Discuss |   Briefcase | 3,544 reads

How to Recover a SQL Server Login Password

I will describe a simple method anyone can use to obtain lost password information for a SQL Server login.  Read more...
By Geoff Albin 2015/04/24 (first published: 2013/03/04) | Source: | Category: password cracking
Rating: |  Discuss |   Briefcase | 31,179 reads

How to move a SQL Server Log Shipped Secondary Database to Different SQL Server

This tip I will explains a step-by-step method to perform the SQL Server Log Shipping migration.  Read more...
By Additional Articles 2013/03/04 | Source: | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 2,348 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: | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,129 reads