Spotlight on SQL Server - Raul Garcia
Our spotlight series is bringing you a look at the people behind the software at Microsoft and this time we delve into security a little as we get to know Raul Garcia.
2006-07-06
3,942 reads
Our spotlight series is bringing you a look at the people behind the software at Microsoft and this time we delve into security a little as we get to know Raul Garcia.
2006-07-06
3,942 reads
Automating installations with SQL Server 2000 is easy because it creates a setup.iss file that you can use as input, but Microsoft removed this feature from SQL Server 2005. Learn an undocumented SQL Server 2005 feature that provides similar functionality to setup.iss.
2006-07-06
1,777 reads
Software developers constantly need to learn about new technologies, products and methodologies. Think about what sort of programming you were doing 5 or 10 years ago. If you have been developing software that long, you will, no doubt, be working on very different systems now than you were then.
2006-07-05
2,472 reads
Ensuring that your disk subsystem performs well and does not run out of space is a balancing act that many DBAs learn over time through trial and "out of space" errors. New author Arindam Banerjee takes a look at some of the things to consider when capacity planning.
2006-07-04
15,872 reads
This article adds some handy reporting capabilities to the new load testing tool in Visual Studio 2005 Team System.
2006-07-04
1,459 reads
Building a data warehouse is a complicated topic and a hot topic now. Many companies embark upon these projects without understanding what they really need. New author Janet Chan takes a look at some of the things you need to consider before embarking on a project such as this.
2006-07-03
11,095 reads
Enter to win a Ms Pacman/Galaga arcade machine when you download and register a free version of Microsoft Visual Studio Express Editions (free learning resources included).
2006-07-03
1,647 reads
The benefits and drawbacks of GUIDs as primary keys are generally known. Despite the drawbacks, some people use them to fulfill specific business requirements (the IDs are unique across multiple servers).
2006-06-30
2,858 reads
Over the last year we've taken a look at a number of people influential in the SQL Server community. This time Steve Jones spent a little time interviewing MVP and regular blogger Simon Sabin.
2006-06-29
5,030 reads
This article provides a guide for physical storage design and gives recommendations and trade-offs for physical hardware design and file architecture.
2006-06-29
3,858 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