Physical or Virtual

Today I get to share something that has been on my someday list for quite some time.  I have planned on getting a solution that involves TSQL to help...

PowerPivot 2012 RTM Release

Somewhat overshadowed, for obvious reasons, by the big RTM release of SQL Server 2012 was the RTM release of PowerPivot...

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 Beta is out, check this video to use existing windows laptop/desktop to build VHD bootable Windows server...

Windows Server 8 Hyper-V Lab boot from VHD

Windows Server 8 Hyper-V Lab boot from VHD