-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

How to sign a SQL Server CLR Assembly in Visual Studio 2015

It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR stored procedure / function / trigger etc) in VS 2015.

If you google “sign a SQL Server CLR Assembly”, you will most likely find out content published 5+ years ago… Read more

0 comments, 1,603 reads

Posted in DBA Philosophy on 21 February 2017

CLR Stored Procedure Cannot Be Marked as System Object?

It is an open secret that in SQL Server, we can “create a system object” by using an undocumented stored procedure sp_MS_marksystemobject as explained here.

The benefit is that when you put a SP in the [master] database and mark it as system object, this SP can then be… Read more

1 comments, 164 reads

Posted in DBA Philosophy on 17 February 2017

What Is Your Career Investment Portfolio?

Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes according to one’s financial reality, like whether you are going to be married, to have a baby soon, to have a new house or to change your career etc, so… Read more

0 comments, 401 reads

Posted in DBA Philosophy on 23 January 2017

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 error.

 

-- this will return an error

exec…

Read more

1 comments, 899 reads

Posted in DBA Philosophy on 19 January 2017

A DBA’s Developer Experience and After-Thoughts

After 10+ years of a dedicated DBA, for the past 17 months, I have purposely chosen to work as a database developer. I decided to do this mainly for two reasons:

1. I want to have a career travel to see whether the grass is greener on the other side. Read more

6 comments, 1,560 reads

Posted in DBA Philosophy on 28 November 2016

IT People’s Technical Debt and Reputation Credit

In Canada and USA, when people apply for a credit card or a loan/mortgage, the lending institutions will always do a credit history check against the applicant, and based on the result, they will decide whether to approve the application or decide what loan rates the applicant will be charged.… Read more

11 comments, 1,693 reads

Posted in DBA Philosophy on 1 June 2016

New Year Wish List for SQL Server Features

 

With SQL Server 2016 to be officially released this year, I want to make a wish list for the features I really dream of, and see when / whether this list will come true down the road.

1. Revolutionize SSMS with features like those in MS Office Word /… Read more

10 comments, 1,329 reads

Posted in DBA Philosophy on 10 January 2016

Be Cautious About Invoke-SqlCmd Bug

With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered to, IMHO, an corner-stone cmdlet in SQLPS module, invoke-sqlcmd.

I mentioned this here http://stackoverflow.com/questions/33271446/invoke-sqlcmd-runs-script-twice (and also in MS forum)

But I’ll give a more simplified version here to verify this… Read more

2 comments, 160 reads

Posted in DBA Philosophy on 25 October 2015

Be Cautious About Invoke-SqlCmd Bug

With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered to, IMHO, an corner-stone cmdlet in SQLPS module, invoke-sqlcmd.

I mentioned this here http://stackoverflow.com/questions/33271446/invoke-sqlcmd-runs-script-twice (and also in MS forum)

But I’ll give a more simplified version here to verify this… Read more

2 comments, 967 reads

Posted in DBA Philosophy on 25 October 2015

Database Administration via CrowdSourcing

According to Wikipedia:

 Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group of people, and especially from an online community, rather than from traditional employees or suppliers.

Every DBA must have googled something to address his/her technical issue, and… Read more

0 comments, 180 reads

Posted in DBA Philosophy on 25 May 2015

Database Administration via CrowdSourcing

According to Wikipedia:

 Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group of people, and especially from an online community, rather than from traditional employees or suppliers.

Every DBA must have googled something to address his/her technical issue, and… Read more

0 comments, 396 reads

Posted in DBA Philosophy on 25 May 2015

Award from MSSQLTIPS.com

Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.

I have to say it is probably my best decision in 2014 to write for MSSQLTips.com as I am not only paid decently for writing about what I… Read more

0 comments, 465 reads

Posted in DBA Philosophy on 14 January 2015

Award from MSSQLTIPS.com

Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.

I have to say it is probably my best decision in 2014 to write for MSSQLTips.com as I am not only paid decently for writing about what I… Read more

0 comments, 154 reads

Posted in DBA Philosophy on 14 January 2015

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, 2,497 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, 837 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, 3,336 reads

Posted in DBA Philosophy on 2 March 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, 418 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, 261 reads

Posted in DBA Philosophy on 20 January 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,855 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, 782 reads

Posted in DBA Philosophy on 7 January 2014

Older posts