On the Second Day…
Yesterday, I introduced the 12 Days of pre-Christmas. In that first article, I gave you a gift to help maintain...
2012-12-14
1,202 reads
Cross-database Queries by Contained Users
Cross-database Queries by Contained Users
http://www.necromaticmedia.com/2007/11/containment/
I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on...
2012-12-14
1,692 reads
Big Data and Hadoop Part 1
Big Data Definition
As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools...
2012-12-14
455 reads
Next Gen File System ReFS(Resilient File System) and SQLServer !
“ReFS”, this term was absolutely new to me when I was reading this white paper from Microsoft ‘Storage Windows Server...
2012-12-13
1,177 reads
On the First Day…
Many of us have heard the song “The Twelve Days of Christmas.” Some are familiar with how that song has some connection with the Holiday season for Christians. Fewer...
2012-12-13
24 reads
On the First Day…
Many of us have heard the song “The Twelve Days of Christmas.” Some are familiar with how that song has...
2012-12-13
842 reads
Solution to VSTA editor error in SSIS 2012
The script task in SSIS 2012 is a great tool when you need to use C# or VB code to...
2012-12-13
3,696 reads
SQL Server Training–New York New York!
For those that read my blog regularly you will know that I over the last couple of years I have...
2012-12-13
1,034 reads
Using XQuery to remove duplicate values or duplicate nodes from an xml instance
Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...
2012-12-20 (first published: 2012-12-13)
19,572 reads
The Great DBA Getaway
Free, at last!
It’s holiday season which means it’s a time for you all to buy me gifts super busy time for Data...
2012-12-12
1,038 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
BCA KCP Banjaran Adiwerna Hub/Wa. 0817-819-444
Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa Tengah...
BCA KCP Ketanggungan Timur Hub/Wa. 0817-819-444
Jl. P. Diponegoro No.141, Dukuhtengah, Dukuh Tengah, Kec. Ketanggungan, Kabupaten Brebes, Jawa Tengah 52663
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