📢 How to Delete Entire #MySQL#Database
Welcome our new blog article by Nisarg Upadhyay
💡 Article shows different ways of how to delete a database in MySQL with the help of MySQL command-line utility and #MySQLWorkbench.
☑️ Read in full:
https://t.co/xPBkXAJcJ8
📢 How to Auto-trigger #AWS Lambda Functions
Our new blog article by Aveek Das is out now!
💡 This step-by-step tutorial explains how to create automated schedules using the #CloudWatch Rules and auto-trigger #AWSLambda functions.
✅ Full article:
https://t.co/8grOe4LbCs
📢 "Connecting a Bastion Server to a #PostgreSQL Server via SSH Tunnel" by Theodoros Karasavvas
💡 Learn how to connect a bastion server to PostgreSQL server via #SecureShell Tunnel to lower the level of the private network exposure.
☑️ Read in full:
https://t.co/HryqREH6KB
📢 "How to Create a Table with Multiple #ForeignKeys and Not Get Confused" by Ben Richardson
💡 Article explains how to add multiple foreign keys to the same table in #SQLServer using the #SQLqueries to add foreign keys.
☑️ Read in full:
https://t.co/jv5Is9P24t
📢 "Troubleshooting Issues when Working with Date and Time in #SQLServer" by Ben Richardson!
💡 Article focuses on troubleshooting some of the most common issues that you might face while working with the #SQL time and date #datatypes.
✅ Read in Full: https://t.co/7kEjiGeA0Y
🚀 Welcome our blog article by Josip Saban “Storing Binary #DataTypes in #SQLServer
What’s in:
🔹 Manual Value Conversion Using CAST()
🔹 Using Conversion Styles with CONVERT()
🔹 Difference Between BINARY and VARBINARY
👉 Read in full:https://t.co/g2cDpBXweT
🚀 We'd like to share a blog article by Theodoros Karasavvas “How to Protect #MySQL#database from Ransomware Campaigns”
📑 Article describes how to protect your MySQL database from ransomware attacks.
👉 Read in full: https://t.co/35ofQo9DZp
📢 Converting DateTime to YYYY-MM-DD Format in #SQLServer
Our blog article by Ben Richardson is out now!
✅ Full article is available by the link: https://t.co/pq1bu84Bwh
📢Stored Procedure to Get the Latest Database Backups Status
The blog article by Alejandro Cobar is out now!
💡 Deploy this SP in every #SQLServer instance and check the latest #database#backup information (System and User databases).
✅ Full article:
https://t.co/TdUnaIxx9r
📢 Managing your #MSSQL#Replication
Our blog article by Carla Abanes is out now!
💡 Article shows tips and #TSQL scripts for you to use when you need to check many #SQLAgent jobs are created after the replication configuration.
✅Read in full:
https://t.co/B9XntIOIbg
📢 Advanced Analytics with #Oracle#DataAnalytics – Handling with Express Builder Functionality
The lat part of the Advanced Analytics series by Dung Dinh is out now!
✅ Full article is available by the link: https://t.co/n9GGAv0ilQ
🚀 Welcome our blog article by Josip Saban “Understanding #SQL Server Database Errors”
This article focuses on both #SQLServer#database errors handling and transactions with the help of TRY-CATCH statement. Learn on examples!
👉 Read in full: https://t.co/KSLIlRuutX
📢 "How to Create and Configure #MicrosoftAzure#DevOps CI/CD #Pipeline Agent" by Vitalii Zaichenko
💡Article describes how to create and setup self-hosted or Microsoft-hosted #Azure DevOps CI/CD Pipelines Agent.
☑️ Read in full:
https://t.co/xLWcMFLS7o
A #PowerShell Tool to Get the Status of #SQLAgent Jobs by Alejandro Cobar
Article will help you to quickly check the current status of #SQLServer Agent jobs, either inventory or just the last execution status
Read in full to get more info: https://t.co/hgGfAqx77w
📢 Easy Answers to 5 Vital Questions about Composite #Index in #SQL .
Welcome our blog article by Edwin Sanchez.
💡 This article explains what is composite index in SQL and when to use one on examples.
☑️ Read in full to get more info:
https://t.co/Ur5WVAPb6P
📢 The #CartesianProduct in SQL
Welcome our blog article by Philipp Zhenov
💡 Learn what a Cartesian Product in #SQL is and how to apply it on practice. Find out why it's better to avoid using it in specific cases.
☑️ Read in full to get more info: https://t.co/22mzLFTbb8
🚀 We’d like to share our blog article by Ben Richardson “How to Download and Install SQL Server Express Edition?”
📑 Article describes step-by-step process for downloading Microsoft #SQLServer Express Edition and Microsoft #SSMS
Read in Full: https://t.co/Ovbaf57j7v
🚀 Welcome our blog article by Tomas Helgi Johannsson “#MySQL and #MariaDB#Backup and Restore Strategy with Best Practices”
Explore the main types of how to backup and restore MySQL/MariaDB database. Check for best practices and examples!
Link: https://t.co/LeEpet7x2G
🚀 Welcome our blog article by Nisarg Upadhyay “Renaming Indexes with sp_rename Procedure”
👉 Read in full:https://t.co/dWGZ9gqiS2
#sqlindex#storedprocedure#SQL#sqldeveloper