• Carpe Datum

    SQL Server Management Studio Standard Reports – Schema Changes History

    • 2 Comments
    I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS). The Schema Changes History report shows the changes you’ve made using Data Definition Language statements, similar to the Configuration Changes History...
  • Carpe Datum

    Backup Meta-Data

    • 4 Comments
    I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled...
  • Carpe Datum

    Windows Azure Visio Shapes

    • 3 Comments
    Normally when I diagram a solution for a customer, I use whatever they are comfortable with. I do most of my work these days in OneNote, especially when it’s an Architecture Design Session (ADS), since I can capture notes, handwriting, drawings, web pages...
  • Carpe Datum

    Commenting your Code

    • 7 Comments
    You should always add descriptive comments to any code that will live longer than a single event. It's useful not only for the other unfortunate souls blessed with your code, but for yourself, years later, when you say "what was I thinking here?"...
  • Carpe Datum

    Windows Azure Learning Plan

    • 9 Comments
    Note: On June 7th, Microsoft dramatically enhanced the Windows Azure Platform. I'm leaving this resource here, but an updated version is now here: http://blogs.msdn.com/b/buckwoody/archive/2012/06/13/windows-azure-write-run-or-use-software.aspx ...
  • Carpe Datum

    Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance - My Notes as of 5/3/09

    • 5 Comments
    Well, here's where I'm at so far: Requirements: 1. Install SQL Server 2008 and related services - file locations; default paths; service accounts http://msdn.microsoft.com/en-us/library/ms143547.aspx NTFS is required for installation, but if you upgrade...
  • Carpe Datum

    Script of the day - Remove White Space from a String

    • 12 Comments
    OK - this might be stretching the "Is this Useful" question a bit, but hey, I needed it today and thought I would share it with you - it's free! This construct takes the whitespace out of a string. /* usc_DBA_Remove_White_Space.sql Removes extra...
  • Carpe Datum

    Using PowerShell and SMO to list Databases (and other stuff)

    • 2 Comments
    You don't have to use the new PowerShell Provider for SQL Server 2008 to talk to SQL Server, even for versions from 2000 up. To do that, you'll need the Server Management Objects (SMO) libraries. You can install those separately, but you'll already...
  • Carpe Datum

    Who is Active - a replacement for sp_who2

    • 1 Comments
    Most every DBA I know uses sp_who2, an undocumented stored procedure that shows locking, blocking, who is on, what they are doing and so on. At TechEd on Monday (I could only go for one day this time) I met up with my friend Adam Mechanic - a SQL Server...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Backup and Restore Events: [DatabaseName]

    • 2 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears...
  • Carpe Datum

    Using linked servers, OPENROWSET and OPENQUERY

    • 0 Comments
    SQL Server has a few mechanisms to reach out to another server (even another server type) and query data from within a Transact-SQL statement. Among them are a set of stored credentials and information (called a Linked Server ), a statement that uses...
  • Carpe Datum

    Designing for the cloud

    • 0 Comments
    With the advent of platform as a service (Azure and paradigms like it) it isn't enough to simply write the same code patterns as we have in the past. To be sure, those patterns will still function in Azure, but we are not taking full advantage of the...
  • Carpe Datum

    PowerShell and SQL Server: Script all Tables

    • 2 Comments
    This is a script that I found/put together/re-arranged that will script out all of the tables from a database - in this case, Adventureworks2008. You need to change the BWOODY1 part to the name of your server, and the SQL2K8 part to your Instance name...
  • Carpe Datum

    Windows Azure – Write, Run or Use Software

    • 1 Comments
    Windows Azure is a platform that has you covered, whether you need to write software, run software that is already written, or Install and use “canned” software whether you or someone else wrote it. Like any platform, it’s a set of tools...
  • Carpe Datum

    Moving Tables Between Filegroups

    • 2 Comments
    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...
  • Carpe Datum

    Simplified SQL Server Licensing

    • 1 Comments
    I run into people all the time that are confused about SQL Server licensing. Now I'm no licensing expert - not by a long shot - and you SHOULD NOT take this post as authoritative in any way. I don't own the licensing story for Microsoft, not even a little...
  • Carpe Datum

    Microsoft Windows Azure Disaster Recovery Options for On-Premises SQL Server

    • 1 Comments
    One of the use-cases for a cloud solution is to serve as a Disaster Recovery option for your on-premises servers. I’ll explain one particular use-case in this entry, specifically using Windows Azure “IaaS” or Virtual Machines as a Recovery...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Index Usage Statistics: [DatabaseName]

    • 2 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears...
  • Carpe Datum

    Windows Azure Best Practices: Affinity Groups

    • 0 Comments
    When you create a Windows Azure application, you’ll pick a subscription to put it under. This is a billing container - underneath that, you’ll deploy a Hosted Service. That holds the Web and Worker Roles that you’ll deploy for your applications...
  • Carpe Datum

    Quote of the Day: On Internet Comments

    • 0 Comments
    Congress should pass a law restricting public comment on the Internet to individuals who have spent a minimum of one hour actually accomplishing a specific task while on line. - Andy Grove
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Server Dashboard

    • 6 Comments
    I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS). (Note: These reports only work against SQL Server 2005 and higher. They don’t run against the lower versions because those don’t have all the management...
  • Carpe Datum

    Free "Basic Training" for SQL Server

    • 2 Comments
    I answer a lot of questions about SQL Server - on forums, in newsgroups, in presentations and so on - and many are "101", or basic questions. That's great! I don't have a problem with that at all - I enjoy helping someone that is new to SQL Server learn...
  • Carpe Datum

    Backup those keys, citizen

    • 0 Comments
    Periodically I back up the keys within my servers and databases, and when I do, I blog a reminder here. This should be part of your standard backup rotation – the keys should be backed up often enough to have at hand and again when they change. The first...
  • Carpe Datum

    You probably have enough

    • 7 Comments
    This a decidedly non-technical post, and even a little preachy. I post it here because you, the technical professional, are the perfect audience for it. I have enough stuff. I never think so, of course, but I do. I don’t consider myself rich...
  • Carpe Datum

    Windows Azure Myths

    • 11 Comments
    Windows Azure is part of the Microsoft "stack" - the suite of software and services we offer. Because we have so many products in almost every part of technology, it's hard to know everything about all parts of what we do - even for those of us who work...
Page 2 of 40 (1,000 items) 12345»