Speaking at SQL Saturday #49 Orlando
To all who live within a drive (or even a flight) to Orlando I really recommend you attend SQL Saturday Orlando next Saturday October...
2010-10-07
703 reads
Devin Knight
Knight's Microsoft Business Intelligence 24-Hour Trainer released
Today the much awaited Knight's Microsoft Business Intelligence 24-Hour Trainer book was release. In this book you will learn about...
2010-09-28
958 reads
SSAS - Defining Attribute Relationships in 2005 and 2008
Attribute relationships inside of Analysis Services are a critical piece to the design of your dimensions.The benefits of creating attribute...
2010-09-20
1,590 reads
MDX Aggregate Named Set Than Others
In this quick post I wanted to provide some code that's been useful to me recently. This MDX statement creates...
2010-09-17
2,471 reads
MDX - Calculating the Percent of a Named Set
Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic...
2010-09-08
1,132 reads
Creating a PerformancePoint 2010 Data Source
In a previous post I wrote about getting started with PerformancePoint 2010.In that post you learned about what PerformancePoint is...
2010-09-01
898 reads
SQL Lunch #26 Analysis Services Security
Today at 12:30 EST I will be presenting for SQL Lunch on the topic of Analysis Services Security. Make sure to be...
2010-08-05
692 reads
Getting Started With PerformancePoint 2010
PerformancePoint is a great tool for monitoring and analyzing the performance of your business at a high level but also...
2010-08-03
1,251 reads
SSIS - Event Handler Performance
Event handlers are a great tool for managing errors and other events that occur during the execution of a package...
2010-07-20
1,140 reads
SSIS - Event Handler Performance
Event handlers are a great tool for managing errors and other events that occur during the execution of a package...
2010-07-19
3,954 reads
Blogs
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...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
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
Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
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