Checking Up on Vendors
Being able to audit the actions others take on your systems is important to Steve, especially when working in the cloud.
2021-05-10
162 reads
Editorials
Non-Stop Learning
There was a recent discussion in the forums here at SQL Server Central regarding the difficulties presented by the constantly shifting technology landscape. The core question was, how on earth do you master stuff? Especially, how do you master things when they're both new and constantly changing? Honestly, you don't. I mean, you can, but […]
2021-05-08
241 reads
Getting Started Remotely
Today Steve wonders what advice you might give someone starting out their career in technology.
2021-05-07
95 reads
Cloud Database Growth
The use of cloud databases is growing, and Azure SQL Database is one of the more popular ones.
2021-05-05
273 reads
Holding Code in Your Head
Steve has a few thoughts on software development and coding today when working in teams and trying to keep the entire solution in your head.
2021-05-03
517 reads
No-code Software Engineering
The idea that software engineers might be better with no-code tools is a direction Steve thinks is misaligned with the problem. We should help developers learn to be better.
2021-05-01
173 reads
Documentation. The Under Recognised Skill
Documentation may not be something we aspire to do, but it is a valuable skill.
2021-04-30
410 reads
Ransomware May Get Worse
Criminal groups using ransomware are working together, which is bad news for all organizations.
2021-04-29
230 reads
2021-04-28
102 reads
A Cloud Database for Statistics
A company decides to move to the cloud and outsource database administration.
2021-04-27
106 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
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