BorderLayoutBoxedLayoutOpenLayoutMaximum textMedium textSmall text


Register
Tuesday, January 06, 2009

SQL Server News & Information

tsql, performance tuning, industry trends, & bad jokes

exec spSubscribeMinimize
Print  
SELECT TOP 15Minimize
Print  
sp_help 'jmassie'Minimize

This site is maintained by Jason Massie. He has 10 years experience as a DBA and has specialized in performance tuning for the last five. He was recognized by Microsoft as a SQL Server MVP. Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. He has worked at Terremark (formerly Data Return) for nearly a decade.

You can contact him at jason@statisticsio.com or 469.569.5965

Jason has the following certifications:
  • Microsoft Certified IT Professional Database Administrator (early adopter)
  • Microsoft Certified IT Professional Database Developer
  • MCDBA (7.0 and 2000)
  • MCSE
  • MCSD
Print  
tblTagCloudMinimize

Abstracts addition Affinity Aggregation allocation Always Analysis Announced another API Appending article Authentication backup be Behavior between Bootstrapper Breaking Build Cache Caching Check checksums Codeplex collection Connecting contest Controller Creating CTEs CTP CUBE cursors Data Database DATALENGTH Debugging Design Diagnosing Diagnostic Differences Documentation DTS Emergency enhancement Entity ETW Exchange execution Express Extensions Fall February Filestream Filtered group GROUPING have Hosting Idle impact Improvement Increase Index Indexes Inserts Instances Interoperability Introduction IO large Late LOB local Localized Magazine Maintaining Maintenance Management maps March Microsoft minutes missing Mix Never November Offline OLE Online operations operators optimizations Optimized Overlapping Package Page Paging Panacea parallel part Partial Partition partitioned Partitioning PASS Performance PFS plan Plans Practices problem Problems Procedure Program programmatically Programming Protection Queries query read recent Recursive Related released Reports Restore return ROLLUP ROWCOUNT Runtime Security Select Sequence sequential Server Services set SETS Shooting shorts sizes Solutions Sortable SPARSE Spool SQL SQLIOSim SSIS Stalled Star Statement Statements stats Stored strategy Stuck Studio Submission Subreports Suggested Summarizing system Table Tables Tampa Task Than there through Timeouts Total Traces Transaction transfer Tricks Trouble TSQL turning understand Understanding undocumented Unique unused upgrade Upgrading Useful Value variables VDI Vista Will Windows Wireless

Print  

Entries for the 'Offtopic' Category

Tagged: New Year’s Resolutions

Posted by Jason Massie Click to IM Jason Massie on Monday, December 29, 2008 at 11:14 PM to Offtopic
138 Views | 1 Comments | Article Rating

Dick Clark not David Stein David Stein started a new and timely thread. He tagged me.

This article is about the professional resolutions for improvement that I intend to make in the new year and I will tag a couple other people to do the same.

  1. Learn enough linux to manage a database on that platform.
  2. Become an orange belt(or better) on Oracle and MySQL
  3. Master Inbox Zero.
  4. 2.5 technical blog posts a week in addition to the useless blabber and failed humor attempts.
  5. Maintain balance between work, family and community.

Next victims:

Denis Gobo(Twitter, RSS, LessThanDot)

Joe Sack (RSS)

Michael O’Neal(Twitter, RSS)

Chris Shaw(Twitter, RSS)

 

P.S. Exercise 4x a week and make it back down to size 32’s.

email it! |   |   | 

The Internet Really is a Series of Tubes

Posted by Jason Massie Click to IM Jason Massie on Sunday, December 14, 2008 at 11:49 AM to Offtopic
136 Views | 1 Comments | Article Rating

See.

Pic credit to TechCruch.

If you don’t get it, then you have not seen this:

email it! |   |   | 

Detroit Techno

Posted by Jason Massie Click to IM Jason Massie on Saturday, December 13, 2008 at 11:51 PM to Offtopic
190 Views | 0 Comments | Article Rating

http://statisticsio.com/jmass%20-%20detroit.mp3

It has been a while since I have time to put together a mix. This one is themed around my favorite genre and most painful points of my life. I remember being in Detroit and hearing “Clear” over the intercom in Taco Bell while ordering food through bullet proof glass. That is the theme of Detroit in general. Melancholy at best and a life or death struggle at worst.

I read somewhere that in the 70\80’s, Detroit was about the only major metroplex that black folks had a widespread good future due the auto industry. Some of the children of that generation took the soul from Motown, bought synths and drum machines and turned it into techno.

This is my tribute. If you are “in the know”, some of the classics may be played out to you and some are only influenced by Detroit. This mix is aimed at someone who has never heard this music but you may find a good tune or two here as well. I hope enjoy. You can find out more about these artists here http://discogs.com

I kinda have been trying figure out if I wanted to post this or not. There is one song that I should have excluded and a bump in another mix. However, I decided the music is worth hearing especially if you like electronic music but have not heard Detroit Techno.


Morgan Geist - Detroit (feat. jeremy greenspan)
D5 - Oscillator
$tinkworx - Hu T'ieh
Dan Curtin - This was tomorrow
Jeff Mills - The bells
The Aztec Mystic - Jaguar (Original mix)
Morgan Geist - Room 120-2 (dan curtin re-work)
deep chord - step 3 (Mike Huckaby Remix)
Octave One -Daystar Rising
DBX - ?
Robert Hood - Public Enemy No. 1
Detroit Grand Pubahs - Thanks For Coming (Steve Bug's As Funky As Your Ass Mix)
Aril Brikha - Deeparture in Time
Los Hermanos - Birth of 3000
Model 500 - Starlight [Echospace Mix]
Soul Designer - Street Jazz Variations
Character Maps Remix - Perspects
Morgan Geist - In your electric
Audion - T.B.
Troy Pierce - 25 Bitches (Berg Nixon ZigZag )
Carl Craig - Demented Drums
Clé - Water
Photo - synthesis aka suburban knight
Phsyche - Crack Down
Orlando Voorn - Flash
John Tejada & Justin Maxwell - Pimp My Glide
Convextion - Frozen Surface
duplex - autosug
Marco Passarani - Clair
morgan geist - most of all (feat. jeremy greenspan)

http://statisticsio.com/jmass%20-%20detroit.mp3

email it! |   |   | 

DBA Shenanigans

Posted by Jason Massie Click to IM Jason Massie on Friday, December 05, 2008 at 9:20 PM to Offtopic, Humor
366 Views | 1 Comments | Article Rating

 Check all the other geek graffiti @ oddee

email it! |   |   | 

Yup, I am that Douche

Posted by Jason Massie Click to IM Jason Massie on Saturday, November 15, 2008 at 12:49 AM to Offtopic, Professional Development
411 Views | 10 Comments | Article Rating

Wow, what stressful week. I would much rather do a total disaster recovery on a VLDB than do this again. Last week, I announced I had taken a new job. Leaving my current position of nearly a decade. Well, I took a counter offer. When I resigned I told them I was not interested in a counter offer. I was so confident that I even announced it here before my butt was in the new seat. I took the job because it was really cool. There was not anything wrong with my current job or company. I was perfectly happy. The prospective employer contacted me on linkedin. I was not out job hunting.

My current employer respected that I wasn’t interested in a counter offer but a week and a half into my final two weeks the Manager of Database Services and Escalations resigned and they offered me that job. I thought that my decision to take the new job was tough. Well, let me tell you taking the counter offer was 10x rougher.

I weighed all of the pro’s and con’s. The only con for staying was the fact that I would be going back on my word. I don’t take that lightly but it was the best move for my family and I.

It came down to a lot of reasons but two main ones:

  • We started this process talking in September. The economy had a horrible October. The outlook is grim for at least the next year. Most people expect it to get much worse before it gets better. I would much rather go through a great depression scale recession here. That may be just because I know where the company stands in the market and with me. However, I would hate to be the low man on the totem pole who is working remotely if things get really bad.
  • In October, Microsoft announced their cloud computing initiative at PDC. This basically makes the MSSQL DBA obsolete. There will still be some on premise installations but it will be for legacy applications and the largest application so the MSSQL DBA market will be much smaller. That may take a few years but I am making this decision with the next decade in mind. In my new role, I will gain MySQL and Oracle experience which will allow me to diversify.

Conventional wisdom says never take a counter offer. However, I took the new job for unconventional reasons. It wasn’t about money. It wasn’t because I was unhappy. It was all geek factor. I just wanted to work on something of that scale.

I don’t think there is a totally right answer and I will always wonder “What if” but now that the smoke has cleared, I am feeling more and more that I made the best decision.

Thoughts?

email it! |   |   | 

A New Chapter

Posted by Jason Massie Click to IM Jason Massie on Tuesday, November 04, 2008 at 3:34 PM to Offtopic
374 Views | 16 Comments | Article Rating

I have been with Terremark WorldWide(Formerly Data Return) since June of 1999. Almost 70 dog years or 100 IT years. Through the good times like the startup and IPO phases. The bad times; It was tough for a managed hosting company in the dotcom bubble. At one point, I was the DBA, AD admin, exchange admin and helpdesk after several layoffs. We fought our way through all of that with the help of some remarkable people and leadership. I would consider this another good time for the company but it is time for me to move on.

So what on earth could make a change adverse person like me do something so drastic? MySpace. I have accepted a position on the Database Administration team. Depending on how you count the beans, they have to be in the top 3 largest MSSQL installations in the world. I really liked the culture and clicked with the team members. I think this position will keep me happy for the next decade or more.

However, it is very weird. Pinch me.

email it! |   |   | 

Google Reader Stats

Posted by Jason Massie Click to IM Jason Massie on Thursday, October 30, 2008 at 11:48 PM to Offtopic
622 Views | 3 Comments | Article Rating

I guess it is safe say I am a geek who is into SQL with my eye on the cloud. Anything in your top 40 that I am missing out on?

Note: You will have to be a google reader user for those links to work. Although, you can probably reverse engineer if need be.

 


Subscription


# Read


% Read


sql - Twitter Search at Summize clip_image001[42]


2,796


43%


Engadget clip_image001[43]


617


69%


SlickDeals.net clip_image001[44]


365


97%


TechCrunch clip_image001[45]


292


60%


craigslist | computer gigs in dallas / fort worth clip_image001[46]


209


95%


Search results for 'sql' clip_image001[47]


174


83%


Snowcovered New Releases for DotNetNuke 4 clip_image001[48]


169


99%


SQLServerCentral.com clip_image001[49]


112


97%


The FAIL Blog clip_image001[50]


93


87%


SQLblog.com - The SQL Server blog spot on the web clip_image001[51]


81


98%


(title unknown) clip_image001[52]


72


13%


Scobleizer -- Tech geek blogger clip_image001[53]


48


98%


louisgray.com clip_image001[54]


48


81%


DotNetKicks.com - Stories tagged with Database clip_image001[55]


41


60%


sqlblogcasts.com clip_image001[56]


36


86%


CloudAve clip_image001[57]


36


30%


Microsoft PressPass, Information for Journalists - Press Releases clip_image001[58]


33


77%


blog.scottlowe.org clip_image001[59]


30


100%


BrentOzar.com clip_image001[60]


30


88%


The SQLTeam.com Weblogs clip_image001[61]


27


90%


Is This Thing On? clip_image001[62]


27


61%


Most recent blog entries clip_image001[63]


26


87%


Intel Press Room clip_image001[64]


26


76%


<EM>Untitled subscription</EM> clip_image001[65]


22


100%


SarahLacy.com clip_image001[66]


21


78%


Keith Combs' Blahg clip_image001[67]


21


64%


Chris Shaw's Weblog clip_image001[68]


20


91%


SQL Server clip_image001[69]


20


67%


All Blogs clip_image001[70]


20


59%


LOLTheist: Blasphemy is Teh Funneh clip_image001[71]


19


70%


MSDN Forums: SQL Server Disaster Recovery and Availability clip_image001[72]


19


8%


sqlserverpedia.com clip_image001[73]


18


90%


mca blog clip_image001[74]


18


82%


blogs.technet.com clip_image001[75]


17


85%


Announcements