A Month of PowerShell – Day 6 (Exporting and Importing)
Welcome to Day 6 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-06
799 reads
DBAs and the Dark Closet
For many years, I loved being a DBA because, unlike being a developer, I could sort of hide from the...
2013-02-06
1,036 reads
Speaking at the Business Analytics Conference, April 1-12 in Chicago
The email message earlier today said “Please note that the official schedule will be released tomorrow, February 6th, so please...
2013-02-06
693 reads
Partitioning Relational Data – (Part – 2)
This is the second part of the three part article series on partitioning relational data.
In the first part of this...
2013-02-05
718 reads
I’m Speaking at ….
Last week I noted that I was speaking at the new SQL Intersection event. Hopefully I’ll see some of you...
2013-02-05
892 reads
SQL Server 2008 R2 Diagnostic Information Queries (Feb 2013)
Here is the February 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...
2013-02-05
1,169 reads
Join Me at Modern Apps Live! Las Vegas
If you are familiar at all with Visual Studio Live! then you should check out this new conference. At the...
2013-02-05
604 reads
Installing Team Foundation Server (TFS) 2012
My experience installing Team Foundation Server (TFS) 2012 to house my business intelligence projects built in Visual Studio 2010:
I am installing...
2013-02-05
6,031 reads
A Month of PowerShell – Day 5 (Scripting – Putting it together)
Welcome to Day 5 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-05
1,668 reads
Invitation for T-SQL Tuesday #39 – Can you shell what the PoSH is Cooking?
T-SQL Tuesday Party History
In case you’ve been hiding out in the desert, oblivious to all that goes on, there is...
2013-02-08 (first published: 2013-02-05)
1,570 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...
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
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