2014-07-16
2,792 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Not Good Enough For Government Work
The complexity of financial trading systems is too much for an amateur approach, as the losses of various Bitcoin exchanges show.
2014-07-15
350 reads
Is It Time To Clear Out Those Quirky Functions?
Phil Factor ponders a cull of some of SQL Server's worst-behaving functions.
2014-07-10
321 reads
The myth of the ‘shared development model’
Phil Factor fluffs the feathers of the shared sandbox model of development.
2014-07-02
164 reads
Application Developers don’t own their data
As a data guy, I always smile when application developers refer to ‘their’ data. If only it were that simple.
2014-06-30
387 reads
Less and Less Visual
Phil Factor ponders the preponderance of text in current database tools, and asks what happened to our glorious graphical future?
2014-06-26
142 reads
Same tune, different song
It's not new and I'm already doing it. Phil Factor, a.k.a. Methuselah, on Agile, DevOps and Continuous Delivery.
2014-06-16
142 reads
Anything Remotely Useful
Phi Factor on how to combine PowerShell Remoting with slick Windows tools such as SQLPSX, Boxstarter and Chocolatey, to automate the development process right through to delivery.
2014-06-09
113 reads
Should your Source Control System understand your code?
Phil Factor ponders why improvements to source control and versioning so often lag behind the pace of progress in development as a whole.
2014-06-02
168 reads
No reason to abandon SQL
The early signs are that we can now run a SQL-based relational database with distributed execution plans over commodity hardware, leaving just the task of splicing together of the result to the engine itself, then why can’t Microsoft or Oracle do it?
2014-05-26
201 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...
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