Author Archives: Matt
DQS Services in Denali
Interesting article about the upcoming Data Quality Services feature in Denali. It’s worth mentioning, as it’s very similar to the Data Quality Control system that I developed (with a little inspiration from my friend) for our current data mart. In … Continue reading
XML Schema Creation in SQL Server 2005
Here’s an interesting approach for creating a quick and dirty schema to get you started with XML. DECLARE @schema xml SET @schema = (SELECT * FROM schema.TABLE FOR XML AUTO, ELEMENTS, XMLSCHEMA(’SchemaName’)) SELECT @schema I don’t have the source, but … Continue reading
T-SQL Alter Statement Quirk
To answer a recent question to the PSSUG user group e-mail, I put together a post instead of trying to answer via e-mail. First, the question: I have a staging table. Stage_id identity Stage_File_Name nvarchar(100) AllData nvarchar(max) I load a … Continue reading
Recursive Directory Scripting
Inside source control, I have scripts arranged as follows: Drive:/Base/Database/ Drive:/Base/Database/Functions Drive:/Base/Database/Proc Drive:/Base/Database/Tables Etc.. Each script stored can be run multiple times with no ill effect. For example, a table generation script first checks to see that it exists before … Continue reading
Primary, Secondary, Tertiary, umm…?
I recently found myself asking the question posed in the title – what comes after primary, secondary, tertiary…? I had a rough idea, based on my drum line days, and the various types of Tenor drums. However, this article lays … Continue reading
Moving Database Logins
Recently we had a database issue, that necessitated us moving logins. Here’s an article I used from Microsoft to help script the logins. The KB is specifically for 2005 -> 2008, but it will also get you login’s out of … Continue reading
RePost: Database development mistakes made by application developers
Link Personally, I think this should also include database developers operating on too little sleep and/or too close of a deadline.
Enable CLR
This is just one of those things that I always forget how to do. EXEC sp_CONFIGURE ‘SHOW ADVANCED OPTIONS’ , ’1′ — Let me change it GO RECONFIGURE GO EXEC sp_CONFIGURE ‘CLR ENABLED’ , ’1′ GO RECONFIGURE GO EXEC sp_CONFIGURE … Continue reading
T-SQL Creativity
This article has little to do with useful t-sql applications – since to me, minesweeper is meant for a mouse. However, it really demonstrates a fun use of t-sql. Minesweeper in T-SQL
Reporting Services Scripting for fun and profit
After spending too long on Google, and finally getting an appropriate answer from a colleague, I thought it wise to record this information in case someone finds themselves in a similar situation. This stackoverflow sums up my issue nicely: “I … Continue reading