Inspired by the Lifehacker article of “How to Write Down and Encrypt Your Passwords with an Old-School Tabula Recta” I have thrown together my own web-based Tabula Recta generator. This is a just a quick proof of concept. I don’t shift the characters but generate a random character from a limited character set (abcdefghijklmnopqrstuvwxys0123456789!@#$%^&*()+_-{}|;<>?) using… Read More »
Finally taking the plunge. First time blogger to T-SQL Tuesday here. I would have to start by saying that as I’ve grown in DBA skill and knowledge coming from the dark side (developers) I can see right off the bat some skills that are critical. Here are just some basic examples (near and dear to… Read More »
A UDF is a User Defined Function in SQL Server. You can develop the function using T-SQL or your favorite .NET language (C#, VB, etc). For Part One I’m going to talk about Scalar UDFs. Scalar UDFs are functions that return a single value only. There are a couple limitations to what UDFs can and can’t… Read More »
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 »
