This book from Microsoft Press has a lot of good information that will help you do capacity planning and performance tuning. Is it worth buying though? Andy just finishing reading it and writing the review, see what he thinks!
Brief introduction to Apache v2.0 with links to performance/setup and installation and other information.
Building and executing dynamic sql in a stored procedure - is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring!
SQL Server MVP Mike Hotek and industry expert Kimberly Tripp launch the latest SQL Server educational offering from PASS - one day seminars beginning this June in Chicago and August in Las Vegas. Join Mike and Kim as they demonstrate their expertise on SQL Server replication and tuning high performance SQL Server 2000 databases. Space is limited. Seminar details and convenient, secure online registration is available at http://www.sqlpass.org/events/seminars.
RedGate software has announced their newest product, SQL Server Compare, a new tool for comparing and synchronizing SQL Servers. Read the press release!
Jon Winer further discusses some comparisons using ADO versus the XML DOM to parse shaped recordsets. This article is a supplement to his previous article titled: Converting Shaped Recordsets into XML.
As I work with a particular topic or problem, I often research on the Internet
different opinions, white papers, etc. Here is a list of resources that are located both
on SQL Server Central and other sites that I have found useful.
Want to get more productive? Fit more work into normal working hours? Steve Jones found a relatively inexpensive hardware upgrade to help you.
Whether you are a developer, IT professional, or a database administrator, whether you are just developing and testing or are ready to deploy in production, there is a SQL Server 2000 edition for you and your organization. This paper will inform you about the differences among the various editions of SQL Server 2000, and how you can save time and money by choosing the right one for the job.
A list of DTS resources, including bugs, issues, books, and some good programming resources.
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Fildena 100 mg is an effective medication for treating erectile dysfunction (ED), providing a...
Introduction to Generative AI Services Welcome to the cutting-edge world of Generative AI Services,...
Hi I am trying to assign the value of the variable using the output...
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers