Configuration service database design pattern

In many cases, we are required to store configuration values for an application, application functionalities or user-specific parameters. Normally application-level...

Database Doing DevOps

DevOps.  It’s one of the latest buzz words in many technical communities.  Database Doing DevOps  This phrase, however, is NOT...

I learned about the order of logical operations #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Parsing the PASS Blog Posts about FY 19 and SQLSaturday

In February PASS President Grant Fritchey posted PASS Priorities FY 19 followed by An Open Letter to SQLSaturday Organizers, and then held...

SQL .NET Requirements

SQL Server Install Requirements
SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...

SQL Script to find the database & their files details on a SQL Server

Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server...

SQL Script to find the database & their files details on a SQL Server

Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server for house keeping purpose: -1) Database Name2) Database ID3)...

SQL Script: - How to find the database restoring history of SQL Server databases

Sometime we need to find out the history of database restoration to get the answers of following questions: -

1) Do...

SQL Script: - How to find the database restoring history of SQL Server databases

Sometime we need to find out the history of database restoration to get the answers of following questions: -1) Do we need to restore the database again as there...

The Journey Begins

Thanks for joining me! Target Audience. Database developers, designers and architects. Background. I am lazy efficient, at least am trying to...