(Ben Nadel) For years, I’ve been advocating that people put DEBUG comments in their SQL statements to help identify performance bottlenecks in their applications.
Other News
Controlling table encryption in MySQL 8.0
(Gopal Shankar) MySQL 5.7.11 introduced InnoDB transparent tablespace encryption, which enabled support for file-per-table tablespaces, and this feature is discussed in this blog.
Simple DBCC CHECKDB process to report on database corruption for all SQL Server databases
(Alejandro Cobar) As DBAs, we all know how important it is to check all of the SQL Server databases under our care for potential corruption issues.
How long will my database upgrade take? Revisited …
(Mike.Dietrich) I received this question twice within a few days. And I remember that a tiny little while ago I wrote something on the blog about it.
C#: The Order of Interfaces Is Important for Casting Performance
(Thomas Claudius Huber) Recently there was a discussion in a Pull Request for the .NET runtime on GitHub. In the discussion it was mentioned by Jan Kotas from Microsoft that the order of interfaces is important for the casting performance.
Using MySQL Enterprise Audit Filtering for only Insert/Update/Delete statements for allUsers
(Chandan Kumar) Before i talk about MySQL Audit Filtering , it is more important to know below details:-
SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period
(Pinal Dave) One of the reasons, I love my job of SQL Server Performance Tuning Expert is that I get to learn every single day something new while working with my client on Comprehensive Database Performance Health Check. Recently I got a very unique situation where I had to Remove All Query Cached
How To Add TreeView Component In React Application
(Sanwar Ranwa) In this article, we will learn how to add TreeView component in React applications. A tree view is used to display a hierarchical list of data. In this demo we use React material UI Treeview component.
How to handle employees challenging me?
As a manager, how can I deal with millennial employees challenging me? The issue is not that you have millennial employees challenging you. It is how you are presenting yourself and managing your projects and teams. It is easier to change your mindset than to change others. And with your changes, other changes will appear. For instance, start appreciating that...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Import Databases to Azure SQL Database
(John Sterrett) I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database.