Funny SQL Server Error Messages
This is the funniest error message Brian Knight has ever seen in SQL Server.
Using Uniqueindentifier Instead of Identity
Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns.
DBCC SQLPERF (Logspace) Reporting Internals
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
Support for Network Database Files
By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.
Microsoft SQL Server OLAP Services Cell-Level Security
This article describes how SQL Server 7.0 (Service Pack 1) OLAP Services takes advantage of the user and group structure in Microsoft Windows NT to offer cell-level security, and describes several ways to tailor permissions to data across the enterprise.
Review: Professional SQL Server 2000 XML
Professional SQL Server 2000 XML - Find out if this book from Wrox is as interesting as it sounds.
Connection Pooling with Microsoft SQL Server 2000 Analysis Services
This white paper describes how to use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for Microsoft SQL Server 2000 Analysis Services. (11 printed pages)
An Alternative to Windows NT
Left over from the Y2K fiasco, but a good corporate memo that might still be useful as an alternative to XP.
Death of the Production DBA
If you see a priest outside your cubical, beware! He could be trying to read you your last rites. If he hasn't showed up yet, don't worry, he'll be over shortly because the production DBA is dead or will be shortly.
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers