Haven't seen SQL Monitor in a while? If you'd like to see how it enables you to always have the answers to the health of your estate, and proactively find potential problems before they impact your users, here's a 30 minute demo for you to watch whenever it suits you.
There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and user privileges.
In this article we look at how to create a SQL Server database snapshot and how snapshots can be used for reporting, auditing and more.
I've just finished working in my fourth shared work space. I am not a fan. The endless hallways with all these little glassed in rooms where I can see everyone, and everyone can see me, are not my favorite places. I can see white boards with content that maybe I shouldn't be seeing. There are […]
Long term data storage isn't something we always need for databases, but it is something the world needs. A new technology has promise for those use cases, both in durability and preserving the algorithms needed.
This article shows how you can randomize dates in T-SQL, but keep the month and year the same while the day varies.
Join Grant Fritchey to discover how automating your database deployments enables you to speed up software delivery with repeatable processes that stop your database being the bottleneck.
In this article we look at how to use exception handling when writing Python scripts along with many different examples using try, except, else and finally clause.
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
GO
See possible answers