Who Likes NULL?
The use of NULL values in a database can be controversial. Today Steve talks about his views on this concept.
2018-07-06
135 reads
Editorials
2018-07-05
507 reads
2018-07-04
37 reads
2018-07-03
59 reads
Detecting SQL code smells using code analysis
Watch out, watch out, there's a NOLOCK hint about. And probably a few other SQL code smells.
2018-07-02
328 reads
DevOps is Really Helpful
Steve Jones talks about the practical benefits of using DevOps to smooth out your software development.
2018-07-02
136 reads
How are you recharging this year?
Steve Jones asks about your plans to get away from work and refresh yourself.
2018-06-29
51 reads
String or binary data would be truncated
This is an error that has plagued SQL Server for a long time. It should be fixed.
2018-06-28
314 reads
When Work Gets in the Way of Work
Work sometimes gets in the way of work. Steve Jones notes this can cause stress and problems over time.
2018-06-27 (first published: 2014-10-21)
210 reads
2018-06-26 (first published: 2015-04-14)
261 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