Interview with David Gugick, SQL Server Performance Expert
David Gugick, SQL Server performance expert and software developer, provides over 100 tips on how to boost SQL Server performance.
2003-01-17
88 reads
Additional Articles
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.
2003-01-10
243 reads
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.
2002-12-31
1,269 reads
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.
2002-12-27
82 reads
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
2002-12-23
48 reads
Best SoftTool Announces SQLSourceSafe 2.0
Best SoftTool, Inc. today announces that its flagship product SQLSourceSafe 2.0 is available for download and purchase. SQLSourceSafe is the integrated solution that Best SoftTool provides to meet the mounting market demand for a solid version control system for SQL Server database development. SQLSourceSafe integrates Microsoft Visual SourceSafe® and Microsoft SQL Server® together, offers robust and advanced version control functions to database scripts in SQL Server.
2002-11-18
59 reads
SQL Server Product Support Life Cycle
Microsoft has formally clarified the support life cycles for it's products. See where your products fall in and be sure to plan for upgrades.
2002-10-30
3,333 reads
Freeware SQLExecMS Updated
Laplas Soft has updated its ever popular freeware SQLExecMS. SQLExecMS makes a DBAs and developers life so much easier by building in a number of common untilites. You can download it free if you're a SQLServerCentral.com member!
2002-10-04
162 reads
Migrating from Oracle to SQL Server
Are you migrating your database and applications from Oracle to SQL Server and having trouble converting your code from PL/SQL to T-SQL? Then this article might help, though it doesn't cover all aspects. It provides you with answers to most commonly asked migration relasted questions. You will also find links to additional resources and books.
2002-10-02
431 reads
Get the Latest SQL Server News Across the Web
Eurgeeka is a central place to search for the latest in SQL Server news, articles and press releases. If you're a SQL Server solution provider or website, you can add your news for free! New information daily! Eurgeeka puts the pride back in the word geek.
2002-09-25
3,466 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers