This white paper on the Microsoft TechNet site provides a detailed explanation of the migration process and explores the improved database functionality of SQL Server.
Tag: sql server
Decrypt encrypted stored procedures
(Joseph Gama & ShoeBoy) This code presents a stored procedure called sp_decrypt_sp that is used to decrypt T-SQL stored procedure compiled with the ENCRYPTION option. (R)
A Comparison of SQL Server 7.0 with SQL Server 2000
by Sergey Vartanyan – Are you still using SQL Server 7.0 and considering upgrading to SQL Server 2000? If so, this article may help.
WhiteHat Arsenal Tool Set Aims to Knock Off Web Site Black Hats
By Michael Ross and Jeffrey H. Rubin – Only a handful of tools can assist with QoS (Quality of Service) testing before applications go live. Enter WhiteHat Security’s WhiteHat Arsenal 2.0, a collection of basic tools that help security professionals test Web applications for common security vulnerab
Query to show duplicate customers only once
By Jorge Cano – I would like to know how I can write a query that would only show my customers once, even though they are in the database more than that. Check out the solution.
Buffer Overrun in Microsoft SQL Server 2000 Utilities
Cesar Cerrudo discovered two vulnerabilities in Microsoft SQL Server 2000 and Microsoft SQL Server Desktop Engine (MSDE) 2000. The vulnerabilities are related to a buffer overrun and SQL injection. Microsoft released Security Bulletin MS02-038 (Unchecked Buffer in SQL Server 2000 Utilities Could All
CERT Warns of Multiple SQL Flaws
By Amy Newman – A CERT advisory issued Monday evening warns of several vulnerabilities in Microsoft SQL Server.<br><Br>Microsoft SQL Server 7.0, Microsoft SQL Server 2000, and Microsoft SQL Server Desktop Engine 2000 are affected.
VB.NET & SQL Server 2000 – Building an effective data layer
This book will teach the experienced VB developer, with a working knowledge of Visual Basic .NET, how to integrate SQL Server 2000 with VB .NET applications using ADO.NET.
How to search all columns of all tables in a database for a keyword?
By Vyas Kondreddi – This article provides you with a stored procedure that searches all columns of all the tables, owned by all users, in the current database, for a specific search string.
SQL Server crisis advice
By Ellen O’Brien – Security specialist David Litchfield answers questions for SearchDatabase about what he calls the most severe security threat to the SQL Server in its history. Litchfield, Next Generation Security Software co-founder and a frequent guest speaker at Black Hat conferences, stresses