September 2009 - Posts

• Using PowerShell to script foreign key creation statements

  In my previous post on using T-SQL to script create statements for foreign keys, Chad Miller suggested using PowerShell instead and provided the required script. PowerShell is a SQL Server 2008 feature. I did think about using PowerShell before posting Read More... Posted Sunday, September 20, 2009 4:52 PM by John Paul Cook | 0 Comments

• Script to create all foreign keys

  Here's a script that generates a script to drop or create all of the existing foreign keys in a database. There are similar published scripts, but the ones I tried had bugs. If you find any errors in this script, let me know and I'll fix it. A much simpler Read More... Posted Thursday, September 17, 2009 7:00 PM by John Paul Cook | 8 Comments

• Script to create all primary keys

  Here's a script that generates a script to drop or create all of the existing primary keys in a database. There are similar published scripts, but the ones I tried had bugs. If you find any errors in this script, let me know and I'll fix it. Thanks to Read More... Posted Wednesday, September 16, 2009 3:22 PM by John Paul Cook | 3 Comments

• Enabling Sound on Hyper-V

  Hyper-V does not provide a virtual audio device. Look at the screen capture of Virtual Machine Connection and a Windows 7 vm. As indicated by the X over the speaker icon, audio is not enabled. Additionally, Device Manager shows that although there are Read More... Posted Monday, September 14, 2009 11:58 PM by John Paul Cook | 12 Comments

• Update on Windows 7 bios problems

  Microsoft sent me an updated ASUS bios (1902) to solve my problem of hardware virtualization not being enabled after resuming from sleep mode. This was an unexpected pleasant surprise after receiving this email from ASUS yesterday: Dear Valued Customer, Read More... Posted Tuesday, September 01, 2009 7:59 AM by John Paul Cook | 0 Comments Filed under: virtualization, Windows 7