• 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

    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

    SQL Server Management Studio Standard Reports – Disk Usage by Table/Top Tables

    • 6 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio . I’m covering two reports at once, since they have the same columns and output, but show the data from a different perspective. These two reports will help you find out...
  • 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

    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

    Management and Monitoring Tools for Windows Azure

    • 6 Comments
    (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...
  • 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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    Creating a Windows Azure Virtual Machine - the RIGHT Way

    • 0 Comments
    Windows Azure has added Infrastructure-as-a-Service (IaaS), the ability to deploy, run and manage Virtual Machines, to its growing list of services . You can create Virtual Machines from a gallery, upload them from images you create locally on Hyper-V...
  • 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...
  • Carpe Datum

    SQL Server Books Online

    • 15 Comments
    Most of us have stacks of books on our shelves about SQL Server. But you also have an amazing resource that you get for free with SQL Server, or even on the web: Books Online. Some of you might not know how SQL Server Books Online is put together and...
  • 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

    Cloud Computing In Action: How I work with Live Mesh, SkyDrive, and Office Live Workspace

    • 11 Comments
    Recently I had an tweetversation with a couple of friends on some confusion around two of our products: SkyDrive and Live Mesh . Like most of our software, there’s no single way to do things. That can be a strength or it can cause that confusion. They...
  • 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

    Cloud Computing Patterns: Using Data Transaction Commitment Models for Design

    • 0 Comments
    There are multiple ways to store data in a cloud provider, specifically around Windows and SQL Azure. As part of a “Data First” architecture design, one decision vector – assuming you’ve already done a data classification of the...
  • 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...
Page 2 of 40 (997 items) 12345»