(Steve) When coming in to a new environment, it’s a good idea to get a baseline of all of the databases on each of the systems in the environment. The script below will generate a report of all of the databases on a given SQL Server instance.

(Jayleen Heft) SQL Server 2014 continues the Microsoft commitment to excellence in security. According to the National Institute of Standards and Technology (NIST) public security board, SQL Server reportedly has the lowest number of security vulnerabilities across major database vendors.

(Russ Thomas) Remember the old ‘Deep Thoughts – by Jack Handy’ bit on Saturday Night Live. One of those came across the cube wall today.

(Ryan Adams) I ran into an interesting issue while installing SQL 2012 SP1 in a failover cluster configuration and utilizing the local TempDB feature. If you are unfamiliar with the new feature in SQL 2012 that allows you store TempDB on a local drive in a failover cluster you can read more here.

(SQL Shep) I have had many calls with customers that essentially ended with your I/O subsystem cannot keep up with your workload. The obvious next question was how do we solve that? My answer was usually get a faster IO subsystem or do less IO! Now, SQL 2014 offers another option.

(Kenneth Fisher) When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server to tell if your databases are corrupt? You shouldn’t be.

(Matt Bowler) Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During some recent migration work I realised that SQL Server Management Studio could do most of the work of sp_help_revlogin.

(Dallas Snider) The output from the Association Rules data mining model in SQL Server Analysis Services can be difficult to understand in terms of the calculations named probability and importance, especially when the generated rules become more complex. In this tip we go through an example to prov

(Pinal Dave) In my last article, I talked about the basics of tabular data model and why use it. Then I demonstrated step by step creation of a basic tabular model project. In this part I’m going to throw some light on how to create measures and analyses in excel.

(Ben Snaidero) If you’re one of the lucky ones, you or your company has the ability to purchase third party software to monitor the health of your database systems. If you’re not, now with SQL Server 2012, Microsoft has introduced the sp_server_diagnostics stored procedure which provides us with a l