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
184 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
257 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
96 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
222 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
135 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
278 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
627 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
156 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
530 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
105 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
All week we've had issues with the site being up and down. There's been...
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers