If you can generate a quick Entity-Relationship diagram for any version of a database, you'll have a simple way to 'sanity check' it for unreferenced tables, missing keys and other design flaws. This article shows how to auto-generate these diagrams when running a migration, using Flyway Teams and PowerShell.
2022-06-20 (first published: 2022-06-06)
The SSRS database contains a wealth of undocumented information that can help administrators. In this article, Edward Pollack explains how to get to the data and ways to use it.
2022-06-20
Learn about what a SQL database is, what is stored in a database and how to interact with a database.
2022-06-17
SQL Monitor works with your SQL Server data, wherever that data exists, from local instances to AWS RDS and AWS virtual machines. You can keep an eye on your estate, regardless of where the data is.
2022-06-17
Artificial intelligence applications are all around us, but what does it really mean? In this article, Kumar Abhishek explains the history and progress of artificial intelligence.
2022-06-15
We’re delighted to announce the Summit community pre-conference sessions and speaker lineup! Choose from 14 pre-cons featuring Brent Ozar, Kimberly Tripp, Melissa Coates, Itzik Ben-Gan, Denny Cherry, and others, taking place on Monday Nov. 14 and Tuesday Nov. 15. Full-day pre-con sessions will cover topics including database performance tuning and troubleshooting, T-SQL querying, DAX, security, cloud VMs, Azure Data Factory, Azure infrastructure, parameter sniffing, Power BI, PostgreSQL, equity toolkits, and much more!
2022-06-15
A third-party database monitoring tool is an investment that drives enormous value for the bottom line of a business in ten key ways, from simplifying cloud migration to retaining talent. Here's how.
2022-06-13
Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.
2022-06-13
2,137 reads
Using a change management system for database code is a new idea for many database administrators. Grant Fritchey explains the many benefits of database change control.
2022-06-10
Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.
2022-06-08
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Hi, below i show various results trying to reach our ftp site (a globalscape...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers