Using a Display Folder for a SSAS calculation
I was having a problem getting the display folder to work for a calculation in SSAS. Turns out, it will...
2011-09-09
1,375 reads
James Serra's Blog
Thinking about taking a contract position? Questions to ask
Over the years, I have accumulated a set of questions that I usually ask the placement firm about a contract position...
2011-09-07
1,161 reads
System Center and Visual Studio Team Foundation Server 2010
Because the relationship between application development and the IT operations teams is critical, Microsoft has released a CTP of a new...
2011-09-06
1,082 reads
Preventing projects from deploying when debugging a SSIS package
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am...
2011-09-02
1,416 reads
Receive error #13119 in toolbox instead of tools in Visual Studio 2008
A couple of times over the past few months, while in Visual Studio 2008 working on an SSIS package, I went...
2011-08-31
2,156 reads
When to use T-SQL or SSIS for ETL
When doing ETL, you have the choice of using T-SQL or SSIS. What things should you consider when deciding which...
2011-08-29
10,241 reads
Microsoft SQL Server Parallel Data Warehouse (PDW) Explained
Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server...
2011-08-26
3,827 reads
Microsoft Small Basic
This is a bit off-topic, but I wanted to mention a great tool for beginners to learn how to program. ...
2011-08-24
2,059 reads
Tracking down KPI error in PerformancePoint
On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me:
So...
2011-08-22
755 reads
Methods for populating a data warehouse
Source tables change over time. A data mart or data warehouse that is based on those tables needs to reflect these...
2011-08-19
4,945 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