Prius Update – Smells Like New
We got the Prius back yesterday. I dropped Kyle off and he drove it home. Today was my first time...
2009-04-20
526 reads
A Proper Response
That sounds like a very British title, so maybe the Red Gate folks are rubbing off on me. I had...
2009-04-20
589 reads
Four new SSIS Videos on JumpstartTV.com
I've got four new SSIS videos published on JumpstartTV.com:
Expression Language Basics
Secure FTP File Transfer in SSIS
SSIS Lookup Transformation Basics
SSIS...
2009-04-20
2,215 reads
Simply Dumb Founded - A Non SQL Blog
Blogging is both more fun and harder than it looks, so when someone is getting started I try to offer...
2009-04-20
552 reads
The Death of Email Questions
One of my policies is not to answer questions from people about SQL Server in email. That includes emails to...
2009-04-20
1,065 reads
Security Basics - The C-I-A Triad
In the course of giving my security presentations over the past year, I've learned that quite a few folks have...
2009-04-20
9,121 reads
So, what book do you recommend?
Another excellent blogger here on SSC, Jeffery Yao, has posted up an interesting idea http://www.sqlservercentral.com/blogs/jeffrey_yao/archive/2009/04/20/database-administration-literature-criticism.aspx .
As a PASS chapter leader...
2009-04-19
467 reads
Networking Results
I've written quite a few posts lately on networking and a very common question is - where's the results? What do...
2009-04-19
987 reads
Database Administration Literature Criticism
What is literature? I find this definition is pretty intuitive at http://classiclit.about.com/od/literaryterms/g/aa_whatisliter.htm and also this one is more comprehensive at...
2009-04-19
1,021 reads
LinkedIn as your Stepping Stone for Opportunities with Internationally-Oriented Organisations
As some of you may have read already, Andy Warren‘s series on LinkedIn (part 1, 2,3) and networking has sparked my...
2009-04-19
1,193 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