Funny SQL Server Error Messages
This is the funniest error message Brian Knight has ever seen in SQL Server.
This is the funniest error message Brian Knight has ever seen in SQL Server.
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.
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.
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.
Professional SQL Server 2000 XML - Find out if this book from Wrox is as interesting as it sounds.
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)
Left over from the Y2K fiasco, but a good corporate memo that might still be useful as an alternative to XP.
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.
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
This is one of those things that on hindsight was a stupid problem, but...
Hi Expert, I wanted to calculate max date for prodstatus =5 - min date...
Hello guys, I am preparing for Azure DE positions with Data Factory, Databricks, Synapse....
OK so I have a customer with a hosted website with eCommerce options. Essentially...