A short look at the vulnerabilities your data may be susceptible to outside of the database tables.   Read more...

The focus of this paper is on the protection of PII data stored within a database using encryption technologies.  Read more...

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...

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...

How to delete millions of rows with virtually no contention.  Read more...

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...

A day of SQL Server training in the UK on Mar 9, 2013. Sign up if you can come.  Read more...

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...

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...

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...

This tip I will explains a step-by-step method to perform the SQL Server Log Shipping migration.  Read more...

I will describe a simple method anyone can use to obtain lost password information for a SQL Server login.  Read more...

A free day of training in Richmond, VA. Come along and see Steve Jones, Grant Fritchey and more.  Read more...

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...

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...

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...

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...

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...

An introduction to Universal Product Codes with code to help you use them in your database.  Read more...