Upcoming Speaking Engagements
I presented a few times in 2019, and I’m starting off 2020 with several as well. Here’s what’s on the schedule for Q1.
2020-01-06 Yep, ISO8601 format. That’s how I...
2020-01-03
7 reads
FLX SQL
2019 Year in Review
As we open 2020 (and the house is still quiet on this New Year’s Morning), I thought I’d take a moment to reflect on the past year.
Blogging 2019 was...
2020-01-01
4 reads
T-SQL Tuesday #121: Gifts Received This Year
Closing out 2019’s T-SQL Tuesday, Mala (blog | twitter) is asking us to reflect on the past twelve months:
This is a time for material gift giving, for many of...
2019-12-11
5 reads
PASS Summit 2019 in Photos
I took a bunch of photos at and around Summit this year, including more selfies than in years past - I’m getting better about it! For a few more...
2019-12-02
10 reads
PASS Summit 2019 Photowalk
This was my first year joining the Summit Photowalk organized by Jamie Wick (blog | twitter). I had a lot of fun - Seattle is full of great photo...
2019-11-29
4 reads
PASS Summit 2019 Wrap-Up
I’m home from PASS Summit 2019, recovered from the travel, and in the post-Summit “I miss #SQLFamily” funk. Time to recap the week, maybe a bit differently than it’s...
2019-11-27
2 reads
Monday Morning Module Maintenance Monoliners
Or: Andy Authors An Amazing Alliteration
Do enough work with PowerShell and you’ll build up a decent collection of modules installed from the gallery into either your computer or your...
2019-11-25
7 reads
SQL Saturday Rochester Returns!
We have just published SQL Saturday Rochester 2020. We took last year off but we’re back for 2020 on a very special day - it’s Leap Day, February 29th!
What...
2019-11-22
4 reads
Preparing for PASS Summit - Odds and Ends
This is the final installment in my series of posts which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle,...
2019-10-29
3 reads
Preparing for PASS Summit - Sessions!
This is the third in my series of posts which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle, Washington.
So...
2019-10-21
5 reads
Blogs
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...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
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