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

Bug in SQL Server 2014 SQLPS For Registered Servers/Groups

I recently had an opportunity to write an article for mssqltips.com on managing registered servers under “local server groups”, and Greg Robidoux was kind enough to do a review for me and he got back to me saying my script not working under SQL Server 2014 SSMS, though it works… Read more

0 comments, 926 reads

Posted in DBA Philosophy on 7 June 2014

Decode SQL Server Job Schedules

As once a data architect, I cannot help but admiring and appreciating the data model behind the sql server job schedules. The core design is actually just one table, msdb.dbo.sysschedules, but the design beauty/elegance of the table is that it can support many different types of schedule with a rich… Read more

0 comments, 239 reads

Posted in DBA Philosophy on 7 April 2014

Fun in DateTime Calculations

Recently I was working on a task that needs to handle various datetime calculations, and it is really fun.

Usually there are two types of approaches, one is to convert datetime value to string value and then through string calculations like substring, concatenation and convertion to get the result, another… Read more

4 comments, 2,044 reads

Posted in DBA Philosophy on 2 March 2014

Reliably Drop A Database With CLR Stored Procedure

 

After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up with a solution that in theory is robust. The only way I can think of is to use a CLR stored procedure which will do the following three… Read more

0 comments, 1,069 reads

Posted in DBA Philosophy on 20 January 2014

Reliably Drop A Database In T-SQL Script

 

I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I think I have a solution, which at least I cannot prove it not working so far.

   1: USE master; 

   2: GO

   3:  

   4: IF EXISTS(

Read more

2 comments, 248 reads

Posted in DBA Philosophy on 7 January 2014

Thoughts About MS Advanced Certification

 

Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on this cancellation and my expectation for future.

I have read lots of blogs discussing this cancellation. Most are against the cancellation. Indeed, I agree this is not a decent… Read more

0 comments, 308 reads

Posted in DBA Philosophy on 16 September 2013

Agile Database Administration

 

I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile <something>” really is, but I do know that the key of “agile <something>” is a breakup of the traditional way of doing <something> and this agile way is coming…

Read more

0 comments, 400 reads

Posted in DBA Philosophy on 12 June 2013

Database Administration KPIs – 2/2

In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to evaluate DBA work performance from business perspective. However, I believer there should be some qualitative KPIs that can be best used by “insiders” to evaluate the DBA work from… Read more

0 comments, 2,071 reads

Posted in DBA Philosophy on 4 May 2013

Database Administration KPIs – 1/2

 

As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way, what criteria would I hope to be used by others (my manager / clients / peers etc) to evaluate my work?

In DBA world, we love “no news is… Read more

7 comments, 1,257 reads

Posted in DBA Philosophy on 25 April 2013

Procedural Justice In Database Administration

 

According to Wiki, Procedural Justice (PJ) means:

Procedural justice is the idea of fairness in the processes that resolves disputes and allocates resources.

To me, this concept of PJ should be introduced to database administration domain as well, I’ll use the following example to illustrate the necessity.

As… Read more

0 comments, 427 reads

Posted in DBA Philosophy on 7 April 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,588 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,770 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, 654 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, 579 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, 784 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, 751 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, 640 reads

Posted in DBA Philosophy on 6 March 2013

Where Should Database Administration Go?

 

For the past 5 or 6 years, we have seen lots of innovative products emerged, from smartphone to tablets, from social media to cloud computing. However, I am somehow disappointed with Microsoft for its innovation speed on database administration front. Actually since SQL Server Management Studio (SSMS) was introduced… Read more

0 comments, 430 reads

Posted in DBA Philosophy on 4 February 2013

DBA Work Accounting

 

One thing lots of DBA teams, esp. the DBA managers, feel uncomfortable is that it is difficult to quantify/log DBA’s workload and as such it is hard to argue to the upper management for more justified budget and human resources. In worst scenario, this will cause the burn-out and…

Read more

1 comments, 934 reads

Posted in DBA Philosophy on 22 October 2012

Why I dislike Third Party Database Monitoring Tools

I have to admit I am not a fan of the various 3rd party monitoring tools (after using a few of them in the past 10 years) mostly because of the following two reasons:

1. Lack of operation productivity. What I see from various products is just a common pattern:… Read more

6 comments, 993 reads

Posted in DBA Philosophy on 17 September 2012

Older posts