Many of us grew up with one version of Cinderella or another. The step child that's horribly mistreated by the new parent is a scary story. In the Disney version, everything works out fine. However, if you read some of the original Grimm versions of the story (and there is more than one version), not […]
2021-01-30
62 reads
Cutting edge technology might vary for many people, and Steve wonders what you think.
2021-01-29
101 reads
When downtime strikes, we may have to make decisions about which systems to focus our efforts upon. Steve talks about the impact of a disaster on your choices.
2021-01-28
93 reads
We had unfortunately lost quite a few members of our SQL Family. We have a new way to remember them.
2021-01-27
157 reads
Is it always important to have the most current data? Steve notes that you might need to make a decision here.
2021-01-26
111 reads
Many people don't feel like they can make changes in their work environment. Today Steve notes this is common in many organizations.
2021-01-25
99 reads
Changes in data privacy law in California are demanded by consumers.
2021-01-23
63 reads
Learning to be a better database developer can be hard. Today Steve asks how you might suggest someone learn.
2021-01-22
260 reads
We need data that represents the problem we want to solve, or we might not achieve our aims.
2021-01-21
92 reads
Today Steve Jones gives you ideas on how to keep learning and growing your career.
2021-01-20 (first published: 2018-01-19)
286 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
GO
See possible answers