(Rajendra Gupta) This article explores the SQL Server PRINT statements, and its alternative SQL Server RAISEERROR statements to print messages in a query.
Tag: sql server
(Kenneth Fisher) I’m taking a Powershell class this week and I have to say the teacher is one of the best I’ve had. He’s one of those people who gets you excited about the subject.
(Scott Murray) How do I use Row Level Security in Power BI? Is it true that I need to use Roles to manage security? Where are the permissions granted? Can you walk through an example demonstrating how to setup Power BI Row Level Security?
(Erin Stellato) There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs).
(Thomas LaRock) Earlier this month Microsoft and GigaOM announced a new benchmark study comparing AWS RDS to Azure SQL Database. This study was authored by the same people that wrote the previous GigaOM data warehouse benchmark last year.
(Pinal Dave) Recently, while working with a client, we determined that they have many unused indexes and unused columns in their table. I worked along with them doing a Comprehensive Database Performance Health Check.
(Jack Vamvas) Question: I’d like to execute a batch sql statement through SQL Server management studio multiple times and avoid using a loop statement or other similar constructs .
(Mohammed Moinudheen) We have a requirement to failover the primary SQL Server log shipping database to the secondary server and setup log shipping in the reverse direction. After the change, the SQL Server log shipping status report is showing failures.
(blobeater) An amazing blog post by Microsoft describing the idea of hot patching the database engine in Azure SQL Database to allow for minimal downtime when applying patches to SQL Server.
(Denny Cherry) If you’ve been a DBA for a while, you’ve heard people talking about PLE. PLE stands for Page Life Expectancy; most DBAs (and really anyone that works with SQL Server for more than 5 seconds) called it PLE.