Re-Awarded as a Microsoft MVP
Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....
2013-01-02
1,202 reads
Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?
Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?
31 Days of Disaster Recovery
Welcome to my...
2013-01-04 (first published: 2013-01-01)
2,310 reads
VCAP5-DCA study guide is now available
Paul Grevink has released a great study guide for the VMware VCAP5-DCA exam. It’s available here! I’ll be using it...
2013-01-01
729 reads
Re-awarded MVP status for 2013
I received notification that I have received the Microsoft MVP award for 2013, my fourth consecutive year to receive this...
2013-01-01
515 reads
Re-awarded MVP status for 2013
I received notification that I have received the Microsoft MVP award for 2013, my fourth consecutive year to receive this...
2013-01-01
655 reads
Looking Forward to the New Year - Professional Goals
Most folks make New Year's resolutions of things they want to do over the course of the next 364/365 days....
2013-01-01
1,317 reads
My 2012 Year
What a wild year this has been. There have been ups and downs, but the ups have been incredible. To...
2013-01-01
938 reads
Full-Text Search – Stoplists in SQL Server
Full-text search is an interesting subsystem in SQL Server. It allows you to implement searches through a variety of text...
2013-01-07 (first published: 2012-12-31)
6,570 reads
Wrapping Up 2012
Last year, I did a wrap up post of the year to see where I landed from where I wanted...
2012-12-31
1,637 reads
2012 in review !
Year 2012 was super special for me in many ways. Made lot of new friends, Attended SQLPASS Summit 2012 and had...
2012-12-31
1,350 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