Thinking about Pre-Cons In Orlando in 2019
In the spirit of “do more” we’re hoping to host at least 4 pre-cons in Orlando in 2019. Right now...
2018-11-27
266 reads
Blog Posts
Why You Should Take the ‘State of Database DevOps Survey’ Today (even if you don’t do DevOps)
Update: The survey is now closed, thanks folks! When I began working with databases, nobody talked about DevOps. It was a few years before I heard the words ‘Agile’...
2018-11-27
12 reads
Create dynamic agenda slides with PowerPoint Zoom
There was a time when I saw PowerPoint as a necessary evil – a way of conveying ideas that I wasn’t crazy about, but which worked. These days, my...
2018-11-26
25 reads
Determine database version from a bak file
Have you ever imagine you can determine the version of SQL Server from a bak or a MDF file? I...
2018-11-26 (first published: 2018-11-15)
18,311 reads
FCB::Open failed: Could not open file number 2. OS error: 3(The system cannot find the path specified.).
AdvertisementsTroubleshooting steps to do when we cannot start SQL service and receive this alert.
Run –> eventvwr –> windows log –> system and filter...
2018-11-26
1,164 reads
Ghosts in your Database
Yes Virginia, there are ghosts in your database. More specifically, there are ghosts in your SQL Server database. They are not there to haunt you. They are not there...
2018-11-26
12 reads
Monitor Database Offline Events
The other day, I shared an article showing how to audit database offline events via the default trace. Today, I...
2018-11-26 (first published: 2018-11-15)
1,933 reads
Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool
In this article we learn migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool. In this article, I have explained this as a step...
2018-11-25
31 reads
Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool
In this article we learn migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool. In...
2018-11-25
369 reads
PASS Summit 2018 brain dump
Much like your paycheck, this post is two weeks after the fact. But also like your paycheck, it’s got a good deal of personal importance. I’ve taken a couple...
2018-11-25
14 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers