Useful tips for everyday
What is a migration SQL? SQL data migration is defined as the process of moving data to or from SQL Server. When we look at…
What happens if a trigger fails in SQL Server? The trigger statement will work under the scope of the same transaction that fires that trigger.…
How do I register my Oracle provider with OraOLEDB? Right Click on My Computer. Click on properties. Click on Advanced System Settings. Click on “Environment…
How to change IP addresses in always on availability group? We have two nodes in an Always On availability group, on SQL Server 2014 Enterprise.…
Should Ssisdb be in full recovery? SSISDB Recovery Model The default recover model of the SSISDB database is the Full Recovery Model. However, the SSISDB…
Are there any additional files in SQL Server? By default, SQL Server databases are comprised of two files: the primary data file (or .mdf) and…
What is the description for syntax error? In computer science, a syntax error is an error in the syntax of a sequence of characters or…
What account should SQL Server Agent run under? The account that the SQL Server Agent service runs as must be a member of the following…
Why are optional parameters bad? The thing with optional parameters is, they are BAD because they are unintuitive – meaning they do NOT behave the…
What is the equivalent of InStr in SQL Server? CHARINDEX function In SQL Server, you can use CHARINDEX function that allows you to specify the…