2022-11-28
434 reads
2022-11-28
434 reads
Learn how one company adopted, adapted, and learned from the Agile methodology.
2022-11-28
4,419 reads
In my previous tip, I explained how we are inclined to use archive tables and how they become increasingly problematic over time. This tip will focus on ways to mitigate the issues.
2022-11-28
In this article, we cover things you should know about Azure SQL Database and why this may be a good choice for your database applications.
2022-11-25
2022-11-25
516 reads
In the previous two articles in this series, you learned about SELECT and INSERT, two important data manipulation language (DML) statements in MySQL. In this article, I focus on the UPDATE statement, another valuable DML statement in MySQL.
2022-11-23
Artificial Intelligence can help humans, both in diagnosis, but also in teaching medical professionals.
2022-11-23
138 reads
2022-11-23
552 reads
Learn about SQL Server triggers and how to use them for inserts, updates, and deletes on a table, along with step-by-step examples.
2022-11-21
2022-11-21
485 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers