Category Archives: Administration

SQL Server 2016 Bug in R Integration?

  I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using sp_execute_external_script. So here is the re-play of the bug; If I run the following code, I will get an … Continue reading

Posted in Administration | Tagged | 1 Comment

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 … Continue reading

Posted in Administration | Tagged | Leave a comment

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 … Continue reading

Posted in Administration, SQL Development | Tagged , | Leave a comment

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; … Continue reading

Posted in Administration, Operation Productivity | Tagged | 2 Comments

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 … Continue reading

Posted in Administration | Tagged | Leave a comment

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 … Continue reading

Posted in Administration | Tagged | 1 Comment

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 … Continue reading

Posted in Administration | Tagged | Leave a comment