SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help Friday, February 21, 2020
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 […]
(Rajendra Gupta) This article explores the Python scripts for encrypting and decrypting passwords in SQL Server using Azure Data Studio SQL Notebooks.
(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.
(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.
(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
(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
(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.
(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”).
(Pinal Dave) Today’s blog post is based on a very interesting observation sent to my client of the Comprehensive Database Performance Health Check. While I primarily focus on improving the performance of SQL Server, often I receive question-related to T-SQL and I enjoy answering them.
(Sergey Gigoyan) After installing SQL Server 2017 or SQL Server 2016, a user tries to connect to SQL Server Integration Services (SSIS) for the first-time using SQL Server Management Studio (SSMS), most likely the connection attempt will fail. The received error message indicates: Failed to retriev
