Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong
Doing things by the book isn’t necessarily the only way to learn a new skill. Sometimes, experiencing everything that can...
2012-02-28
4,054 reads
Multidimensional Mayhem
Sitting Between Two Stools: Analysis Services 2012, Windows 8 and Market Niche Confusion at Microsoft
In my last post, I wrote that the game plan was to post by Dec. 10 on changes in data...
2012-01-24
1,958 reads
Installing SQL Server 2012 Release Candidate 0
In my last post, I indicated that my plan was to post by Dec. 3 on the topic of data...
2011-12-03
2,192 reads
An Informal Compendium of SSAS Errors, Part 6: Common Errors
This is the last in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-11-20
1,290 reads
An Informal Compendium of SSAS Errors, Part 5: Incorrect Calculation Results, Miscellaneous and MDX Studio Errors
This is the fourth in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-11-13
1,901 reads
An Informal Compendium of SSAS Errors, Part 4: SSAS Object Design
This is the third in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-10-08
2,191 reads
An Informal Compendium of SSAS Errors, Part 3: Unresolved Errors
This is the second in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-10-02
1,800 reads
An Informal Compendium of SSAS Errors, Part 2: Data Mining
This is the first in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-09-21
2,248 reads
An Informal Compendium of SSAS Errors, Part 1: Introduction
When practicing for my MCTS in SQL Server Analysis Services (SSAS) 2008 R2 last spring, I was shocked to receive...
2011-09-21
1,470 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