Tag: SQL

  • Install Windows PowerShell for SQL 2008 R2

    I was recently installing SQL Server Management Studio Express 2008 R2 and the installation failed temporarily because Windows PowerShell wasn’t installed. There wasn’t a link, so I thought a quick search would get me the file on Microsoft’s website. I was wrong. I found plenty of documentation and getting started guides for Windows PowerShell, but […]

  • Excel Macro to Generate SQL Insert

    I am in the process of creating a database of County information, and I needed to insert several thousand records. I was able to get the data into Excel, but now I needed to write an SQL Insert statement to get the records into my database. SQL wizards, I’m sure you know a more efficient […]