(SQLDBAWithABeard) First I must say thank you to all of the wonderful people who have put time and effort into providing free tools and scripts to enable not only myself but all SQL DBAs to ease their work.
Tag: sql server
Creating Dashboards for Mobile Devices with Datazen – Part 2
(Arshad Ali) With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 Enterprise Edition or later with Software Assurance, you can leverage (download and use) Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional co
Connecting to Analysis Services From Power BI Website, Power BI Designer, and Excel (Part 4)
(Melissa Coates) Welcome to part 4 of a 4-part series on using the SSAS Connector with the new Power BI Preview. This information is as of early June 2015 and will definitely change as the Power BI Preview evolves.
Using Microsoft DiskSpd to Test Your Storage Subsystem
(Glenn Berry) Previously, I covered the basics of storage subsystem metrics and testing in my article Analyzing I/O Subsystem Performance for SQL Server, including an introduction of CrystalDiskMark 4.0. CrystalDiskMark was recently rewritten to use Microsoft DiskSpd for its testing, which makes it
SQL SERVER – Identifying Blocking Chain Using SQL Scripts
(Pinal Dave) There are a number of blog posts that have been written on this very topic. This can be from basics to almost advanced in many ways. I am outlining some of them here below:
Connecting to Analysis Services From Power BI Website, Power BI Designer, and Excel (Part 4)
(Melissa Coates) Welcome to part 4 of a 4-part series on using the SSAS Connector with the new Power BI Preview. This information is as of early June 2015 and will definitely change as the Power BI Preview evolves.
Using Microsoft DiskSpd to Test Your Storage Subsystem
(Glenn Berry) Previously, I covered the basics of storage subsystem metrics and testing in my article Analyzing I/O Subsystem Performance for SQL Server, including an introduction of CrystalDiskMark 4.0. CrystalDiskMark was recently rewritten to use Microsoft DiskSpd for its testing, which makes it
SQL SERVER – Identifying Blocking Chain Using SQL Scripts
(Pinal Dave) There are a number of blog posts that have been written on this very topic. This can be from basics to almost advanced in many ways. I am outlining some of them here below:
SQL Server – Capture Execution Plan of a Currently Running Query/Process SPID
(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:
Automated Backups of SQL Server Databases in Azure IaaS VMs
(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.
