Yesterday I was fortunate to have attended SQL Saturday down in Englewood. For those that might not know SQL Saturday is a FREE one-day event with expert speakers that are all about SQL Server. In attendance were several MVPs: Jason Strate, Chris Shaw, Glenn Berry, and Tim Mitchell (just to name a few). I started… Read More »
Inspired by the upcoming presentation by Jen McCown at SQLSat #52 on brushing up your T-SQL I have embarked on a journey to better my own skills. So, first off the definition of a view is a “virtual table that is outlined by a query and used as a table“. It also must follow this… Read More »
The other day (prompted by a tweet by @buckwoody) I ran the Microsoft Baseline Analyzer on one of my SQL DBs. One of the recommendations it made was that I create multiple data files for tempDB as allocations were slow. I vaguely remember reading about doing this but was still hazy on the details. So… Read More »
Below is a very simple proof of concept that I’ve been batting around in my head awhile. There is much talk of the validity of MongoDB (http://mongodb.com) and even of it’s replacing SQL Server. I am in no way advocating this. MongoDB is great for some applications, but not a full ACID compliant database in… Read More »
Built into 2008 is a nice little tool called Activity Monitor. If you have SSMS 2008 simply open it, right-click on the top level server name and select “Activity Monitor”. With Activity Monitor you can get real-time data on Processes, Wait Tasks, and I/O. A very handy and quick view of your SQL Server(s). Also,… Read More »
