Recently I finished an upgrade on a WSS 2.0 to 3.0 project. Yeah, I know, very much behind the times now that 2010 is out. However, I thought I would post the painful steps in case some other unlucky soul has this task ahead of them. To be specific I am doing an in-place upgrade… Read More »
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 »
Recently Eric Schmidt (CEO of Google) talked about the “Dark Side of Social Networking“. His view is one day people will change their names in order to escape the online persona they have created and he is right except that “one day” is really today. Many companies are now checking Facebook, Twitter, etc. as part… Read More »
Yesterday morning I attended Sharepoint Saturday down in Denver. From the Sharepoint Saturday website (http://sharepointsaturday.org): “SharePoint Saturday is an educational, informative & lively day filled with sessions from respected SharePoint professionals & MVPs, covering a wide variety of SharePoint-orientated topics. SharePoint Saturday is FREE, open to the public and is your local chance to immerse… 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 »
As everyone knows the economy has been tough on the I.T. field. Redmond magazine even did a great piece in their June issue called “I.T. Hell: How the Recession Has Affected I.T. Jobs“. More often than not the first thing out the I.T. budget window is training and travel. Since technology changes almost daily an… 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 »
So one of the more interesting projects in my opinion is the Varnish Cache project (http://varnish.projects.linpro.no/). Now I know I’m supposed to be this pro-Microsoft guy now what with all the certs and working with it day in and out, but the budget crunch has hit us pretty hard. So, when the GIS guys needed… Read More »
