(Greg Larsen) As a DBA it is important to have a toolbox that supports the work you do. You need to have a toolbox that allows you to work smarter instead of harder.
Tag: sql server
Identify Poorly Performing Query Plan Operators – Analyzing SQL Server Query Plans – Part 2
(Pinal Dave) I recently released a Pluralsight Course Analyzing SQL Server Query Plans, and it is really doing great in terms of viewership and I have received some really great comments and feedback about this course. This week, I will be discussing different aspects of Analyzing SQL Server Query P
Troubleshoot Slow RDS SQL Servers with Performance Insights
(Sadequl Hussain) Amazon RDS SQL Server now supports Performance Insights. How can we use it to troubleshoot SQL Server performance bottlenecks?
#PowershellBasics: The GetType() and GetTypeCode() methods
(Kenneth Fisher) I’m a DBA. Data types are kind of important to me. I mean I know they are important to developers as well but spend some time as a DBA and they get really important. That makes these two methods of particular interest to me.
Azure Synapse Analytics new features
(James Serra) Almost lost in all the announcements from Ignite was a bunch of amazing new features that were added to the Provisioned Resources/SQL Pool section (read SQLDW functionalities) side of Azure Synapse Analytics (formally called Azure SQL Data Warehouse).
Capture Query Plans Using Extended Events and Traces – Analyzing SQL Server Query Plans – Part 1
(Pinal Dave) I recently released a Pluralsight Course Analyzing SQL Server Query Plans, and it is really doing great in terms of viewership and I have received some really great comments and feedback about this course. This week, I will be discussing different aspects of Analyzing SQL Server Query P
You Are A Coder
(Grant Fritchey) So, you say you’re a DBA. I say you’re not. You say you’re a system administrator. I say you’re wrong. We are all coders now. Every single one of us.
Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE
(Diana Moldovan)Sometimes you need to quickly reference the content of an Excel file in a SQL Server T-SQL script, however, this may not be as simple as it seems. In this tip I’ll offer solutions for a few of the most common problems that may affect you when trying to read an Excel file using OPENRO
Power BI Report Builder And RSCustomDaxFilter
(Chris Webb) If you’re building DAX queries using Power BI Report Builder you might notice something that looks like a new DAX function called RSCustomDaxFilter.
SQL SERVER – Stored Procedure and RETURN Keyword
(Pinal Dave) Earlier today while working on Comprehensive Database Performance Health Check, we landed up a very interesting situation where we had to debug a stored procedure.