Useful tips for everyday
How to return affected row count in PostgreSQL? Depending on what you might want to achieve, the special boolean variable “FOUND” could serve; UPDATE, INSERT,…
Can not connect to the SQL Server the certificate chain was issued by an authority that is not trusted? You likely don’t have a CA…
What is SQL logical reads? A logical read occurs every time the Database Engine requests a page from the buffer cache. If the page is…
Can we update table in function? You can’t update tables from a function like you would a stored procedure, but you CAN update table variables.…
Why use Ola hallengren scripts? Ola’s script is designed to cover the most common database maintenance tasks, which include: The ability to perform database integrity…
How do I downgrade an SSIS package? Open the dtsx package with notepad…download the SQLNCI connector to the right version…save the file…create an SSIS project…
Can I run Cosmos DB locally? The Azure Cosmos DB Emulator provides a local environment that emulates the Azure Cosmos DB service for development purposes.…
How do I find my UserName in Microsoft Access? Try the following: Open a command prompt. Enter the following command in that command prompt window:…
How can I join two tables but only return rows that do not match? However, I only want to return the results from table 1…
What is read-only routing? Read-only routing refers to the ability of SQL Server to route qualifying read-only connection requests to an available Always On readable…