SQL Database Overview
Learn about what a SQL database is, what is stored in a database and how to interact with a database.
2022-06-17
Additional Articles
SQL Monitor supports Amazon RDS Monitoring
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
Introduction to artificial intelligence
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
Summit 2022 Community Pre-cons have been announced
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
[Re-post] The 10 Benefits of Monitoring for Leaders
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
Recover Recently Closed Tab in SSMS
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,111 reads
The benefits of database change management
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
Optimizing my.cnf for MySQL performance
Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.
2022-06-08
Why Database Monitoring Tools are Important for Senior Leaders
Matt Gordon is a Microsoft Data Platform MVP and the Director of Data and Infrastructure at Rev.io. In this short video, he talks us through the 3 key reasons database monitoring tools are essential for him as a Director, and how they help him to lead a team successfully and productively.
2022-06-08
Database Testing in a Flyway Development
If you can test and evaluate databases, and database objects, at every phase of the database development lifecycle, then you are much more likely to be able to adopt continuous delivery. The further down the delivery pipeline that bugs appear, the more costly in time and resources they are to fix.
2022-06-06
Blogs
Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition
In my previous post, I showed you how to build a snapshot backup catalog...
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers