MSSQLTips.com

Kubernetes, Partitioning, Encryption, Auditing, and much more (MSSQLTips - Articles by Real People) How to Deploy SQL Server on Kubernetes running on Windows >>> https://lnkd.in/eJM-is-S How to Partition an existing SQL Server Table >>> https://lnkd.in/eGa79SUX Troubleshooting High CPU Utilization in SQL Server >>> https://lnkd.in/eMdcjUtw Display SSRS Report in .NET Core Application >>> https://lnkd.in/es2AdBFh SQL Server Column Encryption and Decryption with Code Examples >>> https://lnkd.in/edZkvbCq Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches >>> https://lnkd.in/e2dDYpsc Create Custom Audit Specifications using SQL Server Audit >>> https://lnkd.in/eQUjUsaZ Upgrading SQL Server databases and changing compatibility levels >>> https://lnkd.in/exssxPyZ Identify SQL Server TCP IP port being used >>> https://lnkd.in/eFEwZYky

SQL Jobs Frequently Asked Questions and Answers by Hristo Hristov, MSc >>> https://lnkd.in/exQjsbyV This document aims to provide answers to some frequently asked questions about finding a job that requires SQL and relational databases skills in general. We have grouped the questions into three broad categories: SQL jobs, certifications, and interviewing. This article focuses on SQL jobs.

Understanding Query Performance Issues Caused by Local Variables in SQL Server by Mehdi Ghapanvari >>> https://lnkd.in/ebWRWQGC When you declare a variable inside a procedure, assign a value to it, and then use it in a query to filter results, the estimated number of rows will be wrong and can result in an incorrect memory grant. If the estimated number of rows is lower than the actual number of rows, an underestimation problem occurs, which can cause a spill to disk. This means that SQL Server has to write the data into tempdb and then read it from there, and this operation usually reduces query performance. Spill to disk is a costly operation, and you can learn more about it in Correct SQL TempDB Spills in Query Plans Caused by Outdated Statistics.

How to Deploy SQL Server on Kubernetes running on Windows by Deepak Vohra >>> https://lnkd.in/eJM-is-S When using Kubernetes on Windows 10/11, we cannot directly install Kubernetes because it does not provide Kubernetes control plane binaries for all required components such as the Kubernetes API Server. Therefore, we cannot run SQL Server with Kubernetes on Windows as we can on Linux.

Improve Query Performance in the Fabric Warehouse with Clustering by Koen Verbeeck >>> https://lnkd.in/esTPz7B7 We are building a large warehouse in Microsoft Fabric using the warehouse. Our biggest fact tables have some performance issues when we are running our analytical queries, and it seems we cannot use indexes in the Fabric Warehouse. Is there some way to improve performance?

Cut Your SQL Server Cloud Costs in 2026: Smarter Deployment & Licensing Strategies You Can Use Now >>> https://lnkd.in/e_DJRx3M Cloud costs are rising fast—and SQL Server is often one of the biggest line items. This free MSSQLTips webcast breaks down the smartest ways to make SQL Server dramatically more affordable in 2026. Learn how to choose the right cloud deployment model, avoid common licensing traps, and right‑size your SQL workloads for real savings. If you’re responsible for SQL Server in AWS, this session shows you exactly where the hidden costs are—and how to eliminate them.

Master SQL Server I/O and Fix Performance Issues Faster Than Ever >>> https://lnkd.in/e8Ku9KGG Unlock the missing piece of your performance‑tuning skillset. This webcast demystifies SQL Server’s I/O behavior, explains how data moves through the engine and hardware, and teaches you how to triage bottlenecks with precision. Learn from industry veteran Andy Yun and level up your tuning game instantly.

Machine Learning in SQL Server, Split Strings, SQL Predicates and SSL Encryption (MSSQLTips - Articles by Real People) Machine Learning Binary Classification Performance in SQL Server >>> https://lnkd.in/eAx8VKdi How to configure SSL encryption in SQL Server >>> https://lnkd.in/ejYJXarG Split Delimited String into Columns in SQL Server with PARSENAME >>> https://lnkd.in/edeEFRuy Picking the ON or WHERE Clause for the SQL Predicate >>> https://lnkd.in/eErH8ZGz Using REGEXP_COUNT to Count Strings in SQL Server 2025 >>> https://lnkd.in/enVjkwuS Enabling Academic Research with Real-World Data Sets >>> https://lnkd.in/ee5uH_Be Using local Large Language Model OLLAMA with SQL Server >>> https://lnkd.in/ec-kwYcW Query SQL Server Agent Jobs, Job Steps, History and Schedule System Tables >>> https://lnkd.in/ezwN9Y_x Enterprise SQL Server Performance Tuning and Management >>> https://lnkd.in/ejDWQ39S

Display Active Slicers in Power BI using Dynamic DAX by Aigbe Omorodion >>> https://lnkd.in/exZirAUQ One of the most common challenges in leveraging a complex Power BI solution is a lack of visibility into what filters have been applied on the reports. Report users would ideally want to know at a glance what slicers have been applied. This is particularly where there are multiple slicers on the same report page. Although, this is not a new concept, there have been loads of blogs and YouTube videos done to demonstrate how to achieve this goal. Some include the use of external tools like DAX Studio to generate the DAX code. However, I have written this post to demonstrate an optional step-by-step approach to solving this user experience challenge. I will walk through a scalable DAX pattern to dynamically display in a clean and readable format for the slicers selected in a report page.

Download and Install Visual Studio 2022 for Data Professionals by Jan Potgieter >>> https://lnkd.in/eAgh4kby When installing Visual Studio 2022, most data professionals assume that SSRS report development is included as part of the standard setup. After the installation, they quickly realized that the Reporting Services project templates are nowhere to be found. This creates unnecessary confusion, especially for those who were used to older versions of Visual Studio where SSRS support was included automatically.