Networking = Business Cards
I've been writing a lot about networking lately and my efforts to learn/leverage LinkedIn, and along the way taken a...
2009-04-13
832 reads
I've been writing a lot about networking lately and my efforts to learn/leverage LinkedIn, and along the way taken a...
2009-04-13
832 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-13
298 reads
Time has flown by since my last update, busy time at work and struggling to get that done and find...
2009-04-13
425 reads
As I've covered in my two earlier posts I've been investing a little time to figure out how to make LinkedIn work for me. This time I wanted to talk about some extra tools they provide that you may find useful. One that I mentioned previously...
2009-04-13
3,192 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-12
323 reads
Back in December 2008 I wrote up a quick review of Red Thunder, and then received Red Lightning as a...
2009-04-09
303 reads
Please consider this a not quite official announcement, look for that on the sqlpass.org site today or tomorrow.
You may have...
2009-04-09
1,227 reads
The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.
2009-04-09
2,694 reads
Many of us make a living by working on tasks while monitoring email, taking a few calls, and in non uncommon cases also keeping up with Facebook, Twitter, and more. Often it's multiple tasks, and we get better at plate spinning.
2009-04-09
1,664 reads
I've never been a fan of animation in Powerpoint presentations, and as a result almost never use them in my...
2009-04-08
426 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
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