I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...

I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...

I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...

I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification. PRINT FORMAT( GETDATE(), ...

I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification. PRINT FORMAT( GETDATE(), ...

Make sense....

Make sense....

I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification. PRINT FORMAT( GETDATE(), ...

I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification. PRINT FORMAT( GETDATE(), ...

While installing a windows service I wrote this command in my installation script (not using the installutil.exe) and used a service user account. SC.EXE create MyService binPath= "%CD%\MyService.exe" start= auto obj= "domain\Myserviceuse...