Magenic Technologies Community Blog

Browse by Tags

• Broke Down on Twitter

  Alright I finally broke down and signed up for twitter. You can see me here - http://twitter.com/Vendoran. I'm syncing facebook and found an app that will also synch my IM status called Twessenger . I don't know if I really want to update my IM status Read More... Posted Thursday, April 24, 2008 7:48 AM from Aaron's space | 0 Comments Filed under: Computer and Internet

• SQL 2005 Current Query Activity

  SELECT sder.session_id AS [SPID], sdes.login_name AS [Login], sd.name AS [DBName], sder.start_time AS [ Start Time ], sder.status AS [Status], sder.command AS [Command], sdet.text AS [ SQL Text], sder.percent_complete AS [Pct Cmplt], sder.estimated_completion_time Read More... Posted Tuesday, October 30, 2007 10:34 AM from Aaron's space | 0 Comments Filed under: Computer and Internet

• Testing

  A colleague of mine Aaron Erickson has an interesting post on how deep testing should go here . This brings up some interesting points, for example in SQL Server I might test my own function, however I don't test SQL Functions like GETDATE, instead I Read More... Posted Wednesday, October 17, 2007 11:26 AM from Aaron's space | 0 Comments Filed under: Computer and Internet

• Check filegroup and file

  Often when dealing with different filegroups or even different files in SQL Server 2005, I end up wanting to know where certain objects are logically and physically located. Here's a query that will give that information: select 'Object Name' = so.name, Read More... Posted Tuesday, October 16, 2007 10:53 AM from Aaron's space | 0 Comments Filed under: Computer and Internet

• New Hardware

  Well I broke down and purchased some new hardware for my home machine. Last month I had posted my configuration and some of the problems I've had. Well this summer we experienced many power outages and since I had gone cheap and didn't have the computer Read More... Posted Tuesday, October 09, 2007 3:47 PM from Aaron's space | 0 Comments Filed under: Computer and Internet

• Great Job!

  Aaron Erickson (a fellow Magenicon) has become a Microsoft MVP in C#. Great Job Aaron ! Read More... Posted Tuesday, October 02, 2007 10:47 AM from Aaron's space | 0 Comments Filed under: Computer and Internet

• sp_readrequest?

  Share this post : So I've been running a trace on some SQL 2005 servers for awhile now and I'm starting to analyze them. One of the things I look at is statement top 10 duration. It was interesting to see all 10 entries to on every day I monitored to Read More... Posted Tuesday, September 11, 2007 2:32 PM from Aaron's space | 0 Comments Filed under: Computer and Internet

• Move HEAP Tables

  Share this post : One of the things I've been doing lately for an upgrade from SQL 2000 to SQL 2005 is restructuring databases, adding filegroups and files to split out the data and non clustered indexes, leaving only the system tables in the primary Read More... Posted Tuesday, September 11, 2007 1:47 PM from Aaron's space | 0 Comments Filed under: Computer and Internet

• No dice

  Share this post : So I got home and immediately installed the Vista Update. The first update that I tried KB938979 actually hung and the Vista dialog came up stating the application error and do I want to close or look online for solutions...this gave Read More... Posted Wednesday, August 08, 2007 9:42 AM from Aaron's space | 0 Comments Filed under: Computer and Internet

• Video on Vista

  Share this post : So awhile back I wrote about moving from vista 64. Since then I have gone to Vista x32 and XP x64, all to no avail. The best experience I've had has still been Vista x64. So I have reloaded it on my computer and am quite happy with it....Many Read More... Posted Tuesday, August 07, 2007 4:28 PM from Aaron's space | 0 Comments Filed under: Computer and Internet

• 64-bit Vista and Windows Easy Transfer (File and Settings Transfer Wizard)

  Share this post : I had built a new computer last December (thanks http://www.newegg.com/ ). I received all the hardware and loaded up Vista x64 and have been loving the Vista experience since. However I have not enjoyed the x64 experience. Things I discovered Read More... Posted Monday, June 18, 2007 12:33 PM from Aaron's space | 0 Comments Filed under: Computer and Internet