Previous Sql Server Articles / More Sql Server Articles
Zune Revival
(The SQLTeam.com Weblogs)Looks like the Great Zune Massacre of 2008 was a day 366 issue.� Again, someone forgot to throw out the code from the lowest ten percent of the Stack-Rank system.� Sorry to sound harsh, but this is type of thing will flunk you out of Programming 101.� I don't even want to get started on the QA failure, but it is even worse.
Semi-Kudos to the Zune Team.� There was a notice on the support...
More from Zune Revival
Original
2009 is upon us, take the time to Reflect & Plan
(The SQLTeam.com Weblogs)Greetings All & Happy Pre-New Year!
I try my best to only write blog posts when they are informative and add potential value, thus it has been a while since I've blogged. The flip-side I suppose is sometimes my blog posts resemble short articles but oh well...
With 2009 upon us I thought I would share a bit of insight I have applied for the last three years of my career that...
More from 2009 is upon us, take the time to Reflect & Plan
Original
Zunicide
(The SQLTeam.com Weblogs)Yes, I own a 30 GB Zune.� Yes, it crashed today.� Yes, I am unhappy.
Having worked in the computer industry for many years now, I watched many companies deal with failed products.� Such is inevitable in an industry that gives the biggest rewards to the first implementation that is �good enough�.� More importantly, I have seen companies deal with failures in various ways.� Some handled...
More from Zunicide
Original
Deep dive to MDX presentation - slides
(SQLblog.com - The SQL Server blog spot on the web)During SQL PASS 2008 summit, I gave full day preconference seminar �Deep Dive to MDX�. The evaluation forms now have arrived, and the scores for the content, relevance and depth portion of the seminar are very good. The scores are not as high, however, for the time allocated (people argued that it should�ve been 2 days instead of one), and for the materials (since nobody received any...
More from Deep dive to MDX presentation - slides
Original
A Gift of Script for 2009: Who is Active, Redux
(SQLblog.com - The SQL Server blog spot on the web)Last year on December 31 I posted part of a larger monitoring script that I had been working on for a few months. I received lots of great feedback on the little script in both the comments and from people I was working with, and over the course of the last year I estimate that I have invested at least a couple of hundred hours in the script. The result of all of this time is attached, and I...
More from A Gift of Script for 2009: Who is Active, Redux
Original
A year in review, The 31 best blog posts on SQLBlog for 2008
(SQLblog.com - The SQL Server blog spot on the web)Wow, it has been already a year since I wrote A year in review, The 21 + 1 best blog posts on SQLBlog last year
Here we are with another fascinating collection of links, some of them are chosen for their content and some of them for the great comments.
A Gift of Script for 2008: Who's Active, What Are They Doing, and Who is Blocked? New version published today here A Gift of...
More from A year in review, The 31 best blog posts on SQLBlog for 2008
Original
Did You Know? You, too, can be a Geek!
(SQLblog.com - The SQL Server blog spot on the web)Danny Gould has a new (beta) version of his Internals Viewer, that you can download from Codeplex at http://www.codeplex.com/InternalsViewer
I've just started playing around with it, and the coolest thing is that it integrates right with your Management Studio!
The codeplex site include a Troubleshooting Guide and a User Guide.
It does look like it can display...
More from Did You Know? You, too, can be a Geek!
Original
Performance impact: file fragmentation and SAN - Part VI
(SQLblog.com - The SQL Server blog spot on the web)A script to fragment a test file
Well, this post won't cover any actual test results and is not specific to SAN. But in the spirit of full disclosure, I've attached the script I used to control the fragmentation level of the test files mentioned in this series of posts. The script is written in Perl, but can be easily done in any language.
The script does not itself fragment any...
More from Performance impact: file fragmentation and SAN - Part VI
Original
Restoring master database
(SQLblog.com - The SQL Server blog spot on the web)Disclaimer: I'm not an infrastructure DBA.Probably everything below is just bullshit. Recently our talented IT guys destroyed disk on a virtual machine. They chose the disk carefully - it was the one with master database. How do you restore master db from backup? Start SQL Server service from command line in single user mode and execute RESTORE DATABASE command. OK, start in single user mode...
More from Restoring master database
Original
Previous Sql Server Articles / More Sql Server Articles