In PowerShell, Phil Factor believes we have a true novelty: a Windows Scripting language that outsmarts Perl and Python and Ruby and one that will continue to cause radical changes to Windows server applications, and the tools we use to administer them.
2012-06-25
179 reads
Phil Factor welcomes SQL Server support by Amazon RDS, as an alternative to having Microsoft as service provider as well as software provider, via the PaaS formerly known as Azure.
2012-05-14
248 reads
Phil Factor on the irresistible urge to write code in the public domain, and the occasional desire to be free from the snails-trail of software that needs maintainence.
2012-04-16
87 reads
You need a quiet couple of hours poking about with DMVs, and checking execution plans to get to the bottom of the a query issue, but you can't make a copy the production database either. It's too big, and the data is private....
2012-03-26
211 reads
A disconnected model is only really needed in the absence of a properly-defined database interface. We, as developers, create a rod for our own backs by insisting on treating a database in a way we wouldn't treat an object, let alone an assembly or namespace.
2012-03-19
126 reads
If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry.
2012-02-27
270 reads
In SQL Server, we treat XML with a reverence that is disproportionate to its importance. The SQL Server team have indeed gone big on XML, as Michael Cole’s book reveals. The industry has gone big in another direction: JSON.
2012-02-20
624 reads
It always surprises me when Application programmers tell me that all 'Agile' techniques are directly applicable to database development. Ideally, yes; but reality gets in the way.
2012-01-09
150 reads
Today we have a guest editorial from Phil Factor. Phil wonders why so many people in technology can be stubborn. Are you a stubborn DBA?
2012-01-09
505 reads
In which Phil Factor argues that Domain Constraints are a fundamental part of the relational database. If he had to sacrifice a feature of relational databases, it wouldn’t be domain constraints.
2012-01-02
101 reads
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
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