New Article: Determining SQL Server database storage requirements
I’ve published a new tip over on SearchSQLServer.com entitled “Determining SQL Server database storage requirements“.
SQL CLR: The What, When, Why and How.
There are two camps when it comes to SQL CLR. The DBA camp, which says don’t use it, it’ll kill your SQL Server and the Developer camp which says that it will save you loads of time and that you should use it for everything.
XML in the database. What’s the big deal any way?
So, we’ve had the ability to use XML within the SQL Server databases since SQL 2000 came out. What’s the big deal? How can I use it to make my life easier? …
Using a foreach loop to process an XML document.
Receintly I was working on a project where I needed to use a foreach loop with an SSIS project, but couldn’t for the life of me get it to properly process the XML document which I was giving it. Well with some major work and digging I was able to get it working correctly, but it took me for ever to get all the little setting correct so I figured that I’d throw the info up here for anyone else who is looking for it.