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,422 reads
Continuing with the Worst Practices Series: Steve Jones examines why encryption in the database is a bad idea.
2002-01-08
8,422 reads
Things your non-technical friends don't want to hear in the lab...
2002-01-04
3,942 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,128 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,229 reads
2001-11-16
2,503 reads
In this view, Steve thinks that certifications are invaluable (especially in this economy).
2001-11-13
3,414 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
135 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,976 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,243 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,616 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers