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.
I am very excited and lucky to be speaking once again at SQLBits along...
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Monitoring for Problems The encryption of your existing data occurs as a background process...
Perhaps the biggest drawback of this type of formation is that two strikers will...
In Goodell's announcement on domestic violence earlier in the week: A few of the...
what are the best books to become a SQL developer?
Ask SSC