(James Serra) As a follow-up to my last blog, Azure Synapse Analytics & Power BI performance, I wanted to focus on concurrency when using these two products.
Author: SSWUG Research
Send an alert when the database state changes to SQL Server single-user mode
(Nisarg Upadhyay) This article explains the SQL Server single-user mode and how to configure an automated email alert when the state of the user database changes to the single-user mode. To send an alert, we will create a DDL trigger that executes when the user runs the ALTER DATABASE query.
Learn About Reactive Forms In Angular
(Mohammad Irshad) In Angular, the reactive forms are use to create the forms in which the code and logic resides in the component class.
SQL SERVER – Parameter Sniffing and OPTIMIZE FOR UNKNOWN
(Pinal Dave) I consider myself fortunate that I often receive a follow-up question from my earlier blog posts. Today we will discuss Parameter Sniffing and OPTIMIZE FOR UNKNOWN. In the earlier blog post, I had discussed how one can avoid the parameter sniffing by declaring the local parameter.
Announcing Obfuscated Column Data Loading with SLOB
(Kevin Closson) I announced availability of SLOB 2.5.2.2. It is primarily a small bug fix release but also has an undocumented new feature.
MySQL InnoDB Cluster 8.0 – A Complete Operation Walk-through: Part Two
(Ashraf Sharif) In the first part of this blog, we covered a deployment walkthrough of MySQL InnoDB Cluster with an example on how the applications can connect to the cluster via a dedicated read/write port.
A HighlightJs Copy Code Badge Component
(Rick Strahl) A while back I created a small addon component for use with HighlightJs that provides the ability to copy a code snippet and display the active language in a little badge above the code snippet.
Query AWS Athena Data from SQL Server
(Maria Zakourdaev) Every cloud provider has a serverless interactive query service that uses standard SQL for data analysis. As for the biggest cloud providers, we have Azure Data Lake analytics, Google BigQuery and AWS Athena. Due to the fact that my company is using only AWS, I am greatly enjoying
Datapump Import Partitioned Tables ORA-00600 qesmaGetPamR-NullCtx
(Bobby Durrett) I have not yet had time to build a test case and prove this out, but I wanted to document one last bug that we found so far in our 11.2.0.4 to 19c upgrade.
MySQL Shell Plugins: check
(Frederic Descamps) As you may know, it’s now possible to create your own plugins for MySQL Shell. See the following posts: