A Windows 2000 Service Pack 2 Update
Getting ready to install Windows 2000 SP2? Read this article first. It provides links to resources as well as potential problems.
2001-06-01
1,069 reads
Articles
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,514 reads
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,695 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,349 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,594 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,056 reads
2001-05-25
3,987 reads
Blogs
A New Word: Mottleheaded
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
Microsoft Purview GA menu’s
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Connect to Power BI as a Guest User in another Tenant
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
Forums
Strange behaviour in wrapper script
We have a script to elevate a system user to Super Admin privilege, with...
Weekday different executing procedure directly or executing by SQL Server Agent
Hi I have a little big problem. I have a job that uses the...
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Question of the Day
Disable All the Indexes
How do I disable all the indexes on the dbo.Logger table?
See possible answers