Defend Your Code with Top Ten Security Tips Every Developer Must Know
Microsoft tells us why it's so important to defend your code against malicious attacks.
Case Study: Importing New Data Without Emptying Existing Tables
The challenge for Robert Marda was to devise a way to keep the data available at all times while importing the new data, detect if a full or daily update was received and run appropriate data pumps, put in sufficient fail safes to ensure bad data would not get imported, and to make the process automatic including notification to pagers upon failure. Robert shows you how he did it here.
Default Values and Named Parameters for Stored Procs
Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer.
The Best of SQLServerCentral.com 2002
Steve discusses a potential new project we have in the works. We'd appreciate as many comments and votes on this one as possible.
How to globally search and replace data in SQL Server databases?
This article provides you with a simple stored procedure, that can search all the columns of all the tables in the current database, and replace a given search string with another string.
Beware of Mixing Collations: Converting Collations
With SQL Server 2000 you are able to create databases or columns with a different collating setting than the server. This article will explain a couple of methods Greg has used to successfully change collation settings.
How to pass a list/array to an SQL Server stored procedure?
Unfortunately, there is no built-in support for arrays in SQL Server's T-SQL. This article provides 5 different techniques to simulate arrays in T-SQL, with working examples. It also provides you with links to additional information and books.
Freeware Extended Sproc to Read and Write to a Text File
This free extended stored procedure can read and write to a stored text file. Perfect for writing error logs!
Backup and Restore Back to Basics with SQL LiteSpeed
This article analyzes the various options available for your backup and recovery process with SQL Server 2000 as well as an enhancement to your SQL Server backup and recovery process using a highly efficient backup and restore utility that provides significant time and disk space savings called SQL LiteSpeed.
forceSQL - Free SQL Password Auditing Tool
forceSQL v2.0 is a much improved version of our SQL Password command-line tool. It now incorporates Brute Force in addition to Dictionary attacks. It works significantly faster because it now bypassess the SQL/ODBC API and directly goes to the network.
A free download and a much more detailed description is available at http://www.nii.co.in/tools.html
Blogs
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
CHOOSE’ing a Beer: #SQLNewBlogger
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Don’t Treat Your Data Catalog Like a Data Museum
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Forums
The Inefficiencies of Kubernetes
Comments posted to this topic are about the item The Inefficiencies of Kubernetes
The Backup Space Needed
Comments posted to this topic are about the item The Backup Space Needed
Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions
Comments posted to this topic are about the item Implementing Fuzzy Search in SQL...
Question of the Day
The Backup Space Needed
How do I calculate the amount of space needed for I/O buffers during a backup operation?
See possible answers