SQL SERVER – Find Owner of Database – Change Owner of Database
Recently I had the opportunity to help a client with Comprehensive Database Performance Health Check, and while working together we ended up in a very interesting situation where they had one database without an owner. As there was no owner, it was not …
Who’s Hiring in the Database Community? May 2022 Edition
Is your company hiring for a database position as of May 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must i …
Creating Flyway Migration Files using Redgate Schema Comparison Tools
The post Creating Flyway Migration Files using Redgate Schema Comparison Tools appeared first on SQLServerCentral.
Creating Tables in Power BI
Creating tables in Power BI can be useful in some situations. In this article, we will see the two main ways to create our own internal tables in Power BI. Prerequisites All we need for this example is the Power BI Desktop edition. Getting Started Firs …
Clustering data for insights
The post Clustering data for insights appeared first on SQLServerCentral.
Azure Data Studio and Version Control
One of the more important things that I think we should be doing as software developers is maintaining our changes in some sort of version control system (VCS). This is important to protect code, allow us to undo problem changes by finding old code, an …
Finding deeper insights with Topic Modeling
The post Finding deeper insights with Topic Modeling appeared first on SQLServerCentral.
Webinar | Gain the competitive edge with a monitoring tool
The post Webinar | Gain the competitive edge with a monitoring tool appeared first on SQLServerCentral.
7 DB Forge SQL Studio Features Discovered in Less Than 2 Hours
Introduction An acquaintance of mine introduced me to dbForge SQL Studio some time ago and I was absolutely blown away by the capabilities of the product. DbForge is an integrated development environment for SQL Server that extends the capabilities of …
Continuous Data Protection with SQL Data Catalog 2.0 and Data Masking
The post Continuous Data Protection with SQL Data Catalog 2.0 and Data Masking appeared first on SQLServerCentral.
Why your PL/SQL needs to be testable – and how to do it: Part 1
The post Why your PL/SQL needs to be testable – and how to do it: Part 1 appeared first on SQLServerCentral.
Office Hours, Text Edition: No-Brainer Questions
Not all questions require a video answer. Here are some simple no-brainer ones: Q: BehindTheScenesDBA: With all its limitations, what do you think about memory-optimized tables? Have you recommended to a client to use it? A: They don’t make …
[Video] Office Hours: New Las Vegas Home Office Edition
It’s the first webcast I’ve done from my new Vegas pad. You posted questions at https://pollgab.com/room/brento/ and I discussed the highest-upvoted ones: 00:00 Introductions 02:15 Jim D: Should I use full backups or log shipping for migrat …
Understanding the Mapping Data Flow Activity in Azure Data Factory
Azure Data Factory is used for ELT (Extract, Load, Transform) operations in Azure. We do have multiple activities to move data from source and destination. However, we cannot do many data transformations using the general activities of Azure Data Facto …
The 10 Benefits of Monitoring for Leaders
The post The 10 Benefits of Monitoring for Leaders appeared first on SQLServerCentral.