A moment of void in the cranium reveals a recursive computed column with an esoteric message
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,388 reads
I am Speaking at 2013 PASS Member Summit!
Speaking at PASS Summit 2013
Every single year I look forward to the PASS Member Summit. In a nutshell it is...
2013-05-30
1,286 reads
Saving Grace
According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a...
2013-05-30
1,262 reads
Backup a password, change it, then restore it.
A couple of months ago I talked about moving a login from one server to another without the password. The...
2013-06-05 (first published: 2013-05-30)
2,358 reads
SQL Saturday Charleston!
Finally.... SQL Saturday has come back to... South Carolina! (with apologies to The Rock)
After the last SQL Saturday in Columbia,...
2013-05-30
1,917 reads
SQL Server security webinar series is coming soon!
I've gotten in contact with most of the speakers who submitted SQL Server security talks for the PASS Summit. All...
2013-06-04 (first published: 2013-05-30)
2,547 reads
Building a SharePoint 2013 BI Demo Environment Part 1 – Introduction
Recently I had to give a Power View demo for a client. Giving a demonstration means of course you have...
2013-05-30
2,959 reads
SSIS 2012 Deployment Fail Part Two: SSIS Server Maintenance Job
Recently I post about a timeout issue I was getting when deploying SSIS projects. It was mainly to do with too much log and previous versions being kept in...
2013-05-30
26 reads
Hangouts Session with Boris Hristov
I was invited to take part in a new initiative conceived by Boris Hristov (Blog|Twitter).
Boris wants to start using the...
2013-05-29
1,281 reads
Security Questions: Accessing SQL Server Securables
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-04 (first published: 2013-05-29)
2,457 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