Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,062 reads
The Surface Meta-App
Just a quick little blog post about one more app you’re going to want to track down for your Surface....
2012-12-12
962 reads
TSQL Tuesday #37 – Joins and Implicit Conversions
Here we are at TSQL Tuesday #37 – the start of the fourth year. Sebastian Meine (@sqlity / blog) is hosting this...
2012-12-11
2,021 reads
SQL Server 2012 security: Changes for the newest version
Database infrastructure security is extremely crucial for any organization, which is why Microsoft has invested heavily in SQL Server security...
2012-12-11
1,197 reads
Does my SQL Server database use any Edition specific features?
Today, I received a phone call from a friend who is thinking to downgrade the database hosted in SQL Server...
2012-12-11
686 reads
Database Snapshots – A view of database at a specific point in time
Beginning with SQL Server 2005, Microsoft introduced a new feature called database snaphots, which gives DBAs a way of presenting...
2012-12-11
897 reads
Let’s Talk About Joins
T-SQL Tuesday #37 This month please join us in the TSQL blog party that happens on the second tuesday of the month. It is hosted this month by Sebastian Meine (@sqlity)....
2012-12-11
17 reads
Let’s Talk About Joins
T-SQL Tuesday #37
This month please join us in the TSQL blog party that happens on the second tuesday of the...
2012-12-17 (first published: 2012-12-11)
2,948 reads
Optimizing Your BI Semantic Model for Performance and Scale
Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented...
2012-12-11
3,031 reads
Can I use SSDT for the 2008 BI stack?
SQL Server Data Tools (SSDT) that was released with SQL Server 2012 obviously works with the BI stack (SSIS/SSAS/SSRS) for...
2012-12-11
2,433 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