(Pinal Dave) Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their various SQL Server performance issues, I
Tag: sql server
Power Query Memory Usage, Dataflow Container Size And Refresh Performance
(Chris Webb) When Power BI dataflows were officially released a few weeks ago there was a new setting for Premium capacities mentioned briefly in the announcement blog post: Container Size.
Sending SentryOne Data to the Azure SQL Database DTU Calculator
(Paul White) Have you ever contacted Microsoft or a Microsoft partner and discussed with them what it would cost to move to the cloud?
SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions
(Ray Barley) I noticed the Lookup function in SQL Server Reporting Services. This sounds like something that I’ve needed for quite some time. Can you provide an example of how I can use this?
Rebuild All Database Indexes
(Hannes Du Preez) You can rebuild all indexes present in your database with the following query:
It’s all just data.
(Kenneth Fisher) Tables, stored procedures, views, logins, constraints, etc, etc. It’s all just data. In every database system I’ve ever worked on there are system tables underneath everything that contain 99% of all of the metadata.
Updated Analytics and Big Data Comparison: AWS vs. Azure
(Thomas LaRock) Building upon my earlier post, today I want to share with you the updated graphic and links for the analytics and big data services offered by Microsoft Azure and Amazon Web Services.
SQL SERVER – Docker Volume and Persistent Storage
(Pinal Dave) I have received some rave reviews of my article on SQL SERVER – How to Get Started with Docker Containers with Latest SQL Server?. It was amazing to hear that people really get started after reading my article on docker.
Create Power BI Connection to Azure SQL Database
(Rahul Mehta) With the evolution of the cloud, data is widely stored in different formats in the cloud. One of the popular platforms is Microsoft Azure and data is stored using Azure SQL Database.
SQL SERVER – Audit Script to Get CPU and Memory Information with MAXDOP Guidelines
(Pinal Dave) If you are reading this blog regularly the name of Dominic Wirth may not be new for you. He has in the past sent some very interesting scripts for audit for our blog and I am including his new script in this blog which is about how to Get CPU and Memory Information with MAXDOP Guideline