• Carpe Datum

    Quote of the Day: The Unreasonable Man

    • 5 Comments
    "The reasonable man adapts himself to the world; the unreasonable one persists to adapt the world to himself. Therefore all progress depends on the unreasonable man." - George Bernard Shaw
  • 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 2008 Object Search

    • 5 Comments
    At the top of the Object Explorer Details (OED) panel, which you can show by pressing F7 in SQL Server Management Studio, you'll find a "Search" text box. If you want to find an object in a particular database, just click on any database object...
  • Carpe Datum

    ERD Designer

    • 5 Comments
    So what are you using for an Entity Relationship Diagran (ERD) tool? I'm teaching a class at the University of Washington and we're doing that part of the class now. I normally use Visio, but find it a little less than perfect for this. And some of the...
  • Carpe Datum

    Scripts, Blogs, and Learning

    • 5 Comments
    I received an e-mail from a reader asking if I could post a link to a script he's documented in an article. I'm always happy to do that, but there are some things you should know about ANY script you find on the web, and while I'm at it, for how you read...
  • Carpe Datum

    Free T-SQL Beautifier

    • 5 Comments
    I do love me some good-looking code. Sure, the syntax has to be there, and the code has to be correct and all that, but I'm old-school, and I think pretty code is easier to read. I'd love to have a "code beautifier" built right in to SQL Server...
  • Carpe Datum

    Script of the day: Count all objects in a database

    • 5 Comments
    This script counts all of your objects in the database, at least the ones stored in the sysobjects table. Some objects (such as jobs) don't show up there - one day I'll add those: /* usc_DBA_Count_Objects.sql Author: Buck Woody Purpose: Shows a quick...
  • Carpe Datum

    Bring Back the TaskPad!

    • 5 Comments
    I mentioned a few posts back that a lot of people asked us to bring back the Query Analyzer, since many just want to jump into the query tool and start typing. I explained that you can get the same behavior – even better, in mu opinion – by just setting...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Performance – Top Queries by *

    • 5 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio . Today I'm covering four reports at a time – the performance reports that are broken down by average and total times. The reason I’ll cover all four of them is that they...
  • Carpe Datum

    Transport Systems

    • 5 Comments
    I’ve worked on a couple of SAP systems, both the “R” flavors and the BW product. Although I had my learning challenges with them, there was one construct there I really liked. It was the transport mechanism. Basically what this involved was setting...
  • Carpe Datum

    A Few Links to SQL Server 2008 Resources

    • 5 Comments
    As I was presenting at TechReady yesterday on the new SQL Server 2008 features that will directly affect Microsoft System Center, I was asked a few times about some resources where people could go to learn more about it. I thought I would share that here...
  • Carpe Datum

    Where should the tools be?

    • 5 Comments
    I've got another question for you - where should the tools be? Let me explain. Most of the time when you connect to SQL Server, you open SQL Server Management Studio (SSMS) on a client machine and then type in the name of a server somewhere on the...
  • Carpe Datum

    SQL Injection Attacks

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

    "Hey.....Hey...Hey...Don't be mean. You don't have to be mean."

    • 5 Comments
    Well, I had another post I had planned for today, but after reviewing some customer bugs and some newsgroups where I give out free help (on my own time, mind you) I had to change my mind. I've seen this behavior in grocery stores, online forums, and bug...
  • Carpe Datum

    MOM 2005 Management Pack for SQL Server 2008 is Available

    • 5 Comments
    We've completed the work on the Microsoft Operations Manager (MOM) "Management Pack" for SQL Server 2008. MOM allows you to monitor and manage Microsoft and even other vendor's servers, so if you have this software in your shop you can download...
  • Carpe Datum

    Learn to Install and Upgrade to SQL Server 2008

    • 4 Comments
    As I mentioned yesterday, we've shipped SQL Server 2008. I highly recommend you get it and install it on your testing machines right away. But before you do anything on your production systems, make sure you check out this free webcast: http://msevents...
  • Carpe Datum

    Microsoft Loves DBA's

    • 4 Comments
    I wanted to show you some of the things the group has been working on. You might not see all these features in your latest CTP, but they are scheduled for the Final Release. I hope you like the list! Title Component Advantage What's the big deal? Connection...
  • 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

    The Organizational DBA

    • 4 Comments
    I posted another entry about a question I received as to the most effective management processes are for a DBA, and in that post I mentioned that the answer was "it depends". There are a lot of ways to slice and dice the information, but I think a convenient...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Transaction Log Shipping Status

    • 4 Comments
    We’re in the final server-level reports in this series of the Standard Reports that ship with SQL Server Management Studio (SSMS) . Don’t worry, there are plenty more reports coming in the database and other objects; but this one is the last of the reports...
  • Carpe Datum

    Why does a light switch move up to turn on the light? (And why do we say "turn on" the light?)

    • 4 Comments
    I read a great book last night called "The Psychology of Everyday Things" by Donald Norman. It's actually an older book that explores what works and what doesn't from a usability perspective. That's interesting to my group since we are in charge of the...
  • Carpe Datum

    Script of the Day - Find the Cores on a System

    • 4 Comments
    Sure, you can get the number of processors fairly easily ffrom SQL Server. But did you know you can also get the number of actual cores as well? This little gem works with SQL Server 2005: SELECT cpu_count/hyperthread_ratio AS sockets FROM sys.dm_os_sys_info;...
  • Carpe Datum

    Secure by design

    • 4 Comments
    Whenever you're developing a new application that hits SQL Server, make sure you design in security from the outset. In the new releae of the Community Tehcnal Preview (CTP) for SQL Server 2008, you'll notice that there are several new improvements in...
  • Carpe Datum

    Quote of the Day - Software Development and Miracles

    • 4 Comments
    I was sent this week's quote by my good friend Chris Pelley. Not sure who it is attributed to, but it sure sounds right to me: "Walking on water and developing software from a specification are easy if both are frozen."
  • Carpe Datum

    Quickly Locate Text in a Query Window in SSMS

    • 4 Comments
    Wow - long title.   Anyway, my good friend Bill Ramos and I were chatting just the other day. He's a the guy at Microsoft that took my old responsibilities for SQL Server Management Studio (SSMS), and we were swapping tips and tricks. He showed me...
Page 4 of 40 (1,000 items) «23456»