I found 30 out of 33, enough to solve the second page. And the answer to the question is, "Generally no!" Thanks, great fun and educational!

Power BI and Enterprise Gateway to on-prem

Power BI Desktop

M language

SSAS Tabular

SSIS/BIML

SQL 2016 SSRS/SSAS/AG'S

Azure SQL Database

Azure SQL VM's

Try this code...

USE [master]

GO

CREATE PROCEDURE [dbo].[dba_rpt_SQL_Files_Report]

AS

/*

By Norm Enger - 2007 - http://thesqlguy.wordpress.com/

Reports on the file info for all dbs on a SQL instance, SQL 2000 and above

EXEC dba_rpt_SQL_Files_Report

*/

SET...

I happen to be in a very favorable position that allows me to live and work remotely (telecommute) from my home in Tucson, AZ, to my office in Dalton, GA....

The below stored proc will differentiate between orphan users and and not include those created with the "WITHOUT LOGIN" clause in 2005.

USE master

GO

IF OBJECT_ID('rpt_security_detect_db_orphans') IS NOT NULL

DROP PROCEDURE [dbo].[rpt_security_detect_db_orphans]

GO

CREATE PROCEDURE...

See my script and RS report here which will display all the information for all databases on a server in one report.

There is no report header region per se. The header is essentially whatever you put at the top of the report, before anything else. It could be an image or...

This technique will work nicely. See the topics in BOL for VIEW DEFINITION for more explanation.

At a database level:

USE [myDb]

GRANT VIEW DEFINITION TO myUser

Or at the SQL instance level, for...

From BOL: EXEC sp_renamedb N'Accounting', N'Financial'

n type fields (nchar, nvarchar, ntext) are unicode type, are twice as many bytes to store the same number of characters. So only use if you need to store international...

According to the readme that comes with the SQL Server 2005 June CTP, you can use Visual Studio 2005 Beta 2, but you must install SQL first, then VS. I...

If you have Visual Studio, save your sql in QA as an .sql file and open it up in Visual Studio. The file will then print with syntax coloroing from...

Try this link for the master db:

http://www.databasejournal.com/features/mssql/article.php/3379901