Day 10 of 31 Days of Disaster Recovery: Monitoring for Corruption Errors
31 Days of Disaster Recovery
It’s day 10 of my 31 Days of Disaster Recovery series, and I want to...
2013-01-11
1,364 reads
DBCC Memorystatus SQL2012 – A quick observation for node Process/System Counts
This post is not a detailed explanation of DBCC Memorystatus for SQL2012,but a quick observation I made recently for the...
2013-01-11
3,303 reads
SQL Bits XI Registration is Now Open
Hi all,
registration to attend SQL Bits is now open.
http://www.regonline.com/Register/Checkin.aspx?EventID=1163518
There’s a 600 capacity limit and they anticipate it to fill rather quickly. More details can be found here:
http://sqlbits.com/
Hope to see...
2013-01-11
17 reads
Talking on Purpose
Last year I stepped into the intimidating (and slightly effervescent) waters of the consulting world, and found great success. This...
2013-01-10
783 reads
MDS Error SYSERR207 after SQL Server 2012 SP1 Upgrade
After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only...
2013-01-10
1,274 reads
SQL Server Virtualisation and Consolidation
Come and join me in London this March for a 3 day course on SQL Server virtualisation and consolidation.The course...
2013-01-10
1,036 reads
sp_Blitz, v16, on SQLServerCentral
Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and...
2013-01-10
1,410 reads
Observe Carefully When Things Are Running Fine
Cross-posted from The Goal Keeping DBA blog:
As a worker in information technology, I’ve always been a big proponent of studying systems...
2013-01-14 (first published: 2013-01-10)
2,173 reads
Speaking at Midlands PASS in February
On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia,...
2013-01-10
971 reads
Restore database permissions
Introduction:
I came across a couple of subtle gotchas around the permissions required to restore a database in SQL Server 2008+...
2013-01-10
6,411 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