Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

databases - Scripting Blog [archived]

Hey, Scripting Guy! How Does Windows PowerShell Make It Easier to Work with SQL Server 2008?

May 27, 2009 May 27, 2009 05/27/09
ScriptingGuy1
(image) Hey, Scripting Guy! I am a SQL database administrator, and in the past I have enjoyed using VBScript for many tasks related to my computers that are running SQL Server. What capabilities does Windows PowerShell provide to make working with SQL Server 2008 easier?- OS(image) (image) Hi OS, Ed is neck deep in work for the 2009 Summer...

Hey, Scripting Guy! Why Should I Use Windows PowerShell with SQL Server 2008?

May 26, 2009 May 26, 2009 05/26/09
ScriptingGuy1
(image) Hey, Scripting Guy! I recently saw that SQL Server 2008 has Windows PowerShell built into it. I looked at, but I am not really impressed. Why should I be interested in using Windows PowerShell with SQL Server 2008?- JJ (image) (image) Hi JJ, For some unknown reason, it has turned cool down here in Charlotte, North Carolina, in the ...

Hey, Scripting Guy! How Can I Tell Which Tables and Columns Are in a Database Without Opening It?

February 18, 2009 Feb 18, 2009 02/18/09
ScriptingGuy1
(image) Hey, Scripting Guy! Is there a way to figure out which tables and columns are in a database without having to open it up?- DT(image) (image) Hi DT, The Impressionists are back in Chicago! For the past six months, they were hibernating down in Ft. Worth, Texas, in the United States. But now they are back. In true Ferris Bueller style...

Hey, Scripting Guy! How Can I Create a Database with More Than One Table?

February 17, 2009 Feb 17, 2009 02/17/09
ScriptingGuy1
(image) Hey, Scripting Guy! Being able to create a database from a script is nice, and I appreciated your article yesterday. But I need to have a database with more than one table in it. Obviously this can be done, but I am at a loss as to how to go about it. I am not a real programmer; do you have any tips for me?.- GF(image) (image) Hi GF...

Hey, Scripting Guy! How Can I Use Windows PowerShell to Create an Office Access Database?

February 16, 2009 Feb 16, 2009 02/16/09
ScriptingGuy1
(image) Hey, Scripting Guy! I have looked everywhere, and I cannot find a script that will create a new Microsoft Office Access database, and automatically add a new table and columns to it. If you had such a thing in Windows PowerShell it would be even better. I know it is probably too much to ask, but could you, would you write such a ...