• Carpe Datum

    SQL Server Best Practices: User-Defined Schemas

    • 1 Comments
    Schemas are a feature that gained wide use in SQL Server 2005. They are essentially containers that allow some objects to be grouped together. Actually, there have always been schemas in SQL Server, it's just that we only exposed one - called "dbo"...
  • 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 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

    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

    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

    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

    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

    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

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

    • 2 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

    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

    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

    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

    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

    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

    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

    But what can I *do* with Windows Azure? Create (Free) Websites and Applications

    • 8 Comments
    f you want to know more about Windows Azure, how it works, the components, or more about the entire platform, I’ve written about that here: http://blogs.msdn.com/b/buckwoody/archive/2012/06/13/windows-azure-write-run-or-use-software.aspx But…...
  • 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

    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

    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

    Don’t mess with the system databases in SQL Server, or Error: 916

    • 7 Comments
    Note: If you’re reading this more than a few months away from July of 2010, do more research. Never trust an old blog as gospel on anything, including my entries. Always refer to Books Online for the authoritative answer, and if it’s wrong...
  • Carpe Datum

    How Does the Cloud Change a Systems Administrator's Job?

    • 2 Comments
    I recently posted a blog entry on how cloud computing would change the Systems Architect’s role in an organization , and another on how the cloud changes a database administrator's job . This time I'll cover a few of the changes the cloud brings...
  • 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

    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...
Page 2 of 41 (1,022 items) 12345»