PowerShell

From time to time, I need to restore multiple databases on various Development and Test environments using production database backup files. However, when I start to do the restore, my restore often fails because of lack of disk space. In this tip we cove

PowerShell V2 introduces the try-catch-finally statements, similar to those you already use when you write .NET code. In this tip we look at how this can be used for your PowerShell scripts.

I want to shrink the SQL Server transaction log file to reclaim disk space and reduce the number of virtual log files (VLFs) after I have scheduled regular transaction log backups. I checked the log file free space and ran DBCC SQLPERF (LOGSPACE) to verif

Use this PowerShell script that is more accurate in finding strings within T-SQL code such as stored procedures, views, triggers, etc.

I want to count the number of lines of code for all of our non-CLR procedures, views and UDFs in a database, how can I do this? I also want to exclude comments and empty lines from the counts.

I read Aaron Bertrand's tip about dropping and re-creating all foreign key constraints using T-SQL with the FOR XML clause. He invited others to provide other options, so here is my script using PowerShell.

PowerShell has many uses for SQL Server DBAs and Developers. There have been several tips written about different aspects and how PowerShell can be used with SQL Server. In this video tip, Tim Smith looks at six useful PowerShell scripts that can be use

I frequently run into SQL Server administrative and development tasks, as well as being asked by other administrators and developers, for certain tasks to be performed. In this tip, we cover 6 PowerShell scripts that make these tasks much easier. Keep in

What are the common DBA tasks suitable for SQL Server PowerShell? How can I start to learn about these tasks in SQL Server?

In this video, we look at some of the basics to text mining data in SQL Server using PowerShell by looking at words and the positions of words. Tim will show us various PowerShell functions to help mine text data from SQL Server tables.

In this video tip, we look at how to use RegEx to find patterns in data strings.

In this tip, I cover some of the basics of RegEx with PowerShell and TSQL for SQL Server

We get Excel files with several worksheets and we want a way to automate the extraction of each worksheet, so it can be imported into SQL Server. In this video tip, we look at how to use PowerShell to automate the extraction of each individual worksheet

In this video, we will look at how to check the number of rows and the file size using two different methods. This video will show how you can incorporate pre-import checks to your import processing using either PowerShell or C# code.

SQL Server DBAs and Developers often get flat files that they need to import into SQL Server for queries and data manipulation. In this video tip, learn how you can use PowerShell to dynamically read and import flat files to SQL Server.

A task that often needs to be performed by SQL Server DBAs and Developers is the need to move and rename files that are sitting on the file system. In this video tip Tim Smith shows how this can be done using PowerShell. He will also show how you can cr

A few colleagues have asked me if PowerShell provides an easy way to export Excel as a CSV. Whether we have multiple Excel files, or just multiple worksheets in Excel, PowerShell simplifies the process. In addition to that, once the format is in CSV, we h

We import a file once a day and after importing the file, we need it moved to an archive folder with a date stamp appended to the file name. We have had trouble in the past with this process, so we'd like this to run as its own step to help troubleshoot

Since it was first released with Windows 2003 back in 2006, PowerShell has become more and more widely used for different administrative tasks in a Windows environment. In this tip we will take a look at how PowerShell can be used to monitor a SQL Server

You've just commissioned a new SQL Server. A user or developer insists the database is down, they can't connect and they are getting any one of several error messages. You know the SQL Server instance and SQL browser service are running, but rather than j

Two key responsibilities of a DBA are ensuring that the databases do not get damaged, and that they can be recovered if they do get damaged. In this tip we show how you can use PowerShell to automate database restores and to run DBCC CheckDB on the restor

I work in an environment where getting new software approved is often quite difficult. We have a disk space monitor in place, but it doesn't provide the type of monitoring my team was looking for. Monitoring disk space is critical for DBAs In addition, we

Often when managing SQL Server you need to review and change Windows process information for SQL Server processes. In this tip I will introduce a few PowerShell cmdlets related to accessing and handling Windows processes and I will explain how to use the

Here I will introduce a few PowerShell cmdlets related to accessing and handling Windows and SQL Server services. In this tip I will explain how to access services using Windows Power