Useful tips for everyday
How do I remotely connect to SQL Express database? Configure SQL Server machine Windows Firewall ->Advanced Settings->Inbound Rules. Run SSMS (SQL Server Management Studio) on…
How can I use cursor inside cursor in SQL? The trick to declaring a cursor within a cursor is that you need to continue to…
How do I view a virtual log file in SQL Server? How to Identify Virtual Log Files in SQL Server Transaction Log File. Using DBCC…
How do I backup a table in SQL Server? Step 1 : Right click on the database and choose Tasks –> Generate Scripts. Step 2…
How do I find SQL Server integration service package? Go to Connect to Server and select the Server Type as Integration Services and give the…
What is a custom aggregate? A way of categorizing/grouping similar functions together. Custom Aggregate Functions may be assigned to any existing category or to a…
What does a follower of Heroku Postgres leader database provide? Heroku Postgres has an automated monitoring system for followers. It checks if the follower is…
How does rank function work in SQL? RANK() Function in SQL Server The RANK() function is a window function could be used in SQL Server…
What does export to XML mean? XML is a meta language used to facilitate the easy exchange of data between systems using different applications. Importing…
How long will data stay on a HDD? Most hard disk drives (HDD) last between three and five years before some component fails. That doesn’t…