Row Number in SQL Server
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, […]
How to close a tab with mouse middle click?
When I had to do this I’ve searched all over the Internet for some information on how to implement such a feature, but I have found nothing. The main problem was how to detect on which tab exactly has the user clicked on. I haven’t found any method or property of the TabControl or TabPage […]
SQL Server is The Safest Database
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 […]
Password TextBox in WPF
In .NET Framework 3.0 (WPF) Microsoft have removed the property of a TextBox, which specifies whether the textbox is Password or Normal type. But in replacement they’ve introduced a new control named PasswordBox which is very simple and intuitive to use. Here is a simple example: XAML: <PasswordBox x:Name=”txtPassword” ToolTip=”Password” PasswordChar=”*” /> By default the […]
64-bit Architectures for SQL Server 2005
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 […]
SQL Server Express Installation and Connectivity Configuration
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 […]