Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)
Friday, May 29, 2009 8:28 PM

Hey, Scripting Guy! How Can I Use Windows PowerShell to Run Daily Checks on My SQL Server 2008 Servers?

Hey, Scripting Guy! I have several items I have to check daily on my SQL 2008 servers. I currently have some VBScripts that do many of my tasks, but there are some new things I want to do. I figure that Windows PowerShell would be easier. Do you have
Posted by ScriptingGuy | 0 Comments
Thursday, May 28, 2009 8:27 PM

Hey, Scripting Guy! How Can I Use the SQL Server Mini-Shell Version of Windows PowerShell?

Hey, Scripting Guy! One thing I do not understand is why the SQL Server team wrote its own version of Windows PowerShell. I thought Windows PowerShell was supposed to standardize things. But the SQL Server team has one version of Windows PowerShell, the
Posted by ScriptingGuy | 0 Comments
Wednesday, May 27, 2009 8:27 PM

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

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
Posted by ScriptingGuy | 0 Comments
Tuesday, May 26, 2009 8:26 PM

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

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 Hi JJ, For some unknown reason,
Posted by ScriptingGuy | 0 Comments
Friday, March 27, 2009 9:37 PM

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (03/27/09)

Determining if SQL Is Installed; How to Read Paired Information into a Dictionary Object Hey, Scripting Guy! Being an avid reader of your columns for the last several years has been a blast. I wrote you once before but with no success (in terms of a reply,
Posted by ScriptingGuy | 1 Comments
Monday, October 16, 2006 6:44 PM

How Can I Create a Table in a SQL Server Database?

Hey, Scripting Guy! How can I create a table in a SQL Server database? -- FD Hey, FD. And thanks: you’ve saved the Scripting Guys! Or, at any rate, you’ve saved the Scripting Guy who writes this column. As it turns out, this Scripting Guy is getting ready
Posted by ScriptingGuy | 0 Comments
Thursday, October 05, 2006 12:38 PM

How Can I Tell Whether a Specified Table Exists in a SQL Server Database?

Hey, Scripting Guy! How can I tell whether a specified table exists in a SQL Server database? -- LL Hey, LL. Well, as it turns out it’s absolutely impossible to tell whether a specified table exists in a SQL Server database. So, sorry, time to go back
Posted by ScriptingGuy | 0 Comments
Thursday, September 14, 2006 11:58 AM

How Can I Get a List of All the Databases on a SQL Server Computer?

Hey, Scripting Guy! How can I get a list of all the databases on a SQL Server computer? -- ER Hey, ER. Before we answer your question, we’d like to take a moment to offer our opinions on all the major – and controversial – issues of the day. We can do
Posted by ScriptingGuy | 0 Comments
 
Page view tracker