SQL Server's implementation of Window Functions
Phil factor compares SQL Server 2008's implementation of Window Functions to PostgreSQL and finds SQL Server frustratingly lacking in some of the essentials.
2010-09-27
790 reads
Phil factor compares SQL Server 2008's implementation of Window Functions to PostgreSQL and finds SQL Server frustratingly lacking in some of the essentials.
2010-09-27
790 reads
Phil Factor initially brooded about being fired from a job he was just doing unpaid to help out. Then he suddenly realized that they were probably right.
2010-09-13
340 reads
Phil Factor takes a sideways look at Houston, a new tool for building SQL Azure applications, and is somewhat underwhelmed by what he finds.
2010-08-02
204 reads
Phil discusses the pros and cons of the traditional versus stack overflow-style model for forum debate, and wonders whether there is a database model that would support all these different forms of discussion, or cooperative work, so that we can simply fit the 'visualization' to the nature of the particular discussion.
2010-06-28
88 reads
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
234 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
276 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
355 reads
2010-05-10
1,530 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
322 reads
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
By Steve Jones
mcfeely – adj. inexplicably moved by predictable and well-worn sentiments, even if they are...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
HI All, can any one reply on this when primary is down and not...
Comments posted to this topic are about the item The On-Call Load
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers