Video walkthrough of renaming or “flipping” databases to minimize down time during a refresh. Most commonly when moving a copy from prod to dev.
My Pluralsight courses for new SQL Server DBAs
Thanks for reading!
SQL Server Database Consulting
Video walkthrough of renaming or “flipping” databases to minimize down time during a refresh. Most commonly when moving a copy from prod to dev.
Thanks for reading!
This course covers many of the SQL Server Maintenance items I do every day, week, and month for my servers:
My first course is a good (but not required) starter, covering history, installation, some configuration and the SQL Server tools:
I’d love to get your opinions, questions and ratings for either or both of these. I’m already planning the next one!
Pluralsight courses require a paid subscription.
If you want some FREE training, check out my YouTube channel.
Thanks for watching!
T-SQL Tuesday is a monthly blog party for the SQL Server community. It is the brainchild of Adam Machanic (b|t) and this month’s edition is hosted by Kerry Tyler (b|t), who has asked us to write about “Learning From Others“, by telling about a time something went bad and how it got fixed.
I have an “In Real Life” series of blog posts that are exactly this:
Availability Group Performance
There are a couple of additional issues in the hopper, just haven’t had time to write them up.
Thanks for reading!
Company is using SQL Server Express to save on licensing costs for a small database. Over time this database grows and is getting close to the hard 10GB limit.
I just got off the phone with a client and their client is in this situation. During the conversation, she mentioned that the DB has information for four “regions.”
They already have a purge process in place, and compression is not an Express Edition feature.
If you have other legitimate things I should add to this list that Microsoft will support, please share in the comments.
If your data is important, buy the proper version for your needs. Maybe that’s Standard, maybe an Azure VM and spread out the SQL licensing over many months. But don’t do crazy things to try to get around the limits.
Thanks for reading!
SQL Server, Virtualization and Storage expert David Klee (b|t)stops by to tell stories 🙂
Fun stuff:
“English and Gibberish”
“Learn it like you’re going to teach it”
“Kevin Kline was there for comic relief”
“I cannot live without those (DBATools)”
“Rubber Chickens”
Microsoft Data Platform and PowerShell MVP, Chrissy Lemaire (b|t) sat down with us in the virtual studio Saturday, and we had a blast getting to know her!
Quotables:
“This is horrible, this not what I want to do” (Oracle reference)
“This is an at risk system”
“Hold on, let me fix my tongue”
Chrissy’s shout-outs:
DBA Tools In a Month of Lunches