Speaking at Oracle Training Days
A first for me. I’m attending a non-SQL Server event, trying to bring a little knowledge of my platform to...
2012-12-03
1,066 reads
Power View and Reporting Services
There has been an active discussion thread on Chris Webb’s blog about the similarities & differences between various Microsoft BI & reporting...
2012-12-03
742 reads
Logins vs Users
Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....
2012-12-12 (first published: 2012-12-03)
3,716 reads
MDX #23 – “Hello World!” Lesson in MDX
Almost every tool we learned has some sort of “Hello World!” tutorial lesson.
So here comes the “Hello World!” lesson in...
2012-12-03
1,092 reads
T-SQL: CASE Statement
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-11 (first published: 2012-12-03)
5,187 reads
Last Weeks Top 10 “Reading” Links #9
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-03
1,025 reads
HDInsight, Finally
See this:
That’s right. The install worked. All I had to do was get a completely clean server set up. No...
2012-12-03
1,391 reads
SQLOS Basics - Query and CPU
In this article We are going to understand the basics of SQLOS - CPU scheduling.
In high level:
1. When an user connects to SQL...
2012-12-03
6,406 reads
SQL Server Training in 2013
Unbelievably it is December already and 2013 is fast approaching. With the Christmas break fast approaching now is the time...
2012-12-03
1,092 reads
OT: Space Exploration and the Future of Humanity
I am old enough to remember watching the Apollo 11 landing in 1969 as a young child. Before and after...
2012-12-03
1,491 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...
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