Hide the Ribbon in Power View
There may come a day when you want to embed a Power View report into a PerformancePoint dashboard or a...
2013-06-07
727 reads
Bradley Schacht
SharePoint 2010 on SQL 2012 Configuration Failed
Recently while doing an installation of SharePoint 2010 on a Windows Server 2008 R2 server with a SQL Server 2012...
2013-05-29
1,205 reads
Creating a SharePoint 2013 Demo Environment – Part 1: Setting Up A Domain Controller
Development and demo environments can be hard to come by. Over the course of this series you will learn how...
2013-05-21
2,297 reads
Browse SharePoint in Windows Explorer
Have you ever wanted to browse your SharePoint 2010 site in Windows Explorer? If you are in SharePoint 2007 please...
2013-05-14
893 reads
SQL Saturday Jacksonville 2013 Wrap-up
It was another great year at SQL Saturday Jacksonville. For the last several years I have been lucky enough to...
2013-05-07
486 reads
Why I’m Considering a Surface and Windows Phone 8
Anyone who knows me will see the title of this post and tell you I’m about to trash the Surface,...
2013-03-22
682 reads
SSIS 2012 Deadlock When Running SSIS from SQL Agent Job
I recently had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with...
2013-03-18 (first published: 2013-03-12)
5,104 reads
Remove Local Administrators SSAS Admin Access
Recently while changing some production security around on a new server I needed to modify the SQL Server Analysis Services...
2013-03-05
1,258 reads
Find Skew in Distributed Tables
The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the...
2012-09-11
1,537 reads
Cisco VPN Client 5 on Windows 8
NOTE: Always create a backup before doing any type of Windows registry modifications!!!!
With the full public release of Windows 8...
2012-09-04
1,477 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers