SQL Server – sys.master_files and list all database files

Use the system view “sys.master_files”  for a single view of databases and database files.
Instead of using sys.sysfiles  joing to sys.sysdatabases...

SQL Server 2012 (“Denali”): Reporting Services in SharePoint integrated mode

In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took...

SQL Server 2012 Data Mining add-in for Excel 2010 Released

Another release that went without much trumpeting was the SQL Server 2012
Data Mining add-in for Excel 2010.  This has...

SQL Server Database Mirroring (Not Dead Yet)

SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL...

Windows Server 8 Hyper-V Lab boot from VHD

Windows Server 8 Hyper-V Lab boot from VHD

Windows Server 8 Hyper-V Lab boot from VHD

Windows Server 8 Hyper-V Lab boot from VHD

Windows Server 8 Hyper-V Lab boot from VHD

Windows Server 8 Beta is out, check this video to use existing windows laptop/desktop to build VHD bootable Windows server...

Choosing the Right Microsoft Reporting Technology Part 2: Excel

This post is a continuation of a series started to help you understand each of the Microsoft presentation layer tools...