Subscribe to this blog
SQL Man of Mystery
Archives: February 2010
What I’ve Read and Recommend to Others – General Database and Theory by C.J. Date
| Date on Database: Writings 2000-2006 This is a collection of writings by C.J. Date, one of the fathers of the relational model. It has a nice tribute to E.F. Codd, inventor of the relational model. If you are looking for tips and insights into relational databases on a higher level… |
5 comments, 517 reads
Posted in SQL Man of Mystery on 26 February 2010
Sometimes, you have to fix it yourself
The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice your issues or problems. They allow you to vote on the issue and then decide when or if it will get fixed. I’ve used Connect when I hit a… Read more
4 comments, 407 reads
Posted in SQL Man of Mystery on 18 February 2010
Quick Tip Of The Day
Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do you know when your server was last rebooted? Well, every time your SQL Server service restarts tempdb is recreated every time. With a quick query to sys.databases we can get… Read more
11 comments, 892 reads
Posted in SQL Man of Mystery on 16 February 2010
Three Turns On The Road
Huh? My story? Okay. It was never easy for me. I was born a poor black child. I remember the days, sittin' on the porch with my family, singin' and dancin' down in Mississippi. – The Jerk
This meme was started by Paul Randal (Blog | Twitter) who… Read more
6 comments, 184 reads
Posted in SQL Man of Mystery on 16 February 2010