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.
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.
Learn the key basics of writing quality Transact-SQL code.
Do OLAP tools shortchange users with time-varying data? This article by Seth Grimes looks at some of the problems with OLAP tools.
An interesting question and one that The OLAP Report attempts to answer. This article is an analysis of what the increasingly misused OLAP term is supposed to mean.
Attaching and detaching databases isn't rocket science, but if you have a lot of databases to attach it's pretty boring. Andy has written some VB code that uses SQL-DMO to speed up the process. But DMO isn't the only way - can you write a TSQL script to do the same thing? Fame and fortune await!
The SQLParser object - mostly undocumented - gives you an easy way to convert a TSQL string into a colorized RTF string. Andy started with that and wrote some code to change it to HTML. Useful? Never know! Code and demo program included with the article.
The User_Defined_Functions.exe file contains the User-Defined Functions white paper. The User-Defined functions white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create your own Transact-SQL functions to extend the programmability of Transact-SQL.
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
I have a numeric column called "Value" in a flat file, which contains both...
I have a numeric column called "Value" in a flat file, which contains both...
Comments posted to this topic are about the item Are We Dinosaurs?
What happens with this code:
DECLARE @Iteration INT = 0; WHILE @Iteration < 10 SELECT CustomerName, CustomerStatus FROM dbo.Customer WHERE CustomerID > 3; SET @Iteration += 1;See possible answers