With any server migration, ideally you want things to run smoothly and re-creating SQL Server logins and passwords from scratch is not something you really want to or should be doing. I am currently involved in a complete server replacement for one of our SQL Server clusters. In this environment, mixed authentication is enabled. Back in the day when I was learning about … [Read more...] about How to Transfer Logins to Another SQL Server or Instance
How to Determine SQL Server Version Number In Various Ways
It's important to be able to determine SQL Server version number. DBA's need to know what SQL Server version numbers they are supporting so that during patching windows, they can source and apply the correct patches or service packs. This information is useful as a reference to what issues may be contained in a certain build that could affect production. The DBA can quickly … [Read more...] about How to Determine SQL Server Version Number In Various Ways
Free Ebook Downloads
Everyone likes free ebooks right? Well Eric Ligman, Director for Partner Experience at Microsoft and has very kindly provided a large number of free ebooks to download. Amongst the 80+ titles, there are several Microsoft SQL ebooks as well as titles on Sharepoint, Windows Phone, Windows Server 2012, Microsoft Dynamics, virtualization and many more. Here is the SQL e … [Read more...] about Free Ebook Downloads
Querying INFORMATION_SCHEMA
This post applies to both MySQL and Microsoft SQL Server as both these products allow you to query something called INFORMATION_SCHEMA. What is INFORMATION_SCHEMA? It is database metadata. In MySQL, there is a complete virtual database dedicated to it called “information_schema” and in Microsoft SQL Server, there are views which you can query, all prefixed with INF … [Read more...] about Querying INFORMATION_SCHEMA
Auditing SQL Server Logins
Auditing SQL Server logins is done by way of writing audit information to the SQL Server Logs found under "Management->SQL Server Logs" in Management Studio. In order to enable auditing of SQL Server logins, a simple operation needs to be performed by changing settings in the properties of the SQL Server. Auditing levels vary. It's possible to audit just failed logins, … [Read more...] about Auditing SQL Server Logins