Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » databases   (RSS)
Thursday, August 13, 2009 12:01 AM

Hey, Scripting Guy! Can I Query a Microsoft Access Database with a Windows PowerShell Script?

Hey Scripting Guy! I have a Microsoft Access database that I need to query from a Windows PowerShell script. I have seen a number of VBScript examples, but I cannot find any Windows PowerShell samples. Can you point me in the right direction? I do not
Posted by ScriptingGuy | 0 Comments
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
Wednesday, February 18, 2009 6:15 PM

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

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 Hi DT, The Impressionists are back in Chicago! For the past six months, they were hibernating down in Ft. Worth, Texas, in the
Posted by ScriptingGuy | 1 Comments
Tuesday, February 17, 2009 6:13 PM

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

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.
Posted by ScriptingGuy | 2 Comments
Monday, February 16, 2009 6:12 PM

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

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.
Posted by ScriptingGuy | 1 Comments
Wednesday, January 21, 2009 5:59 PM

Hey, Scripting Guy! How Can I Back Up a Database’s Data Folder While the Database Is Running?

Hey, Scripting Guy! I have a problem. I am trying to script the backup of a data folder used by our database application. The problem is that as long as the database service is running, the files that are used are locked, and I am unable to copy them.
Posted by ScriptingGuy | 0 Comments
Monday, January 21, 2008 6:59 PM

Hey, Scripting Guy! How Can I Import Multiple Worksheets into an Access Database?

Hey, Scripting Guy! I’m trying to import a spreadsheet into an Access database. The problem is that the spreadsheet has multiple worksheets. I can import the first worksheet without any problem, but I can’t figure out how to import all the other worksheets
Posted by ScriptingGuy | 0 Comments
Tuesday, January 15, 2008 6:51 PM

Hey, Scripting Guy! How Can I Add a Record to a Database Using Windows PowerShell?

Hey, Scripting Guy! Awhile back you showed us how we could use Windows PowerShell to retrieve data from a Microsoft Access database. I’m now trying to add data to a database using PowerShell, but I can’t get the script to work. Any chance you could show
Posted by ScriptingGuy | 0 Comments
Thursday, January 03, 2008 6:18 PM

Hey, Scripting Guy! How Can I Delete a Set of Records From an Access Database?

Hey, Scripting Guy! We have an Access database that we use to keep track of resources that are associated with all of our projects. Periodically I need to go into the database and delete all the records tied to a particular project. Is there any way that
Posted by ScriptingGuy | 0 Comments
Wednesday, October 03, 2007 2:14 AM

Hey, Scripting Guy! How Can I Retrieve the Field Size and a Sample Record For All the Tables and Fields in an Office Access Database?

I recently read an article of yours that showed me how I can retrieve the names of all the tables in an Access database, along with a list of all the fields in each table and the data type of each of those fields. That’s a really useful script, but it
Posted by ScriptingGuy | 0 Comments
Monday, July 09, 2007 9:38 PM

How Can I List All the Fields and Data Types in an Access Database?

Hey, Scripting Guy! In a previous column you showed us how to list all the tables in an Access database. How can I list all the fields in those tables, along with the data type of each field? -- MF Hey, MF. As you may or may not know, there’s a Microsoft
Posted by ScriptingGuy | 0 Comments
Tuesday, June 05, 2007 8:29 PM

How Can I Append a Value to a Specified Field For Each Record in a Database?

Hey, Scripting Guy! How can I add the letter s to the end of a specified field for each record in an Access database? -- A Hey, A. It’s day 2 of TechEd 2007 and the Scripting Guys are still sitting here in the CMP Media booth (that’s booth No. 1301 for
Posted by ScriptingGuy | 0 Comments
More Posts Next page »
 
Page view tracker