Data Compare on Temporal Tables
I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...
2016-11-02 (first published: 2016-10-28)
3,109 reads
Sheldon Hull
- Website: https://www.sheldonhull.com
Get Backup History for All Databases in Server
Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...
2016-10-31
940 reads
Get Backup History for All Databases in Server
Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...
2016-10-31
482 reads
Data Compare on Temporal Tables
I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...
2016-10-28
548 reads
Centralized Management Server 101
Registered Servers
I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. 🙂 This is definitely not...
2016-10-24 (first published: 2016-10-16)
5,105 reads
Fixing Untrusted Foreign Key or Check Constraint
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax....
2016-10-22
1,210 reads
Fixing Untrusted Foreign Key or Check Constraint
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.If...
2016-10-22
237 reads
Easy SQL Maintenance with Minionware
Here's my personal tweaked settings for deploying Minionware's fantastic Reindex & Backup jobs. In the development environment, I wanted to have...
2016-10-18
575 reads
Easy SQL Maintenance with Minionware
Here's my personal tweaked settings for deploying Minionware's fantastic Reindex & Backup jobs. In the development environment, I wanted to have...
2016-10-18
227 reads
Cannot Generate SSPI Context
Troubleshooting
I ran into an error: The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)
I...
2016-10-17
1,300 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
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
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
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