Microsoft have been cooking up something for Database Developers in Visual Studio 2010, and Phil Factor has decided it's high time he looked into it. It's not as odd as it sounds, and is actually rather promising, as Phil discovers.
2010-06-14
362 reads
Regardless of the speed of your SQL routines there comes a time, for any server-based system, when you need to think "parallel" and "asynchronous". So why, Phil Factor wonders, does there seem to be so little interest in Service Broker?
2010-05-31
236 reads
Just because mistakes have become entrenched in the computer languages that we use doesn't mean we have to tolerate them
2010-05-21
285 reads
Recent experts in Development techniques don't seem inclined to study the history of programming; There isn't that much that's new in the art of Unit Testing database development work
2010-05-19
356 reads
2010-05-10
1,531 reads
Phil Factor believes that there will have to be further compromises between the pioneers of The Cloud and the regulators, before companies feel safe in entrusting their financial data to such an abstract service, seemingly 'remote from sand and iron'.
2010-04-26
329 reads
A guest editorial from Phil Factor that discusses ORMs and how they ca be used, or mis-used, in our applications.
2010-03-31
387 reads
This week, a guest editorial from Phil Factor on how SQL Server database documentation falls woefully short of what is required and expected by most development teams.
2010-03-15
442 reads
Phil Factor believes that we have become so immersed in the idea that administrators or accountants can run technical enterprises, unaided, that we are in danger of forgetting the vital creative contribution of the technologist.
2010-01-25
106 reads
Phil Factor points out the limitations and irritations of Hungarian Notation.
2010-01-25
796 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers