SQL Server News & Information tsql, performance tuning, industry trends, & bad jokes
tsql, performance tuning, industry trends, & bad jokes
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
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
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.
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.
See.
Pic credit to TechCruch.
If you don’t get it, then you have not seen this:
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'iehDan Curtin - This was tomorrowJeff Mills - The bellsThe Aztec Mystic - Jaguar (Original mix) Morgan Geist - Room 120-2 (dan curtin re-work) deep chord - step 3 (Mike Huckaby Remix)Octave One -Daystar RisingDBX - ? Robert Hood - Public Enemy No. 1Detroit Grand Pubahs - Thanks For Coming (Steve Bug's As Funky As Your Ass Mix) Aril Brikha - Deeparture in TimeLos Hermanos - Birth of 3000Model 500 - Starlight [Echospace Mix] Soul Designer - Street Jazz VariationsCharacter Maps Remix - PerspectsMorgan Geist - In your electricAudion - T.B.Troy Pierce - 25 Bitches (Berg Nixon ZigZag ) Carl Craig - Demented DrumsClé - WaterPhoto - synthesis aka suburban knightPhsyche - Crack DownOrlando Voorn - FlashJohn Tejada & Justin Maxwell - Pimp My GlideConvextion - Frozen Surfaceduplex - autosugMarco Passarani - Clairmorgan geist - most of all (feat. jeremy greenspan)
Check all the other geek graffiti @ oddee
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:
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?
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.
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
2,796
43%
Engadget
617
69%
SlickDeals.net
365
97%
TechCrunch
292
60%
craigslist | computer gigs in dallas / fort worth
209
95%
Search results for 'sql'
174
83%
Snowcovered New Releases for DotNetNuke 4
169
99%
SQLServerCentral.com
112
The FAIL Blog
93
87%
SQLblog.com - The SQL Server blog spot on the web
81
98%
(title unknown)
72
13%
Scobleizer -- Tech geek blogger
48
louisgray.com
81%
DotNetKicks.com - Stories tagged with Database
41
sqlblogcasts.com
36
86%
CloudAve
30%
Microsoft PressPass, Information for Journalists - Press Releases
33
77%
blog.scottlowe.org
30
100%
BrentOzar.com
88%
The SQLTeam.com Weblogs
27
90%
Is This Thing On?
61%
Most recent blog entries
26
Intel Press Room
76%
<EM>Untitled subscription</EM>
22
SarahLacy.com
21
78%
Keith Combs' Blahg
64%
Chris Shaw's Weblog
20
91%
SQL Server
67%
All Blogs
59%
LOLTheist: Blasphemy is Teh Funneh
19
70%
MSDN Forums: SQL Server Disaster Recovery and Availability
8%
sqlserverpedia.com
18
mca blog
82%
blogs.technet.com
17
85%
Announcements