(K. Brian Kelley) I need to create a login for my SQL Server and assign it the correct permissions. I already have another login which has the exact permissions I want. Is there a way I can clone the login that has all the permissions?

(Suresh Raavi) DBAs most often face scenarios where they need to capture graphical execution plan of a query currently running on a live production instance because of multiple reasons like:

(Marcin Policht) Following the main theme of our earlier articles published on this forum, we will continue our quest for methods to simplify and streamline provisioning and management of Azure SQL Database and SQL Server running in Infrastructure-as-a-Service (IaaS) Azure virtual machines.

(K. Brian Kelley) I need to create a login for my SQL Server and assign it the correct permissions. I already have another login which has the exact permissions I want. Is there a way I can clone the login that has all the permissions?

(Chris Skorlinski) Just a heads up if you are still running any version of SQL Server prior to SQL Server 2012 SP1 for Transactional Replication and the following hold true:

(Chris Webb) Disappearing or renamed columns in your data source can cause all kinds of problems when you’re importing data using Power Query: errors when you try to refresh the query, broken calculations in Power Pivot, PivotTables that reformat themselves and then need to be manually recreated.

(Robert Sheldon) It is sometimes hard to keep up with Microsoft’s direction in Business Intelligence. Over the years, we’ve been presented with so many ways of aggregating, processing, graphing, reporting and visualising data, that we felt it was time to take stock and present the Simple BI Timeline

(Pinal Dave) You know that you can add data to a table using VALUES clause. But did you know that you can create a dataset using VALUES clause like a table without adding into another table?

(Chris Skorlinski) Just a heads up if you are still running any version of SQL Server prior to SQL Server 2012 SP1 for Transactional Replication and the following hold true:

(Chris Webb) Disappearing or renamed columns in your data source can cause all kinds of problems when you’re importing data using Power Query: errors when you try to refresh the query, broken calculations in Power Pivot, PivotTables that reformat themselves and then need to be manually recreated.