Finding Unused SQL Server Stored Procedures With PowerShell
Tim Smith describes a number of ways to tell which Stored Procedures are in use, DMVs, a SQL Server Trace, and his preferred method, the Source Code and PowerShell.
2014-07-07
4,642 reads
PowerShell
PowerShell One-Liners: Accessing, Handling and Writing Data
In the grand finale to Michael Sorens' series of PowerShell one-liners, we come to the handling of data, reading it in and writing it out, whether by files; input/output streams or a database. It shows how it can be done in a variety of formats including CSV, JSON, and XML.
2014-06-19
5,763 reads
Anything Remotely Useful
Phi Factor on how to combine PowerShell Remoting with slick Windows tools such as SQLPSX, Boxstarter and Chocolatey, to automate the development process right through to delivery.
2014-06-09
87 reads
PowerShell One-Liners: Collections, Hashtables, Arrays and Strings
The way to learn PowerShell is to browse and nibble, rather than to sit down to a formal five-course meal. In his continuing series on PowerShell one-liners, Michael Sorens provides Fast Food for busy professionals who want results quickly and aren't too faddy. Part 3 has as its tasty confections - Collections, Hashtables, arrays and strings.
2014-06-02
4,798 reads
Extract and convert all Excel worksheets into CSV files using PowerShell
Can PowerShell provide an easy way to export Excel as a CSV? Yes. Tim Smith demonstrates that whether you have multiple Excel files, or just multiple worksheets in Excel, PowerShell simplifies the process.
2014-05-21
2,831 reads
Validate File Properties with PowerShell Prior to Import into SQL Server
We recently faced an issue where an internal data provider began providing an incomplete or inaccurate files because it lacked the proper length (or didn't exceed a certain size). In our case, we implemented a check on the file before importing using PowerShell, here's what we did.
2014-05-15
2,501 reads
PowerShell One-Liners: Help, Syntax, Display and Files
Michael Sorens aims to make PowerShell a bit easier to get going with by providing a series of collections of general-purpose one-liners to cover most of what you'll need to get useful scripting done.
2014-04-25
6,795 reads
Managing SQL Server Services with PowerShell
PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets.
2014-04-10
3,950 reads
Exporting data with header using Powershell
Extracting data with header information using PowerShell
2014-04-28 (first published: 2014-04-07)
1,466 reads
The PoSh DBA – Specifying and Gathering Performance Counters
If you need to keep tabs on a number of servers and applications in a Windows domain then performance counters provide the bedrock of information. It is important to identify the counters you need and gather baseline data to allow you to create alerts when abnormal conditions occur.
2014-03-20
3,753 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers