Skip to content

EMPIRICAL DATA MAN

  • About Me
  • Disclaimer

Month: February 2009

Scan network for instances of MS SQL with Powershell

February 24, 2009 by Sal Young

PROBLEM: You need to find out which computers and servers in my network have an instance of MS SQL installed. SOLUTION: In this solution we’ll create an instance of the Windows Management Instrumentation (WMI) for each computer in a list. We’ll then query the Win32_Service class for the existence of a service which name starts … Read more

Categories PowerShell Tags DBA, PowerShell Leave a comment

How to Script Database Tables with PowerShell

November 4, 2014February 20, 2009 by Sal Young

PROBLEM: I need an easy way to script out all the tables from a database in MS SQL 2000 and above. SOLUTION: Like anything in programming, there are a thousand ways to skin a cat. Here, I’ll show you the simplest way I found to meet this request. Go ahead and open a new session … Read more

Categories PowerShell Tags DBA, PowerShell, SMO, SQL Leave a comment

Archives

  • November 2014
  • September 2014
  • August 2014
  • June 2014
  • November 2013
  • June 2013
  • April 2013
  • March 2013
  • May 2012
  • September 2011
  • April 2011
  • February 2011
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • February 2010
  • July 2009
  • February 2009
  • November 2008
  • February 2008
  • June 2006
  • May 2006
  • April 2006
  • March 2006
  • January 2006
  • July 2005
  • June 2005

Categories

  • Book Review
  • Career
  • Cars
  • MS SQL
  • MySQL
  • Photography
  • PowerShell

Tags

Agile Cars Cars and Coffee Central Management Server Constraints DBA DMV Dodge Viper Español Extreme Programming Featured FSO Index Indexes MCITP MySQL Outlook Posh Script PowerShell Registry SCRIPT Service Broker SMO SQL SQL Alias SQL jobs SQLPSX SQL Server Agent SQL Tuesday SRT Viper T-SQL Script UDF WMI XML
© 2026 EMPIRICAL DATA MAN • Built with GeneratePress
Loading Comments...