Interesting Reading for September 18, 2012
More stuff you may find interesting.
Prepare for your first security breach. Sobering. As data professionals we’re going to get pulled...
2012-09-20 (first published: 2012-09-18)
2,142 reads
Clients Love The Way I Jiggle
It’s one of the most enjoyable things about being a consultant.
I’m not talking about my suspect dance moves here. I’m...
2012-09-18
1,165 reads
Office 2010 and Windows XP (64 bit)
I wanted to install Microsoft Office 2010 on an old Windows XP (64 bit) laptop. I tried running the setup...
2012-09-18
1,633 reads
How to Connect PerfMon to a Remote Server ?
Till now, we do not have any third party tool to monitor the SQL server, but we have implemented many custom...
2012-09-17
4,990 reads
Master Data Services: Versioning
In Master Data Services (MDS), you can create multiple versions of the master data within a model. When you create...
2012-09-19 (first published: 2012-09-17)
3,341 reads
SQLSaturday #160 – Get your SQL learn on in Kalamazoo
If you’re planning on being in the Kalamazoo, MI area this weekend, or just feel like taking a road trip,...
2012-09-17
751 reads
A Job Done Quietly and Well
My current client has a five story building, two break rooms and two sets of bathroom per floor, with I’m...
2012-09-17
634 reads
How to log SQL Server Custom Error in Windows Event Log ?
SQL server gives an option to log custom errors in windows event log. We have 2 options of achieving this.
Option...
2012-09-17
979 reads
SQL Saturday 154 Rocked - Great Job St. Louis!
This last Saturday (09/15/2012) I traveled to St. Louis to present at #sqlsat154. My colleague David Klee (blog/@kleegeek) and I...
2012-09-17
900 reads
Running a SQL Server Environment at Home Using Native Boot Virtual Hard-Drives (VHD)
I’ve run into a road block. As a Microsoft Certified Trainer, I have all the software I need to get...
2012-09-17
1,183 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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...
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