April 2008 - Posts
If you are headed to the MS launch event tomorrow make sure you stop by the Magenic kiosk and say hello. I will be splitting my time between our kiosk and the Ask the Experts area. It should be a great day, the presentations are always top notch
Read More...
After a bit of delay I'm back with the last installment of SQL Basics. I planned to write this blog several times over the last few days but to be honest I had other interests. My daughter said her first words this week, which just happened to be "dada",
Read More...
We are in part two of our four part series around basic operations in TSQL. Today we will be finding tables based on certain criteria. Here are a couple I will show: Finding table names matching a string Finding tables containing a certain
Read More...
I have decided to step away from the SQL 2008 CTP for a bit and post a couple items that keep coming up. I have been spending more time in the MSDN Transact SQL forums and have noticed a consistent stream of questions around some basic operations
Read More...
Today I'm looking at one of my favorite SQL Server 2008 features, Change Data Capture (CDC from here). CDC collects insert, update, and delete activity against a SQL Server table and stores the details of the changes in a relational format.
Read More...
Next week marks the end of mainstream support for SQL Server 2000 SP4 . I have been really focused on SQL Server 2008 and it's new features so I kept having the "oh yeah" moment when it came to end of support for this version. I am still
Read More...