SqlServerKudos - Stories tagged with PowerShell

PowerShell

atom rss
1
kudos
spam Kudos Remove

Performance Data Gathering
published 290 days, 5 hours, 3 minutes ago posted by sasa 295 days, 4 hours, 47 minutes ago
Wednesday, October 14, 2009 3:02:13 PM GMT Friday, October 09, 2009 3:18:29 PM GMT
Performance Data Gathering
As a DBA, one of the things I struggled with was gathering all my important system information in one place, so I could see easily where my problems might be. Gathering perfmon data, combining it with trace data, adding in disk space information - it was hard to do this automatically. This is probably why I like PowerShell so much. I can do this from a single script and don't have to try to merge data later. The perfmon data gathering was always a problem for me, trying to export the log files into s... (more)
category: News | clicked: 2 | comment | | source: sqlblog.com
tags: Database Administration, PowerShell
1
kudos
spam Kudos Remove

Use the Best Tool for the Task - Part 2
published 322 days, 7 hours, 19 minutes ago posted by sasa 330 days, 20 hours, 59 minutes ago
Saturday, September 12, 2009 12:46:25 PM GMT Thursday, September 03, 2009 11:06:10 PM GMT
Use the Best Tool for the Task - Part 2
Yesterday I posted about how Transact-SQL was better suited than SMO for gathering details about database files for a database with very large files. Today I'd like to point out that creating the database I used to test that fix was far easier with PowerShell and SMO than any other method. SQL Server, and Transact-SQL specifically, are very good at set-based activity, and that's a good thing. Relational databases are based on a set model. To create all the files I needed for my test I needed an itera... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: PowerShell, SMO
1
kudos
spam Kudos Remove

Use the Best Tool for the Task
published 326 days, 7 hours, 37 minutes ago posted by sasa 332 days, 6 hours, 40 minutes ago
Tuesday, September 08, 2009 12:27:56 PM GMT Wednesday, September 02, 2009 1:25:34 PM GMT
Use the Best Tool for the Task
Last February I wrote an article for Simple-Talk called Let PowerShell do an Inventory of your Servers. This script was useful to me then, and it continues to be so, but it recently ran into a glitch. Here is the code in the script to gather data on each file used by a database:$fgs = $db.FileGroups foreach ($fg in $fgs) { $files = $fg.Files $outnm = ".\" + $svr + "\" + $instnm + $dbtype + "" + $dbname + "DataFiles.csv" $files | select $db.Name, Name, FileName, Size, UsedSpace | expor... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: PowerShell, SMO
1
kudos
spam Kudos Remove

PowerShell to Validate SAN File Migration
published 326 days, 7 hours, 37 minutes ago posted by sasa 333 days, 5 hours, 20 minutes ago
Tuesday, September 08, 2009 12:27:56 PM GMT Tuesday, September 01, 2009 2:45:02 PM GMT
PowerShell to Validate SAN File Migration
This post is a bit off topic for SQL Server proper, but I thought someone out 'oogling teh inter-tubes might find it useful. Our group recently had to perform a large SAN migration both to new equipment and to a new geographic location. We started with a replication method provided by the SAN vendor. I won't mention who, but from where I sit I can't prevent you from guessing :-). We had to move a lot of files; the great majority made the move intact but, perhaps because we are picky, we needed every sing... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: PowerShell, SSIS
1
kudos
spam Kudos Remove

10 Big Ideas in Database Design and more SQL Smarts
published 324 days, 7 hours, 29 minutes ago posted by sasa 334 days, 1 hour, 39 minutes ago
Thursday, September 10, 2009 12:36:32 PM GMT Monday, August 31, 2009 6:26:02 PM GMT
10 Big Ideas in Database Design and more SQL Smarts
10 Big Ideas in Database Design and more SQL Smarts eek! Sleep well tonight if you plan on attending the free 24 hours of non-stop SQL Server and BI training on from the good folks at SQL PASS. All from the comfort of your favorite internet connected spot… Additional details, timings and registration at the SQL PASS website. From the website: Depending on your location, sessions may also be broadcast on Sept. 1 and Sept. 3, 2009. Please be sure to check our time zone guide for exact times. When you ... (more)
category: Community | clicked: 5 | comment | | source: blogs.msdn.com
tags: Local Happenings, PASS, PowerShell, SQL 2008
1
kudos
spam Kudos Remove

Hexagonal Close Packing for your Fact Data
published 351 days, 5 hours, 31 minutes ago posted by sasa 355 days, 1 hour, 40 minutes ago
Friday, August 14, 2009 2:33:59 PM GMT Monday, August 10, 2009 6:25:31 PM GMT
Hexagonal Close Packing for your Fact Data
Disclaimer: It's likely you don't really want to do what I am proposing in this post. This is just an esoteric defrag process, which won't really deliver much performance benefit but carries a fair amount of risk. I present it purely as a curiosity. To paraphrase Scott Hanselman, you might just want to run away at this point, as I can only guarantee that this is an idea, not a good idea. Modest fragmentation has a minor effect on most systems, and what follows is definitely overkill. And it might not eve... (more)
category: Warehousing | clicked: 0 | comment | | source: sqlblog.com
tags: Defragmentation, PowerShell
1
kudos
spam Kudos Remove

When you should and shouldn't use PowerShell in SQL Server
published 369 days, 7 hours, 52 minutes ago posted by sasa 370 days, 2 hours, 55 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Sunday, July 26, 2009 5:10:20 PM GMT
When you should and shouldn't use PowerShell in SQL Server
PowerShell is cool, but it's not always appropriate. Here's a quick list to help you decide when to use it|Print|Add a comment| 106 Recommendations PowerShell is one of the coolest new things to come out of Microsoft in a long while, and it’s going to do more for server admin than anything else. That doesn’t mean, though, that it’s always the technology for every task. [ Cut straight to the key news for technology development and IT management with our once-a-day summary of the top tech news. Subscribe... (more)
category: Management | clicked: 4 | comment | | source: www.infoworld.com
tags: PowerShell
1
kudos
spam Kudos Remove

PowerShell's "Mini-Shell" Is Not A "Mini" Shell
published 369 days, 7 hours, 52 minutes ago posted by sasa 370 days, 14 hours, 16 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Sunday, July 26, 2009 5:48:49 AM GMT
PowerShell's "Mini-Shell" Is Not A "Mini" Shell
I just learned about a Connect item entered on Friday: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=475337. Here's the description in the item.Please invoke the full powershell not a "mini-shell". Powershell is very powerful but the mini-shell you get when invoking Powershell from the Management Studio is missing a lot of functionality. I'm not sure how the submitter determined that there was any missing functionality, because there isn't. SQLPS.exe is PowerShell 1.0... (more)
category: Management | clicked: 0 | comment | | source: sqlblog.com
tags: PowerShell, SSMS