Category Archives for Microsoft Azure

Azure SQL

Solved Azure SQL DB Connectivity Error

In this blog, we are going to cover Solved Azure SQL DB Connectivity Error You receive error messages when the connection to Azure SQL Database or Azure SQL Managed Instance fails. These connection problems can be caused by reconfiguration, firewall settings, a connection timeout, incorrect login information, or failure to apply best practices and design […]

Read More

𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐞 𝐓𝐚𝐬𝐤𝐬 𝐈𝐧 𝐀𝐳𝐮𝐫𝐞 𝐒𝐐𝐋 𝐒𝐞𝐫𝐯𝐞𝐫

🔗 In this 𝐒𝐐𝐋 𝐬𝐞𝐫𝐯𝐞𝐫 𝐬𝐜𝐫𝐢𝐩𝐭𝐢𝐧𝐠 monotonous tasks in Azure SQL for regular maintenance jobs and multi-instance administration. Automation of error and resource alerts. Configuration of notifications for failures. 🔗 𝐎𝐧-𝐩𝐫𝐞𝐦𝐢𝐬𝐞𝐬 𝐟𝐫𝐚𝐦𝐞𝐰𝐨𝐫𝐤𝐬 require cabling and racks of equipment to convey another data set(database) server. With cloud computing, this isn’t needed. 🔗 One of the significant […]

Read More

[Recap] Day 3: General Security & Network Security Features [Azure Fundamentals] [AZ-900]

General Security or Cloud security protects data stored in online cloud computing platforms from theft, leakage, and deletion. There are multiple ways one can achieve a better security such as firewalls, penetration testing, obfuscation, tokenization, VPNs etc. Network Security focuses on those tools that helps to protect data , applications and resources at the network […]

Read More
AZ900

[Recap] Day 2: Core Solutions And Management Tools On Azure [Azure Fundamentals] [AZ-900]

General Security or Cloud security protects data stored in online cloud computing platforms from theft, leakage, and deletion. There are multiple ways one can achieve a better security such as firewalls, penetration testing, obfuscation, tokenization, VPNs etc. Network Security focuses on those tools that helps to protect data , applications and resources at the network […]

Read More

𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐞 𝐐𝐮𝐞𝐫𝐲 𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐈𝐧 𝐒𝐐𝐋 𝐒𝐞𝐫𝐯𝐞𝐫

📌 Optimize Query Performance in SQL Server are potentially the most important aspect of database performance. It also provides the details on how to analyze individual query performance and also determine where improvement is needed. And the query performance also depends on the volumes of data and transaction concurrency. 📌 Executing the same query on […]

Read More

𝐓𝐚𝐛𝐥𝐞 𝐚𝐧𝐝 𝐌𝐚𝐭𝐫𝐢𝐱 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈

📌 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 is an excellent tool for graphical visualizations and the table and matrix visualization helps to display categorical variables with text labels in the report. 🚠 𝐓𝐚𝐛𝐥𝐞 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧 ➪ It consist of related data stored in rows and columns. Users can create tables in reports and cross highlight elements within the table. 📄 […]

Read More

𝐌𝐚𝐜𝐡𝐢𝐧𝐞 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠 𝐀𝐥𝐠𝐨𝐫𝐢𝐭𝐡𝐦𝐬 & 𝐔𝐬𝐞 𝐂𝐚𝐬𝐞𝐬

➽ The blog post- https://k21academy.com/dp10029 will cover the concepts of Machine Learning Algorithms & Use Cases in which we have covered the concepts of Machine Learning Algorithms and their use cases. ➽ This blog will help you to get started with 𝐃𝐞𝐬𝐢𝐠𝐧 & 𝐈𝐦𝐩𝐥𝐞𝐦𝐞𝐧𝐭 a Data Science Solution on Azure [DP-100] Certification. 👉𝗪𝗵𝗮𝘁 𝗜𝘀 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 […]

Read More

𝐀𝐳𝐮𝐫𝐞 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫 [𝐃𝐏203] 𝐐/𝐀 | 𝐃𝐚𝐲 8 𝐋𝐢𝐯𝐞 𝐒𝐞𝐬𝐬𝐢𝐨𝐧 𝐑𝐞𝐯𝐢𝐞𝐰

📌 This blog post will cover the Q/A’s from Day 8 of Microsoft Azure Data Engineering [Dp-203] Certification in which we have covered 𝐌𝐨𝐝𝐮𝐥𝐞 10: Real-time stream processing with Stream Analytics FAQs. 📌 This blog will help you to get started with Microsoft Azure Data Engineering [Dp-203] Certification. We will cover: 👉 Enable Reliable Messaging […]

Read More

𝐃𝐚𝐲 1 [𝐀𝐙900] 𝐀𝐳𝐮𝐫𝐞 𝐅𝐮𝐧𝐝𝐚𝐦𝐞𝐧𝐭𝐚𝐥𝐬: 𝐂𝐥𝐨𝐮𝐝 𝐂𝐨𝐧𝐜𝐞𝐩𝐭𝐬 𝐚𝐧𝐝 𝐂𝐨𝐫𝐞 𝐀𝐳𝐮𝐫𝐞 𝐒𝐞𝐫𝐯𝐢𝐜𝐞𝐬

☁️ 𝐂𝐥𝐨𝐮𝐝 𝐜𝐨𝐦𝐩𝐮𝐭𝐢𝐧𝐠 ➪ is a managed service offered by cloud vendors over the 💻 internet. It provides computing resources like applications, 💾 servers, data storage, development tools etc. 💡 𝐂𝐥𝐨𝐮𝐝 𝐃𝐞𝐩𝐥𝐨𝐲𝐦𝐞𝐧𝐭 𝐌𝐨𝐝𝐞𝐥𝐬 ➪ represent a type of cloud environment based on the storage size, access, purpose of the cloud to use etc. There are […]

Read More

𝐀𝐳𝐮𝐫𝐞 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈: 𝐒𝐭𝐞𝐩-𝐛𝐲-𝐒𝐭𝐞𝐩 𝐈𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧

💡 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 ➪ is a blessing for data visualization. Power BI has done massive 📈 growth in the past couple of years in the IT industry. But integrating Power BI with Azure provides much more stability and effortless visualizations 📄 🖥 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐈𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧 𝐰𝐢𝐭𝐡 𝐀𝐳𝐮𝐫𝐞 ➪ makes data processing:male-construction-worker: effortless and helps create […]

Read More