(James Serra) There are a number of options for monitoring Power BI that I wanted to mention:
Other News
Find Indexes Used In Query Store
(Grant Fritchey) One of the most frequent questions you’ll hear online is how to determine if a particular index is in use. There is no perfect answer to this question.
Tips for using data types in SQL Server 2019 (Part 2)
Tips for using data types in SQL Server 2019 (Part 2) Use Table data type instead of temporary tables whenever possible. A Table data type is a special data type that used for temporary storage of a set of rows. In comparison with the temporary tables, table variables have some benefits. For example, table variables are cleaned up automatically at...
How To Export Data In EXCEL, PDF, CSV, Word, JSON, XML And Text File In MVC Application
(Jignesh Kumar) This article demonstrates how to export functionality with different types of file formats like excel, pdf, word, csv, json, xml and text files using a .net MVC application. I have implemented the most frequently used file format to export data in real time projects.
SQL SERVER – Last Page Insert PAGELATCH_EX Contention Due to Identity Column
(Pinal Dave) Resolving the Last Page Insert PAGELATCH_EX Contention Due to the Identity Column is always a topic to be discussed during my Comprehensive Database Performance Health Check. I will discuss the solution the future blog posts, our today’s goal is to understand what is the Last Page Inser
MySQL Security – Password Verification-Required Policy
(Olivier Dasini) When thinking about security within a MySQL installation, you can consider a wide range of possible procedures / best practices and how they affect the security of your MySQL server and related applications.
VS Code Java Tool Updates Debugging, Refactoring
(David Ramel) The monthly update to the tooling that boosts Java development in the open source, cross-platform Visual Studio Code editor highlights debugging, refactoring and more.
Creating Squishy Tabs With CSS Flexbox In Angular 9.1.7
(Ben Nadel) At work, my team is starting to ideate on a new user interface (UI) that has a tabbed navigation. The set of tabs in this navigation is going to be driven by user-provided content and preferences.
Running Azure Functions in a Docker Container
(Abhijit Jana) Azure Functions let us execute our code in a serverless environment. This does not require to create a solution or publish it as Azure Apps. In short, just focus on code and your functional aspect, and don’t need to worry about infrastructure.
12.1 Dataguard Multiple Standby Databases Switchover Using DGMGRL
(mdinh) Followup from How To Create New Standby Using Active Standby Duplication From Existing Standby