Viewing 15 posts - 1 through 15 (of 30 total)
Nice and simple.
January 6, 2015 at 4:39 pm
Thanks for sharing. Cool script.
You also might want to limit the data collection for only 'ONLINE' databases.
SELECT [name] FROM master.dbo.sysdatabases
WHERE DATABASEPROPERTYEX(name, 'status')...
February 3, 2014 at 9:16 am
For your viewing pleasures... here is another working sample tested on sql 8 - 10.50
IF EXISTS ( SELECT * FROM tempdb..sysobjects WHERE id =...
October 23, 2012 at 3:30 pm
SS2K8 R2 Ent install on Win2K8 R2 Ent 64 bit hates me
I give up, it is time rebuild the server from scratch :hehe:
September 20, 2012 at 2:31 pm
dwithroder: can you post the actual result for both inqueries... running on sql and wmi powershell.
April 5, 2012 at 3:21 pm
RedGate's SQL Compare does the wonders
The tool well worth every penny/shilling.
~Leon
March 28, 2012 at 11:48 am
Powershell rocks! Great tool for auditing and keeping eye on your server farm.
March 27, 2012 at 5:15 pm
Good read. Must have script in every DBA's toolbelts.
Thanks for sharing
~Leon
March 19, 2012 at 10:44 am
I would not recommend this option unless you absolutely have to bring your SQL Server online within 1 hour to meet the SLA and simply reattach all your user databases...
March 12, 2012 at 11:46 am
Here is snippet of PowerShell script that returns some details like socets, cores, memory, and tells if it is VM or not (for only VMWare hosts).
$Servers = Invoke-sqlcmd2 -ServerInstance "<dbserver>"...
March 7, 2012 at 3:44 pm
Nice way to make PoSh do the digging for ya.
March 6, 2012 at 3:29 pm
Great idea. Thkx. Does need just a little "fine tuning" to make it work as advertized on VLDBs.
March 6, 2012 at 3:26 pm
Great idea. Thkx. Does need just a little "fine tuning" to make it work as advertized on VLDBs.
March 6, 2012 at 3:26 pm
SSC party... to play pocker sql server style :w00t:
September 26, 2011 at 9:46 am
Viewing 15 posts - 1 through 15 (of 30 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy