Please join Jim Gray, Distinguished Engineer at Microsoft Research, for this Q&A Session. Jim, the father of Structured Query Language, has been looking at LARGE databases like Google, Hotmail, BarBar, CERN, EOS/DIS, Internet Archive, and others that are either at a Petabyte or will grow to a petabyte scale in the next year or so.
Sooner or later everyone who works with SQL Server hears that it is better to avoid dynamic SQL at all cost. Dynamic SQL will force you to give out more permissions than static SQL. This article by Robert Marda shows you some of the security issues with dynamic SQL.
One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. A database getting thousands of recompiles an hour will suffer in performance and show short term blocking that will affect the database users. This article by Randy Dyess shows you some of the ways you can avoid stored procedure recompiles.
Andy read this book recently and gave it a great review. Even though it's not a SQL book! Seriously, take a look at the review. It's a good book that is fun to read.
Steve Jones examines the possible notion that a system can achieve 0% downtime. Read on to see if he thinks it's possible.
Adept SQL Tools has released AdeptSQL Workshop, an IDE for SQL-based database schema creation and management. Includes fast drag'n'drop SQL decompiler, editor, preprocessor, SQL analyzer and difference engine, "revision history" scripts with a separate player utility for remote db deployment, integration with MS Visual SourceSafe. Pricing starts at $130,
$199 with VSS support.
Use this free stored procedure to compare two different SQL Server databases in order to discover how they differ. Sp_CompareDB can compare both table structures and the data stored in them. Also learn how the stored procedure was written.
In this article by Robert Marda, he shows you how to detect and correct deadlocks.
In the final article in the series, Chris Kempster covers some of the more advanced methods to securing your SQL Server.
myLittleAdmin For SQL Server is a web-based SQL Server Database administration tool. It is intended to handle the administration of SQL Server databases over the WWW using ASP. It allows you to fully manage your databases even when you don't want or cannot use MS Enterprise Manager.
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Team, I'm trying to figure out what will be the best recommendation to configure...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers