Useful tips for everyday
Are linked servers bad? Linked Servers in SQL Server – Performance and Security [Video] Linked Servers are easy to set up in SQL Server, but…
What is difference between CHAR and VARCHAR2 What is the maximum size allowed for each type? VARCHAR2 is the same as VARCHAR in the oracle…
How do I query my SQL job history? To view the job history log In Object Explorer, connect to an instance of the SQL Server…
How do I copy and paste data from one Access database to another? Right-click the existing table name in the Database Window of the original…
How do I create a SQL Server database offline? Login in to your SQL Server Management Studio. Please refer to how to connect SQL using…
What are the four data types in MySQL? MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and…
How to troubleshoot redo queue build up in AlwaysOn? Troubleshooting REDO queue build-up (data latency issues) on AlwaysOn Readable Secondary Replicas using the WAIT_IN… Jan…
How are security roles assigned in role based administration? The role-based administration model centrally defines and manages hierarchy-wide security access. This model is for all…
Are MySQL views cached? MySQL uses its own query cache. Say, we have a table with 1 mil rows, you query it like select count(*)…
What is master key in Ssisdb? Backup the master key used for encryption in SSISDB database and protect the backup file using a password. What…