Browse by Tags

Tagged Content List
  • Blog Post: DevOps for Windows Azure

    "DevOps" (Short for Dev eloper Op eration s ) 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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, we have more Mac...
  • Blog Post: 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 done – it’s optimistic to be sure...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Listing the Central Management Servers Programmatically

    I don't normally advocate hitting the system tables in any database with direct queries, preferring instead to use views or functions that the vendor provides. But so far I haven't been able to find the view or function that would return the list of servers in the Central Management Servers group on...
  • Blog Post: 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...
  • Blog Post: Server Consolidation Done Right

    Consolidating your servers is all the rage, especially since you can save money by doing it. You can save not only on the hardware, but the licenses. To do that properly, you need a strategy. You start by detailing what you have, and then lay out the apps and where they could go. Microsoft has a tool...
  • Blog Post: Are You Archiving Your Data?

    Computer technology has been a fixture of business now for several decades - but I'm not sure it's a "mature" industry yet. Sure, we have a few standards, and some dominant vendors and a strong workforce - all earmarks of a mature industry - but there are some gaping holes that we still have...
  • Blog Post: Another Reason to Use A Special Service Account

    When I'm asked what the least-used feature of SQL Server is, I often have to reply that it is "good security". Many installations take all the default settings, and most use programmatic security rather than the features built in to SQL Server. This is especially true of the service accounts...
  • Blog Post: The Quickest Route to a Custom Collector

    The Data Collector feature in SQL Server 2008 is a new way to automate the gathering of any data from SQL Server you want to store historically. Combine that with the Management Data Warehouse and Custom reports, and you have a powerful monitoring and tracking system for multiple servers. You get three...
  • Blog Post: Data Visualizations, Part Two - Excel relationship maps

    In a post back on the 6th of August I was pondering a bit about showing data relationships, such as permissions maps and so on. I mentioned that you almost need a 3-D interface for that. Well, a sharp reader, Marc Smith, read that post and pointed me to a CodePlex download that shows relationship maps...
  • Blog Post: SQL Server 2008 Feature Pack RC0

    The SQL Server 2008 Feature Pack for RC0 is now live - if you haven't downloaded this and played with it yet, shame on you! :) OK - just kidding - it's not like you don't have a day job. However, if you'll take a few moments and look this download over and find out how it can help you, you might find...
  • Blog Post: SQL Injection Attacks

    You might have read recently that there have been ongoing SQL injection attacks against vulnerable web applications occurring over the last few months. These attacks have received recurring attention in the press as they pop up in various geographies around the world. These attacks do not leverage any...
  • Blog Post: The Sysadmin DBA

    I’ve worked with a few database platforms in my time, most of them in large enterprises. One difference I’ve noticed in the DBA’s on those systems is that they have “pure” DBA’s –meaning that they work primarily with the database platform, not the operating system. In SQL Server installations, most of...
  • Blog Post: SQL Server Management Studio Standard Reports – The Full List

    I've completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to them from the tags, but I thought I would post a list of them all here with the links. I hope that you've been able to put some of this information into use in your organization. A lot of work went...
  • Blog Post: SQL Server Management Studio Standard Reports – Top Jobs

    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu that appears, click the Standard Reports , and...
  • Blog Post: But is it really new?

    I was showing a visitor some of the new improvements we have in SQL Server 2008 and when I started SQL Server Management Studio (SSMS), he said "oh, I thought you had something new." He expected to see a new user interface for SQL Server 2008. I don’t blame him. Microsoft had one interface for...
  • Blog Post: SQL Server Management Studio Standard Reports – Job Steps Execution History

    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu that appears, click the Standard Reports , and...
  • Blog Post: The Enterprise DBA

    In a couple of other posts, I’ve covered some of the challenges and strategies for dealing with those challenges that DBAs face. I mentioned that in my experience, the answers depend on the “kind” of DBA you are. I've covered the “single-seat” DBA and the Organization DBAs and today I’ll talk a little...
  • Blog Post: SQL Server Management Studio Standard Reports – Notification Services - General

    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that appears, click the Standard Reports , and then select...
  • Blog Post: SQL Server Management Studio Standard Reports – Number of Errors

    I'm continuing my series on the Standard Reports in SQL Server Management Studio and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that appears, click the Standard Reports , and then select...
Page 1 of 4 (100 items) 1234