Find SQL Database Owner with T-SQL
One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week...
2014-05-08 (first published: 2014-04-29)
4,628 reads
Bradley Schacht
Webinar Q&A: Getting Started With Analysis Services
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about Getting Started With Analysis Services....
2014-03-21
1,451 reads
SharePoint 2013 – Failed to install the product: D:\global\oserver.msi ErrorCode: 1603(0x643)
I often do my SharePoint setups on virtual machines since I need to build them up and tear them down...
2014-03-04
2,858 reads
Webinar Q&A: New BI Features in SharePoint 2013
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in...
2014-02-28
1,787 reads
A New Year is Right Around the Corner
If you read my 2013 Year In Review you may be here today wondering why I haven’t posted anything despite...
2013-12-30
1,576 reads
Presentation Update: New BI Features in SharePoint 2013
It’s time for another free webinar!!
Whether you like it or not SharePoint is here to stay! With every release of...
2013-12-06
1,239 reads
Presentation Update: Change Data Capture (CDC) Made Easy With SSIS 2012
Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data...
2013-12-05
1,254 reads
Year In Review: 2013
Ok, so it’s not quite the end of the year yet. I figured I would get a head start on...
2013-12-04
1,244 reads
Webinar Q&A: Practical SSAS: Getting Started with Analysis Services
A couple of weeks ago I did two webinars for the Pragmatic Works Free Training on The T’s. The first...
2013-12-03
1,286 reads
Webinar Q&A: SSIS Design Patterns for Loading a Data Warehouse
I’m not going to sugar coat it. I’ve been a bit of a slacker lately. Unfortunately I didn’t get the...
2013-12-03
1,590 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