Browse by Tags

Tagged Content List
  • Blog Post: List SQL Server Instances using the Registry

    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, find the instances when they are off and so...
  • Blog Post: Backup Meta-Data

    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 out the script that it runs and modified it to this...
  • Blog Post: System Variables, Stored Procedures or Functions for Meta Data

    Whenever you want to know something about SQL Server’s configuration, whether that’s the Instance itself or a database, you have a few options. If you want to know “dynamic” data, such as how much memory or CPU is consumed or what a particular query is doing, you should be using the Dynamic Management...
  • Blog Post: Tracking SQL Server Time

    In the past few blog posts I’ve showed you how to use several methods to track things in SQL Server. You can use the “tags” to the right of this post here at this site to list things like PowerShell, Performance Tuning and so on. Now that you’re armed with these tools, what should you track? Well, one...
  • Blog Post: Color Me Corrected – Will the REAL sysobjects please stand up?

    A few days ago I posted a way to look at the Dynamic Management Views (DMV’s) using a query, which I then copy and paste into the Help viewer’s Index tab to learn more. Well, my good friend and Colleague, Cliff, pointed out that I was using the older sysobjects system table. Well, of course this is a...
  • Blog Post: T-SQL to Find Physical and Logical Processors

    I ran into a licensing question the other day on Physical versus Logical Processors. Happily, Microsoft only charges you for Physical sockets - which you can find with this query: SELECT cpu_count / hyperthread_ratio AS PhysicalCPUs FROM sys.dm_os_sys_info And then this query will show you how...
  • Blog Post: Database Diagram Error "Cannot Create Objects"

    If you've ever tried to design a new database diagram and gotten a "cannot create objects" error, you've probably noticed the correction steps to use the ALTER AUTHORIZATION statement to change the owner. This happens a lot to me - I'll be on the corporate net when I create a database, and...
  • Blog Post: Listing the Central Management Servers Programmatically

    I don't normally advocate hitting the system tables in any database with direct queries, preferring instead to use views or functions that the vendor provides. But so far I haven't been able to find the view or function that would return the list of servers in the Central Management Servers group on...
  • Blog Post: Check that database before you restore it...

    I'm on my way to the city of Seattle this morning on the train and I ran across an issue with a database restore. I've been working with Service Broker and then put it out of my mind. I then backed up said database and restored it the same instance as a test. Then things started going awry... Then this...
  • Blog Post: Versioning the Database

    If you write apps that hit a database that you own, then you probably want version control on the database itself. I always script out the initial database, and version that script. I also script the changes, and version those, and then script the entire DB again and version that as well. That allows...
  • Blog Post: Is a Comprehensive Data Map Possible?

    Most of us design a "CRUD" (Create, Read, Update and Delete) matrix for an application's database. And if you are really thorough, you create a data dictionary that shows what data goes where and why. The problem with these documents is that over time more data elements are added (sometimes...
  • Blog Post: SQL Server Management Studio Standard Reports – The Full List

    I've completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to them from the tags, but I thought I would post a list of them all here with the links. I hope that you've been able to put some of this information into use in your organization. A lot of work went...
  • Blog Post: SQL Server Management Studio Standard Reports – Top Jobs

    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu that appears, click the Standard Reports , and...
  • Blog Post: Checking Your System

    In most checklists for SQL Server, including the one I explained on my last Podcast , you're told to "check your system". In fact, most instructors and DBA Experts will not look kindly on you if you don’t. But what does that mean? Well, I’ll probably do a longer Podcast on that, but here are some quick...
  • Blog Post: SQL Server Management Studio Standard Reports – Job Steps Execution History

    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu that appears, click the Standard Reports , and...
  • Blog Post: SQL Server Management Studio Standard Reports – Notification Services - General

    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that appears, click the Standard Reports , and then select...
  • Blog Post: SQL Server Management Studio Standard Reports – Number of Errors

    I'm continuing my series on the Standard Reports in SQL Server Management Studio and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that appears, click the Standard Reports , and then select...
  • Blog Post: SQL Server Management Studio Standard Reports – Tasks

    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the Management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that appears, click the Standard Reports , and then select...
  • Blog Post: Time-based Optimization

    One of the primary jobs of both developers and DBAs is optimization, or its more common name, performance tuning. Lots of the management tools improvements for SQL Server 2008 are aimed at performance, such as the new activity Monitor. Using the tools such as Management Studio, Profiler, Tuning...
  • Blog Post: SQL Server Management Studio Standard Reports – Resource Locking Statistics by Logins

    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the Security reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Logins node underneath the Security node. From the menu that appears, click the Standard...
  • Blog Post: SQL Server Management Studio Standard Reports – Login Failures

    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the Security reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Logins node underneath the Security node. From the menu that appears, click the Standard...
  • Blog Post: SQL Server Management Studio Standard Reports – Login Statistics

    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the Security reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Logins node underneath the Security n ode. From the menu that appears, click the Standard...
  • Blog Post: SQL Server Management Studio Standard Reports –Active Full Text Catalogs: [DatabaseName]

    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, click the Standard Reports , and then select...
  • Blog Post: SQL Server Management Studio Standard Reports –Service Broker Statistics: [DatabaseName]

    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, click the Standard Reports , and then select...
  • Blog Post: SQL Server Management Studio Standard Reports –User Statistics: [DatabaseName]

    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, click the Standard Reports , and then select...
Page 1 of 3 (66 items) 123