Building a SharePoint 2013 BI Demo Environment Part 7 – Configuring SharePoint
In this blog post we go over one of the most important parts of the series: running the PowerPivot Configuration...
2013-06-07
1,210 reads
In this blog post we go over one of the most important parts of the series: running the PowerPivot Configuration...
2013-06-07
1,210 reads
Hitting close to home, SC Governor Nikki Haley noted that after the SC Department of Revenue breach was reported, that the IRS didn't...
2013-06-07
5,094 reads
I’m happy to announce that I’ll be delivering three, one-day preconference seminars this summer prior to three different SQL Saturday...
2013-06-07
925 reads
This past Monday, I presented at TechEd North America for the first time. The session presented was Indexing Fundamentals for...
2013-06-06
656 reads
I will be speaking at the Boulder SQL Server User’s Group on June 18, 2013 and at the Denver SQL...
2013-06-06
956 reads
I asked a recruiter to check out my blogs about consulting, and his response is below. He had some good...
2013-06-06
893 reads
Before we can configure SharePoint, we will have to install the Analysis Service instance that will host the PowerPivot workbooks...
2013-06-06
3,402 reads
Sitting in the first Keynote for the 2013 Techno Security and Forensics Investigation Conference, I was not surprised to hear Kevin...
2013-06-06
1,503 reads
There are different ways to take Cube database backups.
SQL Agent JobXMLA script for backupROBOT jobASCMD commandSSIS PackageSSIS packageAMO (Analysis Management...
2013-06-11 (first published: 2013-06-05)
2,988 reads
For the past couple of months I have been working with Ben Weiss a Digital Marketing Strategist at Infusive Solutions (http://www.infusivesolutions.com/)....
2013-06-05
521 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers