(Siddharth Mehta) Measuring progress over time is a standard project management activity. Projects that are executed in an agile manner typically using the agile methodology have more frequent needs to track progress over time than projects that are executed using a waterfall model. In the agile met
Tag: sql server
Power Query Performance And Expanding Columns
(Chris Webb) As a footnote to my previous post on storing large images in Power BI, I thought all you M nerds out there would be interested to read about a strange performance quirk I noticed while writing the code for that post.
SQL Server in Azure Kubernetes Service (AKS)
(Ranga Babu) In this article, we will review how to create a Kubernetes cluster in Azure Kubernetes Service, provision the persistent volume to store the database files and deploy SQL server on Kubernetes cluster.
Troubleshooting Variable Memory Grants in SQL Server
(Erin Stellato) One of the more perplexing problems to troubleshoot in SQL Server can be those related to memory grants.
SQL SERVER – Script to Enable PAGE and ROW Level Compression – Disable Compression
(Pinal Dave) At midnight I got a call from a customer who earlier availed my service Comprehensive Database Performance Health Check. The issue which they were facing were sudden high CPU for their SQL Server.
Get All the Tables with a Count of Their Records
(Hannes du Preez) Get all the tables with a count of their records with the following query:
What is a distributed transaction?
(Kenneth Fisher) A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example I gave in that post was pretty straightforward. Transferring money between two individuals.
How to Find Keywords in SQL Server Stored Procedures and Functions
(Tim Ford) How many times have you had to troubleshoot or make changes to an existing database that is not documented properly or completely? Even need to look for a specific stored procedure that references a specific table or process?
SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)
(Pinal Dave) I recently had a very simple and interesting error received while I was working with Docker and Persistence Storage for my upcoming SQL Server Performance Tuning Practical Workshop.
Power BI Key Influencers Visual
(Scott Murray) What is the Power BI Key Influencer Visualization and how should I use it?
