This webcast is scheduled for Tuesday, January 15, 2002 at 10:00 AM Pacific time.During this session, we will show a practical approach to analyze performance tuning problems that involve Microsoft SQL Server lock monitoring data. We will briefly discuss sp_who2, sysprocesses, and syslocks.
2001-12-28
1,218 reads
Should you use this book to prepare for the 70-100 exam? Read the review and find out!
2001-12-26
3,775 reads
The major part of the article, however, is dedicated to a topic that often confuses people and leads to some of the strongest disagreements among IT professionals and developers: the benefits and drawbacks of enforcing security in the middle (or business) tier versus the data tier.
2001-12-25
1,855 reads
Happy Holidays database administrators! As a parting present before you go home for your year-end break, Microsoft has announced a security problem in SQL Server 7.0 and 2000.
2001-12-24
6,586 reads
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.
2001-12-21
3,118 reads
There are times when we need to know that rows of data that meet specific criteria exist in a table. There are 2 basic ways to find this information: COUNT() and EXISTS(). Here are some examples.
2001-12-20
5,029 reads
See how to configure and troubleshoot an HTTP connection to Analysis Services over both the Internet and an intranet. We will show you how to configure Microsoft Internet Information Services (IIS), and discuss the different security options for IIS in regard to Analysis Services.
2001-12-20
3,182 reads
Alxander Chigrik presents some useful User Defined Functions you can add to your SQL Server.
2001-12-19
8,657 reads
SQLServerCentral.com has launched a new contest until 1/31 where you can win the full version of Windows XP or several books. All you have to do is help build the SQL Server community. Start the new year right with a new OS!
2001-12-17
26 reads
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL Server data wherever you are. Using its built-in features, you can do the following from Internet Explorer or your favorite Web browser.
2001-12-14
4,151 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Comments posted to this topic are about the item Hyperscale Replicas IV
Comments posted to this topic are about the item The SQL Server Date Magic:...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers