How to Become a SQL Server Database Administrator
I wrote How to Become a SQL Server Database Administrator (email address required for download) a few years ago as a project...
2017-04-03
529 reads
SQLAndy
April Fools 2017
Each year I try to something fun for April 1st, though it’s hard to do well. Trying to be funny...
2017-04-01
503 reads
Why I’m Changing to MySQLAndy
From time to time we all have to examine our path and decide if we need to make adjustments. Looking...
2017-04-01
414 reads
Notes from the March 2017 MagicPASS Meeting
I was a last minute volunteer to speak at the March meeting and used it as a chance to talk...
2017-03-31
620 reads
Applying SQL Service Pack on Encrypted Drives
I have a server that uses a third party disk encryption product. It’s configured so that the SQL service account...
2017-03-30
688 reads
SSMS – Not a Valid Value for Property Width
I’ve had this happen a couple of times with a recent build of SSMS. Something went wrong – resolution change maybe...
2017-03-29
1,249 reads
Orlando Code Camp 2017
I’ll be attending and speaking at Orlando Code Camp on April 8th. Come by and say hello if you’re attending,...
2017-03-27
411 reads
Reading the January 2017 PASS Minutes
I’ve been catching up on stuff this week, including reading the January 2017 minutes. It was in-person meeting so a...
2017-03-27
369 reads
Reviewing the PASS 2017 Budget
I did a quick review of the 2017 PASS Budget. It’s not a page turner, but it has a lot...
2017-03-27
368 reads
A Note on Configuring HP SSD’s
Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage...
2017-03-24
427 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers