MesaureUP Test Prep (70-029)
Review of the MeasureUp test preparation serivce actually used by the author for the SQL Server 7 Design exam(70-029).
2001-05-31
3,513 reads
Articles
SP_MSFOREACHDB - Getting a list of databases via TSQL.
Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.
2001-05-31
13,668 reads
SQL 7 Bugs on SMP Servers
SQL Server 7 has a number of bugs that occur on multi-processor machines. This article presents a concise listing of these bugs.
2001-05-30
3,322 reads
A Look at SQL Server CE
An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.
2001-05-30
1,721 reads
ANSI Joins
Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.
2001-05-29
10,237 reads
SQL Server 7.0 and 2000 Clustering Resources
A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.
2001-05-29
1,816 reads
Your Friend the Computer
You know it is time to reassess your relationship with
your computer when....
2001-05-28
1,593 reads
Removing NT Administrators as Sysadmins
By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.
2001-05-25
4,053 reads
2001-05-25
3,985 reads
Quickly Enabling and Disabling Constraints and Triggers
In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL.
2001-05-24
9,922 reads
Blogs
Sharpen Your SQL Skills: June’s Challenge Awaits!
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge....
Denver Dev Day – Best Practices for Database Deployments Resources
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
A New Word: desanté
By Steve Jones
desanté – n. the brooding delirium of being sick, which makes time slow to...
Forums
The SQL Assessment API
Comments posted to this topic are about the item The SQL Assessment API
Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide
Comments posted to this topic are about the item Bridging Snowflake and Azure Data...
DBCC CLONEDATABASE is Semi-Discontinued
Comments posted to this topic are about the item DBCC CLONEDATABASE is Semi-Discontinued