SQL Server 2012: Always On and SQL Server authentication

SQL Server 2012: Always On and SQL Server authentication

Here is just a small problem I experienced while adding databases with SQL Server authentication enabled (used for some php websites) to an availability group. Steps I took to add the databases: Add all logins to the secondary server (SQL Management Studio >...

How to (re-)set identity column value in SQL Server?

When you use identity columns in SQL server you may have recognized that when deleting all table data your identity value stays at its latest position. Sometimes this is useful, sometimes it is not. Then you need to set this value to your preferred starting point....