Worst Practices - Encrypting Data
Continuing with the Worst Practices Series: Steve Jones examines why encryption in the database is a bad idea.
2002-01-08
8,436 reads
Continuing with the Worst Practices Series: Steve Jones examines why encryption in the database is a bad idea.
2002-01-08
8,436 reads
Things your non-technical friends don't want to hear in the lab...
2002-01-04
3,953 reads
If you use identity values, chances are that at some point you will need to find more information about the next value or reset the seed. This article looks at how you can accomplish this.
2001-12-31
7,153 reads
One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?
2001-12-04
6,238 reads
2001-11-16
2,508 reads
In this view, Steve thinks that certifications are invaluable (especially in this economy).
2001-11-13
3,424 reads
A new series on SQL Server Central - Two of our regular columnists take opposing looks at certification. In our first of the series, Steve Jones takes on Andy Warren in a certification debate.
2001-11-12
142 reads
A brief description of some well known, and not so well known programming languages. Have you worked with any of these?
2001-11-09
2,987 reads
Continuing with Andy Warren's series on Worst Practices for a DBA, Steve Jones joins in this week with his worst practice.
2001-11-06
7,248 reads
Steve Jones presents his case for why certifications should be required. Read this and the counter point article by Andy Warren to hear the other side of this argument - then post your comments
2001-11-04
5,628 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers