iqnov.com

e know the possible pitfalls of "SELECT *..." in programmable objects and often DBAs discourage users or developers from using it in their queries. However it's hard to enforce that in code. Here's one way to make sure users do not use "SELECT * FROM..." If you create a dummy column ...

Think of this scenario. You have forgotten (or do not have) the "sa" password The builtin\administrators account has been removed for security reasons You cannot connect to the SQL Server instance Now what do you do? Let us see what you can do. First off you need to shut down all the SQL Server related ...

Overview On most software development companies, there are several database instances for the development, QA, staging and production environments. During the development life cycle, developers may insert new records and update existing records for a particular table on the development database. These records can be configuration settings or data relevant to ...