External Article

Using Operations Manager Reports to Validate Your Uptime

Operations Manager has a number of reports to help you monitor the uptime of your applications, but reporting can be difficult to learn until you understand all the different options, the different parameters possible, and the way the Operations Manager health model is structured. Firstly, you need a clear idea about the way that your organization defines 'uptime'. then you can start your reports from any of the views in the Monitoring tab, and then add or remove objects to get the report you need.

SQLServerCentral Article

Calculating Age

T-SQL calculations can get tricky at times, and since you often work with multiple rows, it's good to be exact in your data manipulation. New author Lynn Pettis brings us an article about calculating ages.

SQLServerCentral Editorial

Downtime

One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.

Blogs

Database AI Agents: The Read-Only Rule

By

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Creating a SQL Stored Procedure to Load a SCD2

By

This is a blog that I am writing for future me and hopefully it’ll...

Funny Money: #SQLNewBlogger

By

While wandering around the documentation looking for some Question of the Day topics, I...

Read the latest Blogs

Forums

Pro SQL Server Internals

By Site Owners

Comments posted to this topic are about the item Pro SQL Server Internals

SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry

By Terry Jago

Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...

Running SQLCMD II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Running SQLCMD II

Visit the forum

Question of the Day

Running SQLCMD II

I run this command to start SQLCMD:

sqlcmd -S localhost -E -c "proceed"
At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version
2> go
What happens?

See possible answers