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...

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...

Intel Xeon E5-2600 Series Processors Released

Yesterday, Intel finally released the much anticipated Xeon E5-2600 family of processors, also known as Sandy Bridge-EP. This is a...

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...

Physical or Virtual

Today I get to share something that has been on my someday list for quite some time.  I have planned...

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...

PowerPivot 2012 RTM Release

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

Moving MSDB to new location

In recent past we have a situation where in we required to move MSDB, Model and Master databases to new...

SQL Server 2012 RTM. Translation: SQL 12 is out now! (Virtual Launch event update)

Originally published March 6, now with Post-launch updates.
Just a quick note for you today: Microsoft announced that SQL Server 2012...