Get short, timely messages from Chad Miller.

Twitter is a rich source of instantly updated information. It's easy to stay updated on an incredibly wide variety of topics. Join today and follow @cmille19.

Get updates via SMS by texting follow cmille19 to 40404 in the United States
Codes for other countries

Two-way (sending and receiving) short codes:
Country Code For customers of
Australia
  • 0198089488 Telstra
Canada
  • 21212 (any)
United Kingdom
  • 86444 Vodafone, Orange, 3, O2
Indonesia
  • 89887 AXIS, 3, Telkomsel
Ireland
  • 51210 O2
India
  • 53000 Bharti Airtel, Videocon
Jordan
  • 90903 Zain
New Zealand
  • 8987 Vodafone, Telecom NZ
United States
  • 40404 (any)

cmille19

  1. Jacksonville IT Pro Camp on 6/16/2012 Schedule itprocamp.com/jacksonville/2…
  2. @SirSQL We use mount points. I think we're using custom scripts with SCOM, but I'm not sure. I'll let you know tomorrow.
  3. @SirSQL Some Powershell glue to make PBM->SCOM work. Invoke-PolicyEvaluation does most of the work.Just need to write message to eventlog.
  4. Presenting @SCSUG tonight on PBM and SCOM Integration spacecoast.sqlpass.org
  5. @pkral I posted a suggestion on SF. I'm not sure if it will help, but I generally use cmdexec over powershell job steps in SQL Agent.
  6. @zippy1981 I haven't figured how to use a list or named range in Excel through OLEDB. Its doubtful it is supported by driver
  7. Got Google Drive. It's like SkyDrive except with APIs
  8. Appending New Rows Only - goo.gl/4C00U via @Shareaholic #Powershell #SQLServer
  9. Backup Database Object - goo.gl/rGA0b via @Shareaholic #Powershell #SQLServer
  10. Transforming Event Log Data - goo.gl/58AIK via @Shareaholic #Powershell #SQLServer
  11. @SQLvariant @WPConcierge Contact @mcflyamorim he's a Brazilian SQL MVP who attended Summit
  12. @mcflyamorim I'm at the Summit. You going to reception tonight?
  13. Interesting KB article lends support for disabling UAC on servers only used by admins support.microsoft.com/kb/2526083
  14. Doing some interesting work /w VSDB and Powershell to extract table names and procs from SQL scripts . I'll blog it soon.
  15. @aaronbertrand If you're really curious the meta data app code is here rsdd.codeplex.com There are variations for diff DBMS #sqlhelp
  16. @sqlpoolboy @AaronBertrand INFORMATION_SCHEMA is good enough if all you want is table/col names and approximate data type
  17. @nayanraval I went /w your sysaltfiles groupid=0 suggestion to exclude snapshots. Thanks #sqlhelp
  18. @maxtrinidad nevermind the sid is the db owner #sqlhelp