Phil recently had to draw up a list of 'top ten' pieces of advice for programmers who were starting out as database developers. It is a difficult thing to do when one is immersed in the study of the intricacies and detail of the plumbing of SQL Server.
2008-12-18
424 reads
The exceptional talents of seasoned engineers and developers can never quite be rendered obscelete by technological wizardry. Phil Factor considered old-school intuition, and wonders if he's missed a trick.
2008-12-12
451 reads
Phil Factor talks a bit about the SQLServerCentral community and how we all get something different from it.
2008-11-28
98 reads
Phil wonders whether it is time to come up with clear 'best practice' guidelines to cover the use of undocumented routines, and ends up deciding it is a gray area.
2008-11-24
386 reads
While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.
2008-11-20
237 reads
/* Imagine that you have some names and addresses. You are anxious to look at the addresses that may be spurious....
2008-11-03
659 reads
Somehow, one is expected to be pleased that SQL Server 2005 is going to have another Service Pack. Why? For many DBAs, SQL Server 2005 is still a dangerous and radical upgrade. Phil Factor considers Microsoft's responsibilities...
2008-10-28
184 reads
SQL Server and Sybase are geared up
to send information to applications over two distinct channels, the results in
one channel that...
2008-10-20
895 reads
/*datafile used in the SQL */
DECLARE @String VARCHAR(MAX)
SELECT @String = 'When you are starting out to validate text input, perhaps to clean...
2008-10-09
1,073 reads
I wrote the prettifier specifically to help with posting SQL into blogs and forums. You can find it here http://extras.sqlservercentral.com/prettifier/prettifier.aspx...
2008-10-07
6,649 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers