Murder They Wrote
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2013-11-05
792 reads
Fast-Track Data Warehouse for Windows Azure
Microsoft has introduced an image into the Windows Azure Virtual Machine Gallery that is pre-optimized for a Fast Track Data...
2013-11-05
1,473 reads
More Azure Goodies
Microsoft keeps sneaking little things under the door for Windows Azure SQL Database. This time it’s a couple of new...
2013-11-12 (first published: 2013-11-05)
1,793 reads
T-SQL Tuesday #48– Cloud Atlas
Welcome to this month’s (November 2013) edition of T-SQL Tuesday. For those not familiar this is rotating blog party that was started by Adam Machanic (@AdamMachanic | blog) back...
2013-11-05
19 reads
T-SQL Tuesday #48– Cloud Atlas
Welcome to this month’s (November 2013) edition of T-SQL Tuesday. For those not familiar this is rotating blog party that was started by Adam Machanic (@AdamMachanic | blog) back...
2013-11-05
18 reads
T-SQL Tuesday #48– Cloud Atlas
Welcome to this month’s (November 2013) edition of T-SQL Tuesday. For those not familiar this is rotating blog party that...
2013-11-05
689 reads
Potential Backup Software Issues with Read-Only Databases in FULL Recovery
If you decide to park a database in read-only mode for a long period of time, go ahead and alter...
2013-11-13 (first published: 2013-11-05)
2,040 reads
A tour of the transaction log : Part 2 DELETE operations
In the last Tour of the Transaction Log we looked at how INSERT operations behave in the transaction log.
In this...
2013-11-04
565 reads
Dealing with Power Pivot to Tabular Upgrade Errors
Upgrading from Power Pivot workbooks to SSAS Tabular models is usually a pretty seamless process. This is part of the...
2013-11-11 (first published: 2013-11-04)
1,855 reads
Speaker of the Month, November 2013
Yeah, I’m a couple of days late. Tough. My blog. My rules.
Speaking of rules. Speaker of the Month is chosen...
2013-11-04
665 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
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