The secret skill revealed in the dusty booklet
Going through one’s father’s belongings after his death is
always a poignant, bitter-sweet experience. I was going through his most
precious books...
2009-06-18
2,004 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
CLR Triggers in SQL Servers
Do CLR triggers really represent the most popular usage of CLR in enterprise SQL Servers? Phil Factor wants to know if this is the case, and if so, what on earth are they doing?
2009-06-08
516 reads
Intruding into Dummy Websites
Phil Factor muses on security, bayonets, and databases, and somehow manages to pull it all together in this editorial.
2009-06-02
241 reads
Teched Water Bottle
One of the charming people who helped me register at Teched told me where we, who had registered, could get...
2009-05-10
1,728 reads
The Walking Billboard
I spent a fascinating hour at the Teched Shop this afternoon. I was trying to get a feel for where...
2009-05-10
1,290 reads
Confessions of an IT Manager, 2nd Edition
The software industry is, just occasionally, more absurd than one would dare to imagine. Having spent most of his working life in its clutches, Phil Factor has pretty much "seen it all" and what's more he's prepared to tell what he knows. The second edition of Phil's "Confessions of an IT Manager" contains Phil's full repertoire of tales of institutional mayhem and software projects gone awry.
- Download free eBook
- Printed book:
2009-05-07
2,551 reads
Professor Hugh Bin-Haad.
Steve Jones isn't usually the wild man of publishing, but on April 1st, a strangely
anarchic spirit breaks loose. Having...
2009-04-03
1,510 reads
The Visit of the Recovery Testers.
Phil has a nasty surprise when a team of testers turn up to test an n-tier system
2009-03-30
121 reads
Accessing results in a random order: Towards the automated Thank-you letter
Phil shows how 'CROSS APPLY' can be useful for writing thank-you letters or thinking of excuses as to why your project has failed....
2009-03-18
3,881 reads
Accessing results in a random order: Towards the automated Thank-you letter
Most of the time, you want to have a SQL result in a particular order. Occasionally you just don't care....
2009-03-16
3,138 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