X-XMLA: vi. Processing and Out-of-Line Bindings in XMLA
In this post, I will progressively go through processing a partition from full process, to incremental process, and finally to...
2012-09-19
801 reads
In this post, I will progressively go through processing a partition from full process, to incremental process, and finally to...
2012-09-19
801 reads
We are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference...
2012-09-18
517 reads
First, I need to set the record straight – I am not a systems guy. When I need work done to...
2012-08-30
1,354 reads
When Jason ( B | T ) posted this assignment, I thought it would be a fun topic to write on. Before I...
2012-08-15
507 reads
As I started looking over my event calendar, I was amazed at how many events Magenic is sponsoring, hosting or...
2012-08-14
559 reads
The Open Data Protocol (OData) is an open specification created Microsoft to enable exposing data in a standard way from...
2012-07-23
1,283 reads
As noted in that great text, The Hitchhiker’s Guide to the Galaxy, “Don’t panic!” Excel 2013 will make even more...
2012-07-17
817 reads
This will be the easiest entry in this series. This is a reblog of an article I wrote last year....
2012-06-26
1,176 reads
I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”. I...
2012-06-22
522 reads
The fourth segment in this series focuses on using XMLA to deploy databases. When you create SQL Server Analysis Services...
2012-06-19
906 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers