It’s 2020, Do I really need to DBCC CHECKDB?
I’ll start by saying that I swear I posted this at some point in the past but I don’t see it looking back at old posts. This is from...
2020-04-27 (first published: 2020-04-15)
1,544 reads
Blog Posts
ML Models
In this series I would be talking mostly about Python and R, we would understand the different ML model supported in Python. Python is a great open source language...
2020-04-27
22 reads
Register for Data Platform Discovery on Apr 29
The agenda is out for the US Data Platform Discovery Day. It’s online, and takes place this Wednesday, April 29, 2020. You can register and check out all the...
2020-04-27
15 reads
SSDT: Scripting static data from SQL Server (video)
Out of the box, SSDT covers objects on a database level, like tables, stored procedures, views, functions, etc. That means schema only. In many cases, there is a need...
2020-04-27
106 reads
T-SQL Tuesday Live–28 Apr 2020
Once again, I’ll be live tomorrow, ready to just chat, shoot the breeze, answer tech questions, anything. No agenda, but I’m on for an hour. If you’re bored, struggling,...
2020-04-27
15 reads
What is the datatype SQL_VARIANT
The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. ... Continue reading
2020-04-27 (first published: 2020-04-16)
611 reads
Stairway to Microsoft Azure SQL Database Part 1 : Deployment Options
Recently I started working with Azure SQL Database. It took some time for me to understand the concepts of the Azure SQL database. Earlier I have experience in AWS...
2020-04-26
14 reads
Stairway to Microsoft Azure SQL Database Part 1 : Deployment Options
Recently I started working with Azure SQL Database. It took some time for me to understand the concepts of the Azure SQL database. Earlier I have experience in AWS...
2020-04-26
311 reads
I’m Speaking at #DataWeekender
With all our in-person events cancelled for the foreseeable future, I was so excited to find that some community folks are not sitting back and waiting for the social...
2020-04-25
25 reads
3D Printing for Covid19
A friend tagged me in a Facebook post about a surgical mask strap that had been remixed by a Boy Scout for faster printing and less filament usage. My...
2020-04-24 (first published: 2020-04-13)
454 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers