Tagged: SSMS

SQL Server Management Studio

0

Searching SQL Servers & Saving Results, with Write-SqlTableData

The other day I was chatting with my friend Tom Roush ( B | T ) and he mentioned needing to scan every database on every SQL Server instance in his environment and look for a particular word in the stored procs. Tom and I had discussed basics of his environment once before so I knew he already had Registered Servers filled out with all the instances he was going to need to search.

Write-SqlTableData came out last month in SSMS 16.4, it’s V1 so it’s not perfect [yet] but boy is it ever magic when you’re in a hurry! In this case, in order to be able to save the results for Tom, we need to find what we’re looking for once and then create a table in SQL Server using those results. To do this we use our very much improved friend Invoke-Sqlcmd and we leverage the new -OutputAs DataTables parameter which came out earlier this year. That give us a .Net Data Table.

Quick Post: Scripts from PowerShell VC Meeting 0

Quick Post: Scripts from PowerShell VC Meeting

I knew I was forgetting something, I just couldn’t remember what, now I know! J Chrissy LeMaire ( b | t ), Rob Sewell ( b | t ) And I did a session...

Webinar on 25 New PowerShell cmdlets for SQL Server and more! 3

Webinar on 25 New PowerShell cmdlets for SQL Server and more!

Next week Chrissy LeMaire ( b | t ), Laerte Junior ( b | t ), Rob Sewell ( b | t ) and I will be hosting a webinar covering the new PowerShell...

Want to get something fixed/improved/added in SQL Server Management Studio? Join us on Trello! 1

Want to get something fixed/improved/added in SQL Server Management Studio? Join us on Trello!

Do you have something you want to get fixed, improved, or added in SQL Server Management Studio?  If so, join us on Trello! A couple weeks ago I mentioned that we are using Trello...

Performance Tweaking Your SQL Server via PowerShell and Other News 1

Performance Tweaking Your SQL Server via PowerShell and Other News

Wow, there’s so much PowerShell news and goings-on that I barely have time to update the blog.  Here is a very terse update of some of what’s going on. Thank you to all of...

%d bloggers like this: