Beginning in 2007, daylight saving time (DST) will be extended in the United States. DST will start three weeks earlier on March 11, 2007, and end one week later on November 4, 2007. This results in a new DST period that is four weeks longer than previously observed. How that does affect SQL Server users? […]
Every once in a while there is a need to pull the rows with a row number. Here are a few solutions that I have seen to work well. Below is a sample table with employees that has employee name and employee address columns: CREATE TABLE Employees ( employee_name VARCHAR(50) PRIMARY KEY, employee_address VARCHAR(100)); INSERT INTO Employees (employee_name, […]
To have a secure and safe place to store data has always been a great desire. For years SQL Server has been improving in that area and with the release of SQL Server 2005 it has reached a special milestone. Seems the Microsoft SDL (Security Development Lifecycle) approach has helped greatly to make SQL Server […]
Seems there is a lot of confusion about the different 64 bit architectures and which are supported for SQL Server 2005 to run on. And the different vendor acronyms to describe the architectures just add to the confusion. Here is a brief note trying to sort this out. There are only two 64 bit architectures […]
Since SQL Server 2005 Express is the successor to MSDE there is a lot of interest from developers. There are a few questions that keep being asked about the installation and configuration process: How to automate the installation of SQL Server Express?How to allow remote connections?How to set up a custom named instance for installation?How […]
This Web log will be dedicated primarily to technology postings. More specifically to topics related to SQL Server and databases, as well as .NET applications, algorithms and best practices. I will post some solutions that I have seen to work, some questions and answers about particular problems, as well as reviews of new technologies. Although […]