Don’t Be That PASS Summit Guy
Don’t Be That PASS Summit Guy
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is just around the corner. Every year...
2012-10-22
1,204 reads
Blog Posts
Last Weeks Top 10 “Reading” Links #3
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-22
704 reads
Preparing for Certification
One of my goals back when I was a young MCSE (that's Microsoft Certified System Engineer for NT4, not the...
2012-10-22
1,348 reads
Red Gate log shipping
Log shipping is great.
It's basically the act of beginning a restore with no recovery, and then restoring logs (with no...
2012-10-22
2,148 reads
Stockholm in 2013
Come and join me live in Stockholm Sweden early in 2012 where I will be presenting Learning Tree’s2109 SQL Server...
2012-10-22
509 reads
Trace Flag 2371 and Statistics
One of the issues that I see published often on forums like SQLServerCentral is the advice to update statistics on...
2012-10-22
9,572 reads
What Happened to rowmodctr from Sysindexes?
In my blog series Lost in Translation – Deprecated System Tables, I’ve been going through the compatibility views in SQL Server...
2012-10-22
2,586 reads
Does a Clustered Index really physically store the rows in key order?
The Myth
One misconception that I see a lot deals with how data is stored in a clustered index. Specifically – is...
2012-10-21
8,128 reads
SQL Server Locking Overview
Locking is a necessary part of transaction processing when working in a multi-user Online Transaction Processing (OLTP) environment. You use...
2012-10-21
12,299 reads
Ask The Unicorn: SQL Saturday Registration Is Closed
Right before the last Minnesota SQL Saturday, I was asked a few questions about learning about SQL Server which led...
2012-10-20
768 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