• Carpe Datum

    Windows Azure and SQL Azure Use Cases

    • 6 Comments
    The key to effectively leveraging “Cloud Computing” or more accurately, Distributed Computing architectures like Windows and SQL Azure is to implement them where they make the most sense. This is actually good advice for any computing paradigm...
  • Carpe Datum

    Why Use PowerShell with SQL Server?

    • 1 Comments
    If you've never read the "scripting guys" at Microsoft, they are a hoot. Ed Wilson and Craig Liebendorfer do a fantastic job of writing each week and helping with scripting of all kinds, including PowerShell. Well, this week they appointed me...
  • Carpe Datum

    Windows Azure Security Review

    • 0 Comments
    Current as of 08/01/2011 - Check the Resources listed below for more up-to-date information on this topic Background: Security for any computing platform involves three primary areas: Principals (users or programmatic access to an asset or other program...
  • Carpe Datum

    Windows Azure Database (SQL Azure) Development Tip

    • 0 Comments
    When you create something in the cloud, it's real, and you're charged for it. There are free offerings, and you even get free resources with your Microsoft Developer Network (MSDN) subscription, but there are limits within those. Creating a 1 GB database...
  • Carpe Datum

    Using Hadooop (HDInsight) with Microsoft - Two (OK, Three) Options

    • 0 Comments
    Microsoft has many tools for “Big Data”. In fact, you need many tools – there’s no product called “Big Data Solution” in a shrink-wrapped box – if you find one, you probably shouldn’t buy it. It’s...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Resource Locking Statistics by Object: [DatabaseName]

    • 1 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 Learning Plan - Other Features

    • 0 Comments
    This is one in a series of posts on a Windows Azure Learning Plan. You can find the main post here . This one deals with the Application Fabric for Windows Azure. It serves three main purposes - Access Control, Caching, and as a Service Bus. ...
  • Carpe Datum

    Read the SQL Server Error Log with PowerShell

    • 3 Comments
    This script uses a native client call, so you can use it on any machine that has PowerShell installed along with the SQL Server client software. As always, only run this script on a test system until you understand what it does, and of course you'll need...
  • Carpe Datum

    DevOps for Windows Azure

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

    PASS 2008 Conference - Day Five

    • 8 Comments
    Today was the final day of the conference, but I had a packed house for our discussion on PowerShell and SQL Server. I wanted to blog about one concept I covered in the demo: Why would I use PowerShell when I have SSIS, stored procs, batch files and other...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Schema Changes History: [DatabaseName]

    • 4 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 2008 CTP4 Virtual Machine Available

    • 1 Comments
    You can find the latest release of SQL Server 2008 in a convenient Microsoft Virtual Machine format here: · Microsoft Connect SQL Server · Microsoft Download Center Enjoy!
  • Carpe Datum

    Windows Azure Learning Plan - SQL Azure

    • 0 Comments
    This is one in a series of posts on a Windows Azure Learning Plan. You can find the main post here . This one deals with SQL Azure. There are a series of videos here you can use for a complete overview: Getting Started: SQL Azure at a Glance...
  • Carpe Datum

    How Does the Cloud Change a Developer's Job?

    • 0 Comments
    I've recently posted a blog on how cloud computing would change the Systems Architect’s role in an organization , another on how the cloud changes a Database Administrator's job , and the last post dealt with the Systems Administrator . In this...
  • Carpe Datum

    Passed 70-432 - Is that Important?

    • 3 Comments
    I don't like to read technical blogs that have a lot of personal info in them. Sure, I'll rant from time to time, or talk about a technical book I've read and so on, but most people really don't care about your new cat or how you're feeling today. Keep...
  • Carpe Datum

    SQL Server Management Studio Startup Options

    • 1 Comments
    I get asked all the time if there is a way to start up SQL Server Management Studio (SSMS) using a certain connection, or to go directly to a certain script file. There are many options you can set in the "Tools | Options" menu for startup, but you can...
  • Carpe Datum

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

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

    Should I learn Cloud Computing Next?

    • 3 Comments
    My previous role at Microsoft was in the SQL Server team. I spent quite a bit of time there, and had some really great experiences. I was able to travel and speak as well as doing my “regular” job in the programming team, so I got to meet a lot of people...
  • Carpe Datum

    SQL Server Best Practices: File Layouts (Revisited)

    • 4 Comments
    In a previous "SQL Server Best Practice" post , I made reference to file layouts and where various file types should go. I got a comment there that I felt deserved another post. The question was: "...7 individual drives? If this is correct do...
  • Carpe Datum

    List SQL Server Instances using the Registry

    • 0 Comments
    I read this interesting article on using PowerShell and the registry , and thought I would modify his information a bit to list the SQL Server Instances on a box. The interesting thing about listing instances this was is that you can touch remote machines...
  • Carpe Datum

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

    • 2 Comments
    In a previous post , I started the process of my study for the 70-432 exam. I'm working on that (as I have time) and I promised to post my notes here. My notes aren't totally inclusive, they are just things I found interesting as I was doing my reading...
  • Carpe Datum

    SQL Server Best Practices: File Layouts

    • 5 Comments
    In a previous post, I mentioned that you should use Filegroups and I talked a little about those. In this post, the best practice I'll point out is where those files should live. As a general rule of thumb, more "spindles" in a database are better...
  • Carpe Datum

    The Database Design Process

    • 3 Comments
    I need your help. I know how I create databases, and I’ve watched a lot of other data professionals follow their own processes for that, but I want to know how YOU do it. I’ve written about the process I follow for a complete database design on...
  • Carpe Datum

    Big Data and the Cloud - More Hype or a Real Workload?

    • 4 Comments
    Last week Microsoft announced several new offerings for “Big Data” - and since I’m a stickler for definitions, I wanted to make sure I understood what that really means. What is “Big Data”? What size hard drive is that? After all, my laptop has 1TB of...
  • Carpe Datum

    The Top-Five Most Valuable Development Team Positions

    • 7 Comments
    In many organizations, there’s a push to save cost. “Cost” is an integral part of a profit-and-loss statement in the organization. Even if you work in a non-profit organization, cost control is central. Of course, you can take cost-control...
Page 5 of 40 (994 items) «34567»