SQL Server Quick Tips
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
13 reads
The 2019 State of DevOps Report–Webinar
Tomorrow I get to chat with another giant in the world of DevOps: Jez Humble. I actually met Jez years ago at a conference, and I was honored to...
2019-09-17
18 reads
An Effective Solution to Resolve SQL Database Corruption
I am a SQL Administrator and today I will share my experience about an issue on SQL server, which corrupted the transaction logs and left the database in a...
2019-09-25 (first published: 2019-09-17)
3,022 reads
Weekly reading #26
Good morning! It was a tough weekend as we supposed to be in Goteborg on #SQLSatGothenburg but unfortunatelly the flu hit us hard. The talk was handed over by...
2019-09-17
9 reads
Weekly reading #26
Good morning! It was a tough weekend as we supposed to be in Goteborg on #SQLSatGothenburg but unfortunatelly the flu hit us hard. The talk was handed over by...
2019-09-17
28 reads
The "Go Pack"
I’ve found myself traveling quite a bit this year, with more travel on the horizon. Like many, I travel with a fair bit of technology and of course that...
2019-09-17
6 reads
Delete an Azure DevOps Project
Not something you’ll do too often, but you might find yourself doing this if you are setting up PoCs and removing them. A reminder for me, since I stumbled...
2019-09-16
80 reads
Ways to access data in ADLS Gen2
With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used for many of them, a common question I am asked about is “How can I...
2019-09-16
574 reads
DBA Myths: CHECKDB runs on startup.
If you look at your error log you’ll (hopefully) see entries like this shortly after the instance startup: CHECKDB for ... Continue reading
2019-09-30 (first published: 2019-09-16)
585 reads
Using Project Connections in SSIS
In SQL Server Integration Services, connection managers are used as gateways for most any external read and write operation. Connection managers are type- and format-specific, and in the case...
2019-09-24 (first published: 2019-09-16)
378 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers