Phoenix Software Limited’s Post

A few months ago I announced that I had created maxgrant, a simple tool to generate grants for MariaDB MaxScale use. This is a part of setting up MariaDB MaxScale that is somewhat painful and I think the tool is useful. The Version 1.0 and 1.1 were less helpful than I wanted though, basically you had to provide the information you wanted to generate grants for on the command line, which was a bit awkward and clunky. I have now created version 2.0 which is rather different, the way this works now is that maxgrant gets what it needs from the MariaDB MaxScale configuration files and then generates the grants. The process now to set up MariaDB MaxScale is to configure it using the usual configuration file and then run maxgrant specifying a suitable server that has been configured and then maxgrant will read the data related to this server and generate the grants, quite convenient if you ask me. Get it here and there is also a basic document in the 2.0 directory: https://lnkd.in/dxbmfkPp

Scenario Based Interview Question: YOU JOINED A NEW PROJECT. YOU WERE GIVEN ACCESS TO ONE SQL SERVER. YOU WERE GIVEN WITH ONE SQL SERVER NAME, SQL AUTHENTICATION DETAILS : LOGIN, PASSWORD. YOU CONNECTED TO THE SERVER FROM SSMS TOOL. HOW DO YOU IDENTIFY WHETHER IT IS AN ON-PREMISE (NON CLOUD) SQL SERVER OR AZURE SQL SERVER (LOGICAL SERVER) ? ANSWER: Identify based on 1. SERVER NAME 2. VERSION NUMBER 3. SQL AGENT 4. MANAGEMENT FOLDER 5. REPLICATION 6. PROPERTIES 7. OS DEPENDANCY For more such videos: 1. Follow us on #youtube Channel : https://lnkd.in/geU8ex4X 2. Join us #whatsapp Channel : https://lnkd.in/gQavxm3d 3. Join our #linkedin Page: https://lnkd.in/gu-Kv8Q2

Lesson Learned #498:Understanding the Role of STATMAN in SQL Server and Its Resource Consumption. Today, I worked on a service request that our customer reported a performance issue and they reported that this query: SELECT StatMan([SC0], [LC0], [SB0000]) FROM (SELECT TOP 100 PERCENT [SC0], [LC0], step_direction([SC0]) over (order by NULL) AS [SB0000] FROM .. TABLESAMPLE SYSTEM (@samplePercent PERCENT) WITH (READUNCOMMITTED) ) AS _MS_UPDSTATS_TBL_HELPER ORDER BY [SC0], [SB0000] ) AS _MS_UPDSTATS_TBL OPTION (MAXDOP 16, RECOMPILE). I would like to share my lessons learned here.   It is important to mention that STATMAN is not a... #techcommunity #azure #microsoft https://lnkd.in/g54zTf6Q

Now that HeatWave MySQL is part of the Always Free Tier at Oracle Cloud , you might want to know how you can spin up an instance. There's a MySQL Short for that. #mysql #oraclecloud https://lnkd.in/eUfsb_Rr

Lesson Learned #497:Understanding the Ordering of uniqueidentifier in SQL Server. Today, I worked on a service request that our customer asked about how SQL Server sorts the uniqueidentifier data type. We know that uniqueidentifier store globally unique identifiers (GUIDs). GUIDs are widely used for unique keys due to their extremely low probability of duplication. One common method to generate a GUID in SQL Server is by using the NEWID() function. However, the ordering of GUIDs, especially those generated by NEWID(), can appear non-intuitive. I would like to share my lessons learned how to determine the ordering method using... #techcommunity #azure #microsoft https://lnkd.in/g2MSXS3z

I’m excited to share a recently published article on SQL Server licensing with Azure Arc! The article outlines three key licensing options for Arc-enabled SQL Server: - License by virtual cores - License by physical cores (p-cores) without virtual machines - License by physical cores with unlimited virtualization Check it out to learn more about choosing the right option for your environment! https://lnkd.in/gPBDwNwk

Dive into the key differences between on-premises and cloud-managed SQL Server solutions! Learn how XTIVIA's Virtual-DBA services can help you choose the best option 📊🔍. Click here to read: #Cloud #DataAdministration #SQLServer https://bit.ly/3XTbgkW