From a disconnected query window, we can connect back to the SQL Server instance from the **Query > Connection > Connect** menu option. This may sound simple, but I found this interesting. I usually press F5 (or execute button) twice to get connecte...

Reporting Services has a system database called "ReportServer" (default) which it uses to store the information related to reports, data sources, report execution etc. stored/accessed on the Report Server. A table called "Catalog" stores the informa...

Reporting Services has a system database called "ReportServer" (default) which it uses to store the information related to reports, data sources, report execution etc. stored/accessed on the Report Server. A table called "Catalog" stores the informa...

I have worked with SQL Server bit columns for years, yet even so, to my surprise I just learned that you can not only use 1 and 0, you can also use the literals 'true' and 'false'. Note that they are not explicitly bit data types already, but like 1 and...

I have worked with SQL Server bit columns for years, yet even so, to my surprise I just learned that you can not only use 1 and 0, you can also use the literals 'true' and 'false'. Note that they are not explicitly bit data types already, but like 1 and...

Recently I noticed that Deleting a database which is in offline leaves physical files intact......

Recently I noticed that Deleting a database which is in offline leaves physical files intact......

I support third party software databases at work. During the implementation of the application it needed to create a database to store the data. However the application created a database with a name that does not follow the rules for the format of id...

I support third party software databases at work. During the implementation of the application it needed to create a database to store the data. However the application created a database with a name that does not follow the rules for the format of id...

I just learned from Jacob sir that one can capture (only) the active window by using ALT + PrtScn command. Previosuly i used snipping tool for capturing "active windows" but now having learned about ALT + PrtScn would make my life easier. It's a nice ke...