Khaled Farghaly’s Post

#AzureDaily 🚀Discover #Azure SQL DB License-Free Standby Replica! Improve high availability and cost efficiency with free secondary replicas, automatic failovers, and streamlined license management. Watch Data Exposed to learn more! #MicrosoftAzure #SQLDatabase #DataExposed #cloudcomputing ⛅

I'm excited to share my latest video on "Data Migration from Local Systems to Azure SQL Database Using Bacpac Method". 🎥✨ In this tutorial, I cover the step-by-step process of migrating your database using the Bacpac method: 1. Export Database to Bacpac File: Learn how to export your local SQL Server database into a Bacpac file using SQL Server Management Studio (SSMS). 2. Upload Bacpac to Azure Blob Storage: Discover how to upload the Bacpac file to Azure Blob Storage for easy access and transfer. 3. Import Bacpac File to Azure SQL Database: Follow along as I guide you through importing the Bacpac file into Azure SQL Database and configuring your settings. 4. Verify the Imported Database: Ensure your data has been accurately imported and is ready for use in Azure. This method is simple, portable, and compatible with various SQL Server versions and Azure SQL Database, making it a powerful tool for your data migration needs. https://lnkd.in/gk_q9hRB Watch now to streamline your data migration process and take full advantage of Azure's robust capabilities. #Azure #DataMigration #SQLDatabase #TechTutorial #AzureSQL #Bacpac #CloudComputing #DataManagement #SQL #YouTubeTutorials #TechSkills

Check out our new doc on #SQL #Databases with Scaleway #Serverless! Whether you're new or experienced, our guide covers what you need to leverage serverless databases effectively 👀🔗 https://ow.ly/yQZG50Smnzq

Learn to query #AzureCosmosDB with the SQL API in this comprehensive training module. Enhance your data querying skills: https://lnkd.in/eh7jrzPf 🚀📘

SQL Server's application-level locking functions offer a robust framework for managing exclusive access to critical operations within an application. By judiciously applying sp_getapplock, sp_releaseapplock, and APPLOCK_TEST, developers can safeguard their applications against concurrency issues, ensure data integrity during crucial updates, and maintain a high level of application stability and reliability in production environments. 

Very insightful article on measuring and viewing execution statistics for SQL databases. The information learned from this query can be used by DBAs to optimize queries especially in enterprise situations. #SQL #databases #azure

**Tool Spotlight! 🔦**  SQL Server Data Tools (SSDT) offers a comprehensive development environment for building, testing, and deploying SQL Server databases. Discover its features now! 🚀 - **Schema Compare**: Easily compare and update database schemas. 🔄 - **Database Projects**: Manage your database development in a source-controlled project. 📂 - **Integrated Testing**: Write and run unit tests directly in SSDT. 🧪 - **Database Refactoring**: Rename database objects with confidence. 🛠️ - **Publish to Azure**: Seamlessly deploy your databases to Azure SQL Database. ☁️ Learn more about SSDT here: Watch Video 🎥 https://lnkd.in/dsBnNupd Which SSDT feature do you find most useful? Share your thoughts below! 💬👇 #ToolSpotlight #SQLServer #SSDT #DatabaseDevelopment #DatabaseTesting #AzureSQL #TechTools #DeveloperLife #SQLTips #DataManagement #DatabaseDeployment #TechCommunity #CodeConfident #DevOps #DatabaseProjects #DatabaseRefactoring

JSON Type & Aggregates Public Preview in Azure SQL Database | Data Exposed. The native JSON type allows JSON documents to be stored in a binary format. This binary format allows for efficient query processing and in-place modifications of JSON documents. The JSON aggregates - JSON_OBJECTAGG & JSON_ARRAYAGG enable easy aggregation of relational data into a JSON document. Learn more in this episode of Data Exposed with Anna Hoffman and Umachandar Jayachandran.   Watch on Data Exposed    Resources: JSON data type (preview) - SQL Server | Microsoft Learn JSON_OBJECTAGG (Transact-SQL) - SQL Server | Microsoft Learn  JSON_ARRAYAGG... #techcommunity #azure #microsoft https://lnkd.in/gFuDYg8h

🚀 Day 2: Demystifying SQL Execution! 💻 🎈 Process of SQL: When we are executing the command of SQL on any Relational database management system, then the system automatically finds the best routine to carry out our request, and the SQL engine determines how to interpret that particular command. 🎈 Structured Query Language contains the following four components in its process: 🎐 Query Dispatcher 🎐Optimization Engines 🎐Classic Query Engine 🎐SQL Query Engine, etc. see more: https://lnkd.in/dywYnmx7 #DataEngineering #DataAnalytics #sql #sqllearning #aws #azure #databricks Mode for better reach: Sumit Mittal Darshil Parmar Sagar Prajapati

Tuning Databases in One Day by Brent Ozar Friday, September 13 UC San Diego (UCSD) Extended Studies - University City Center All-day training info: You've got production databases in SQL Server or Azure SQL DB, and you want to make 'em faster. Could you identify the database's bottleneck, prove the root cause, and recommend fixes? You want to make the right choice for each bottleneck - should you do index changes, query tuning, or server-level settings? The class will be a mix of 50% slides, and 50% live demos, with plenty of time for Q&A. We'll even cover 3 sample client findings for the most common performance issues so you can see how I explain the problems to my clients and give them proof. Speaker Info: I'm Brent Ozar, and I do this for a living. In one day, I'll teach you the same techniques I use with my clients. I can't teach you everything about what I do in one day - but I'll teach you the most important stuff. https://lnkd.in/g7xfXtnH #sandiego #sqlsatsd #sqlserver #1daytraining #performancetuning #pto #azuresqldb #databases #azure