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.
2013-03-07
1,823 reads
Articles
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.
2013-03-07
6,289 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?
2013-03-07
2,201 reads
SQL Saturday #194 - Exeter
A day of SQL Server training in the UK on Mar 9, 2013. Sign up if you can come.
2013-03-06
1,751 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.
2013-03-06
4,197 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,
2013-03-05
3,616 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.
2013-03-05
3,607 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.
2013-03-04
2,547 reads
SQL Saturday #187 - Richmond
A free day of training in Richmond, VA. Come along and see Steve Jones, Grant Fritchey and more.
2013-03-04 (first published: 2013-02-27)
2,156 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.
2013-03-01 (first published: 2013-02-20)
489 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers