Power BI Filter Pane
Data Filtering | Configurations - In this tip we look at a new feature in Power BI that allows users to filter data in Power BI reports using the new Filter Pane.
2019-11-29
Additional Articles
Accelerating Database Recovery with SQL Server 2019
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”. Read on....
2019-11-28
Finding Correlated Rows Using EXISTS or COUNT
Should you always use EXISTS rather than COUNT when checking for the existence of any correlating rows that match your criteria? Does the former really offer "superior performance and readability". Louis Davidson investigates.
2019-11-28
Introduction to DevOps: 10 Guidelines for Implementing DevOps
In this last article in the series, Robert Sheldon discusses ten guidelines that will help organisactions implement DevOps successfully.
2019-11-27
Introduction to the Partition By Window Function
Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!
2019-11-26
Making the switch to SQL Monitor
Australia and New Zealand’s leading cloud account software provider Xero needed a cost-effective monitoring solution with better features and coverage. Read Xero’s story about how they switched from their old monitoring tool to Redgate’s SQL Monitor.
2019-11-26
Understanding Auctions
We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the many different types of auctions and how they work.
2019-11-25
Recover SQL Server Resource Database
SQL Server Post Update Failure | Troubleshooting - In this tip we look at the steps to recover missing SQL Server mssqlsystemresource database files that cause SQL Server not to startup. This can occur when an update to SQL Server does not complete successfully therefore making these files absent from the folder where they need to reside.
2019-11-22
SQL Clone PowerShell Scripting: The Basics
Phil Factor demonstrates some simple examples of how to use SQL Clone's PowerShell library to pass objects between cmdlets, and simplify common tasks, such as creating and deploying clones from various images. He then documents the objects and cmdlets, and illustrates their inputs and outputs.
2019-11-22
How to Think Like the SQL Server Engine: Using Statistics to Build Query Plans
Every index has a matching statistic with the same name, and each statistic is a single 8KB page of metadata that describes the contents of your indexes. Stats have been around (and been mostly the same) for forever, so this is one of the places where SQL Server’s documentation really shines: Books Online has a ton of information about statistics. You honestly don’t need to know most of that – but if you wanna make a living performance tuning, there’s a ton of great stuff in there.
2019-11-21
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Tips Cara mudah menghubungi Halo bca (+62 821°3111°179
Dukungan Nasabah Halo BCA Call CSO (+62 821~3111179) untuk layanan live chat whatsapp customer...
BCA KCU SEMARANG Call CSO; (+62 821°3111°179
Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
BCA KCU THAMRIN Call CSO; (+62 821°3111°179
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers