Full server documentation

This script is intended for SQL Server professionals that needs to have a quick snapshot from an environment with all relevant information about the databases. It's a compilation from multiple scripts, and works in SQL Server 2000.I think that works on 7.0 too, but may have some compilation issues.Don´t forget to see the section MANUAL […]

5 (1)

2003-04-28

4,639 reads

Blogs

Azure Databricks to Power BI

By

A very common approach is to query data straight from Databricks via Power BI....

SQLSaturday #1000! Join Oregon Virtually this Saturday

By

Honored to be a part of not just SQLSaturday #1000, but the long proud...

Azure DevOps–Reconfiguring an Agent

By

This post looks at how to re-configure a local Azure DevOps agent when you...

Read the latest Blogs

Forums

Unable to get the last date from the query

By gazy007

Hi, Sorry if I couldn't find the correct forum to post my question. I...

SQL Case statement

By mtz676

select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as JobStatus...

How to Refresh DB in High availability and open DB later after applying Tlog

By santosh.mane

Hi,   We are planning to migrate our SQL server 2012 production database to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers