Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: March 2013

PowerShell Usage in DBA Work – Case Study 7/7

Reading/scanning SQL Server Logs is a required DBA work item in all my work environments. I know there are lots different ways, mostly are using undocumented xp_readerrorlog or sp_readerrorlog.   Even in PS way, this xp_readerrorlog is wrapped as a sql command in the PS script. Actually, with PS and Regular… Read more

1 comments, 1,531 reads

Posted in DBA Philosophy on 24 March 2013

PowerShell Usage in DBA Work – Case Study 6/7

SQL Server SMO is a great resource for DBAs, unfortunately, before PowerShell, it is a pretty deep learning curve to get familiar with SMO. The beautify of PS is its own discovery capacity. This is best described in the Keith Hill’s free ebook (http://rkeithhill.wordpress.com/2009/03/08/effective-windows-powershell-the-free-ebook/). So in short, we… Read more

0 comments, 1,741 reads

Posted in DBA Philosophy on 23 March 2013

PowerShell Usage in DBA Work – Case Study 5/7

One challenge in a super-multiple server (say a few hundred servers) environment is to know what sql services (SSRS/SSAS/SSIS/Engine/Agent etc) are installed and what their versions and the startup accounts are.

Case Scenario: (SQL Service Inventory)

We are managing hundreds of physical servers in our environment, most of the servers… Read more

0 comments, 609 reads

Posted in DBA Philosophy on 20 March 2013

PowerShell Usage in DBA Work — Case Study 4/7

One common surprise I have encountered in almost all my DBA environments is that a sql job that usually runs <x> minutes, sometimes can take <2x> minutes or even more time to finish.

Case Scenario: (Monitor / alert long running sql jobs)

We have hundreds of sql instances supporting many… Read more

0 comments, 544 reads

Posted in DBA Philosophy on 17 March 2013

PowerShell Usage in DBA Work — Case Study 3/7

As a DBA, sometimes we may need to demonstrate to some stakeholders when a sql server instance was last rebooted, i.e, just to prove the sql instance weekly/monthly availability . I know there are quite a few blogs / posts online talking about how to do this check, such as… Read more

1 comments, 731 reads

Posted in DBA Philosophy on 14 March 2013

PowerShell Usage in DBA Work — Case Study 2 / 7

 

As a DBA in a complex environment, we frequently need to backup various environment information. One of the backups is to script out the configurations / objects, for example, scripting out replication,  jobs, policies and policy conditions etc. Almost all of these scripting work can be done via SSMS,… Read more

1 comments, 715 reads

Posted in DBA Philosophy on 10 March 2013

PowerShell Usage In DBA Work — Case Study 1 / 7

 

I have been blogged non-technical topics for too long and it is time for me to return to my favourite technical topics now.

I plan to write seven real-world cases where I feel PowerShell solution is much more efficient than pure T-SQL one, hopefully these cases can stir some… Read more

0 comments, 543 reads

Posted in DBA Philosophy on 6 March 2013