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/28 to 2013/03/07

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: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 5,791 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: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 1,576 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,013 reads

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: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,078 reads

Hidden Tricks To SQL Server Table Cleanup

How to delete millions of rows with virtually no contention.  Read more...
By Edward Polley 2013/03/06 | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 12,529 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,501 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: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,656 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 | 2,367 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,021 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: SQLServerCentral.com | Category: recovery model
Rating: |  Discuss |   Briefcase | 3,420 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: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 1,732 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 2013/03/04 | Source: SQLServerCentral.com | Category: password cracking
Rating: |  Discuss |   Briefcase | 17,869 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,030 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 | 450 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,543 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,552 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,601 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,753 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,856 reads