(blobeater) This is by no means a complete list but more of a personal list of features I have seen not setup or just missed out when looking at Azure SQL DB.
Tag: sql server
Azure Data Factory Get Metadata Example
(Fikrat Azizov) In a previous post (Lookup activity), we discussed Lookup activity to read the content of the database tables or files. ADF also has another type of activity: Get Metadata activity, which allows reading metadata of its sources. We are going to explore the capabilities of this activit
Bridges Between Servers
Many times as you build out environments, you’re left pulling information from different SQL Servers and different sources, so you can assemble it in a common location. This may be the case where you’re pulling information from a SQL Server, a MySQL server, Oracle and other systems, so you can create reporting and analytics runs at the information. These bridges […]
Encrypting passwords with Python Scripts in SQL Notebooks of Azure Data Studio
(Rajendra Gupta) This article explores the Python scripts for encrypting and decrypting passwords in SQL Server using Azure Data Studio SQL Notebooks.
SQL SERVER – SQL Azure Managed Instance Restore Error – The Database Was Backed Up on a Server Running Version 15.00.2000
(Pinal Dave) Based on the current trend of moving to the cloud platform, there have been many new learnings for me. One of my clients migrated to SQL Azure Managed Instance and contacted me for an interesting situation.
Help! My restore has finished but the database still has a status of recovering.
(Kenneth Fisher) I’ve been thinking about writing this for a bit and then a co-worker actually had this problem recently, so, well, it seemed like a good idea.
Find Index Create Date
(Jason Brimhall) Have you ever been zipping right along working on tuning a query or maybe a handful of queries. Then BAM! All of a sudden you lose the script you were working on. The script just so happened to have a few indexes that you were getting ready to create and you would like to not have t
Logging in Entity Framework Core
(Joydip Kanjilal) Entity Framework Core (EF Core) is an open source, lightweight, cross-platform and extensible version of Microsoft’s popular ORM called Entity Framework. EF Core runs on top of the .NET Core runtime and can be used to model your entities much the same way you do with Entity Framewo
Watching SQL Server Stuff From Performance Monitor
(Michael J. Swart) Taking a small break from my blogging sabbatical to post one script that I’ve found myself writing from scratch too often.
DevOps for databases: ‘DataOps’
(James Serra) DevOps, a set of practices that combines software development (Dev) and information-technology operations (Ops), has become a very popular way to shorten the systems development life cycle and provide continuous delivery of applications (“software”).