Notes From SQLSaturday South Florida
Notes from the trip:
Four hour drive between traffic and rain, about an hour longer than I would have liked. The...
2014-06-16
447 reads
SQLAndy
I Gotta See the Code–Question of the Day
I Gotta See the Code is a security question about viewing the code to a stored procedure. Two points if...
2014-06-16
564 reads
Reflections On Fathers Day
Fathers Day coincided with the family vacation this year and maybe more than some years I had the time to...
2014-06-16
526 reads
SQL Saturday South Florida And Then Vacation
I’m leaving early afternoon for the longish drive to South Florida for SQLSaturday tomorrow. The schedule looks impressive! I missed...
2014-06-13
548 reads
SSIS Lessons Learned, Or Not, And Mistakes Beginners Make
It’s been a while since I’ve used SSIS for anything of substantial complexity, and a lot longer than that since...
2014-06-12
793 reads
Giving Away Woodworking Magazines
I read a lot and one of the topics I enjoy reading about is woodworking. Recently I’ve been on a...
2014-06-12
629 reads
SQLSaturday in Vermont, Idaho, South Dakota, Montana, Alaska, Arkansas, Mississippi, and Wyoming
Did the list of states in the title catch your eye? That’s the list of states where PASS is trying...
2014-06-11
520 reads
Status and Name Please-Question Of The Day
Status and Name Please is my latest Question of the Day at SQLServerCentral. This is a fairly easy question, but...
2014-06-11
399 reads
Editorial: Space Hoarders
I wrote Space Hoarders for SQLServerCentral, a discussion of why we – the DBA’s of course – are always blamed for the...
2014-06-10
469 reads
Prepping For The NomCom
Sunday I spent an hour going over various notes and thinking about what I’ve seen in the past couple PASS...
2014-06-09
353 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