stevienova.com

I am sure there are other SQL procedures that take parameters the same way, but I recently have been dealing with sp_add_job. You can call the procedure and pass in parameters
sp_add_job @job_name = ‘My Job Name’
for an example. But..you cannot do this
DECLARE @test AS [...]

12 Reasons Why a Geek Will Steal Your Girlfriend in 2008
(tags: geek)

An exercise in coding. Loading a text file to SQL. There are a billion different ways to do it, and depending on your source data format and such, you can parse the file a million ways too. But how fast can you get data from disk to SQL using .NET code? (VB.NET or C#) . [...]

Whew, long title, amazing results!
Problem: You have a laptop or computer and you are working remotely for a company. You VPN in. Your computer is not on their Active Directory (AD) domain. You try to connect to SQL Server using SSMS or Analysis Services using Excel, but it doesn’t work because it is using your [...]

Ok, more VBA
Getting a response back as Base64, but when trying to convert it from XML to binary data just having issues.. coming back as ASCII which converts wacked.
What you need to do:
Dim MyInfo As MSXML2.IXMLDOMNodeListSet MyInfo = xmlDoc.getElementsByTagName(”MyBase64Element”)MyInfo .Item(0).DataType = “bin.base64″
Dim image() As Byteimage = MyInfo .Item(0).nodeTypedValue
then you can use it in a byte [...]

In December 2006 I decided to not eat fast food (mainly McDonalds) anymore. The last time I had McDonalds was December 26th 2006 - I had breakfast with my stepsister Mel in Hibbing. I went all of 2007 without Mickey D’s and I would have to say that I am happy. I don’t really miss [...]

The other day I turned on my MacBook (thanks Reena! - still waiting for the “real” power charger…) and noticed the battery had a black X in it. I had it plugged in, it wasn’t charging. I unplugged it, and the MacBook shut down. Dang.
I unseated the battery, put it back in, and plugged it [...]

So, this morning, after a night out on the town in Madison, I am listening to Pandora.. and the Rolling Stones come on. Rolling Stones! Classic..the song is “I’m Free”. The thing is, all it does is remind me of those stupid credit card commercials that use the song. (ok the nitpickers will say it [...]

Girl Guide to Geeks
(tags: geek)

Check it out here
I have been a huge fan of Newsgator since it came out. For the last few weeks I have been using Google Reader, which is OK, but not as good as FeedDemon by far, there was an article posted about that here recently..and in the comments all the trolls yell “but goog [...]