DevOps for Windows Azure

“DevOps” (Short for Developer Operations) is one of a group of new terms such as “Cloud”, “Big Data” and “Data Scientist” – words that are somewhere between marketing and tasks we’ve actually had around in other forms for years.However, working in a Distributed Environment (Both on and off premises)  like Windows Azure does bring a…

0

Management and Monitoring Tools for Windows Azure

(Last updated on 01/15/2013) With such a large platform, Windows Azure has a lot of moving parts. We’ve done our best to keep the interface as simple as possible, while giving you the most control and visibility we can. However, as with most Microsoft products, there are multiple ways to do something – and I’ve…

8

The SQL Server Health Check

My friend Brent Ozar, who is a top-notch SQL Server Professional, mentioned on his blog (http://www.brentozar.com/archive/2007/04/sql-server-health-check/comment-page-1/#comment-17520) that he brought in Microsoft Support to do a “Health Check”. There were some questions about what this actually entails – so I thought I would post that description here. A SQL Server Health Check from Microsoft is an…

0

How Does Microsoft Do IT?

Microsoft is a big company – and of course we have a lot of IT infrastructure that we have to manage. It might surprise you to learn that we have an IT group, just like at your company. We have a networking team, a server hardware team, software teams, DBA’s, the whole bit. In fact,…

0

Tools and Processes for “Fitting it all in”

Most data professionals I’ve met work in two modes: we plan for our day, and we react to the situations around us. I’m staring at my list of things that I need to do today right now, which is my planned work. Of course, I have no idea how much of that will really get…

2

How Microsoft Does IT – Updated

I’ve pointed out this link before, and I’ll definitely bring it up again. Microsoft is one of the few companies I know, especially the big ones, that explains how they run their IT. We have a fantastic, I mean really fantastic site that you should definitely check out. Can save you lots of time, and…

0

The Plan for Evaluating a New Release

SQL Server 2008 R2 is now out, and you can get the “Customer Technical Preview” or CTP here: http://technet.microsoft.com/en-us/evalcenter/ee315247.aspx But it seems like SQL Server 2008 just came out! I’m still installing and upgrading it on the systems I manage. I tend not to focus too much on a new release, but it’s foolish, I…

2

Moving Tables Between Filegroups

I got an e-mail in response to the Best Practices blogs on Filegroups. I’ve gotten other e-mails similar to this one, so I thought I would answer (or try to) all of them here. Here’s the e-mail:   "I recently started a new DBA job.  When I started the company had recently purchased new hardware…

2

Article on SQL Server Chargeback

I posted the first part of the article on SQL Server Chargeback strategies over on InformIT: http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=311 The big point to make is that you will have to develop this system yourself, since there is no way a vendor can decide how much you should charge, or even what you should charge for. The best…

2