• 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

    How Does the Cloud Change a Systems Architect’s Job?

    • 1 Comments
    I know - I said I didn't like the "cloud" term, but my better-phrased "Distributed Systems" moniker just never took off like I had hoped. So I'll stick with the "c" word for now, at least until the search engines catch up with my more accurate term. ...
  • Carpe Datum

    SQL Server Management Studio Projects and Solutions

    • 0 Comments
    Inside SQL Server Management Studio (SSMS), there's a feature I don't see used a great deal. It's called a "Project" and in effect it's just a way to bundle files, connections and scripts into a single package that you can navigate within SSMS...
  • Carpe Datum

    Code that Writes Code - A Good Idea or Not?

    • 1 Comments
    I’m a big fan of code that writes code – most of the time. For instance, whenever you use the “templates” feature in SQL Server Management Studio (SSMS) or the Maintenance Wizard, you’re using code that writes other code. There’s even a trick of writing...
  • Carpe Datum

    Create Outlook Appointments from PowerShell

    • 1 Comments
    I've been toying around with a script to create a special set of calendar objects in Outlook that show when my SQL Server Agent Jobs are scheduled to run. I haven't finished yet, but I thought I would share the part that creates the Outlook Appointments...
  • Carpe Datum

    Bonus Rant: Conference Speakers and the Golden Rule

    • 20 Comments
    Fair warning: This isn’t a technical post. This is my opinion, and not Microsoft’s. I’ve been a public speaker at events since 1980. Interestingly, even though I’ve done this, it’s never been my paid job. I’ve spoken...
  • Carpe Datum

    Using Perfmon with SQL Server – Part One

    • 0 Comments
    I held a workshop on performance tuning in Portland, Oregon yesterday, and as part of that I mentioned a process I follow for automatically collecting Performance Monitor Counters for a system. I use this data to store a baseline and then subsequently...
  • 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

    Templates for New Query Window

    • 4 Comments
    When I’m in SQL Server Management Studio and I click the “New Query” button, my Query Window comes up like this: /* <ScriptFileName, SYSNAME, ScriptFileName>.sql Purpose: <Purpose, SYSNAME, Purpose> Author: <Author, SYSNAME, Buck Woody>...
  • Carpe Datum

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

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

    PowerShell – Show a Notification Balloon

    • 2 Comments
    In my presentations for PowerShell I sometimes want to start a process (like a backup) that will take some time. I normally pop up a notification “balloon” at the start, and then do the bulk of the work, and then pop up a balloon at the end to let me...
  • Carpe Datum

    Start a SQL Server Agent Job using the SQL Server PowerShell Provider

    • 2 Comments
    Whew!  That’s a mouthfull. Anyway, I thought I would share part of a script I wrote today to help automate (more) from PowerShell. This assumes a few things: that you’re doing this from the SQL Server 2008 PowerShell provider (not just good old regular...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Index Physical 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

    How I Work: A Cloud Developer's Workstation

    • 4 Comments
    I've written here a little about how I work during the day, including things like using a stand-up desk (still doing that, by the way). Inspired by a Twitter conversation yesterday, I thought I might explain how I set up my computing environment. First...
  • Carpe Datum

    Find those rogue SQL Servers in your Enterprise with PowerShell

    • 1 Comments
    I found a great way to check and see if a server has SQL Server installed on it. It uses “WMI”, or Windows Management Instrumentation and PowerShell. It simply interrogates the Services on a system to see if SQL Server is there, whether it...
  • Carpe Datum

    The Top 20 Questions in Database Design

    • 2 Comments
    I'm still re-reading the "Fourth Paradigm" book by Microsoft Research, and one section continues to intrigues me. There's a part where the book explains database design, and puts forth that the most important thing when you're designing large data sets...
  • 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

    Argh! Bring back Query Analyzer!

    • 8 Comments
    Steve Jones, a friend of mine over at sqlservercentral.com, asked me a question the other day that is brought up quite a bit. In earlier versions of SQL Server, we had at least two management tools: Enterprise Manager (EM) and Query Analyzer (QA). EM...
  • Carpe Datum

    How I Work– Working From Home

    • 10 Comments
    I work from home – and I would find it difficult to work any other way. For decades I’ve worked in traditional offices, cubicle-farms, and open-plan work areas. I find them too bright, too loud, too distracting, and in some cases, too depressing to be...
  • Carpe Datum

    SQL Server Standard Reports – Disk Usage: [Database Name]

    • 2 Comments
    We’re in the first of the database-level reports in this series of the Standard Reports that ship with SQL Server Management Studio (SSMS) . To get to these reports, navigate from the server object in Object Explorer, move down to the Databases object...
  • Carpe Datum

    SQL Server Standard Reports – Database: Disk Usage by Partition: [DatabaseName]

    • 2 Comments
    In this continuing series on the Standard Reports in SQL Server Management Studio , we’re now up to the database-level reports. Today I’ll explain another report dealing with space in the database: Disk Usage by Partition: [DatabaseName] . To get to...
  • 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

    Windows 2008 and Replication

    • 2 Comments
    I mentioned in a previous post that I would point out where SQL Server 2008 takes advantage of improvments in Windows 2008 (Check out the "Windows 2008" tag below for that). I just had to share something I got today from the replication team in an e-mail...
  • Carpe Datum

    Slipstreaming SQL Server Installations and the SP1 Controversy

    • 2 Comments
    Yesterday, along with several hundred other folks, I told you that SQL Server 2008 Service Pack 1 was out, and where to download it. I also mentioned that one of the big advantages in it was that you could now do "slipstream" installations....
  • Carpe Datum

    But what can I *do* with Windows Azure? Backups

    • 3 Comments
    If 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…...
Page 4 of 40 (997 items) «23456»