Things have been a bit crazy the last couple of days (my wife is pregnant and there have been a few complications), but I wanted to share some links I've come across the last couple of days: Video - Visual Studio 2005 for Database Professionals (MS Channel 9) Implementing Role Based Security with ASP.NET using Windows Authentication and SQL Server (From ScottGu's Blog) Free web site templates - Open Source Web Designs Chris Technorati : .NET, ASP.NET, Database Professionals, Microsoft, Open Source,...
I'm not a DTS wizard by any means. I don't use it a whole lot, and always consider writing a program to move data around instead (Although I rarely do since DTS is usually quicker and can be set up pretty quickly) since I don't find it very intuitive. When I needed to move a list of users from one database to another, either inserting if they didn't exist, or updating information if they did, I wanted to see if DTS had a simple solution. Now I had to do a lot of searching online before I figured...
I finished orientation for my new job yesterday. I'll be starting Hanover County Public Schools on their first big .NET project. It'll be my first exposure with IBM DB2, but hopefully that will eventually go away to be replaced with SQL Server or Oracle. In other news, I've seen almost 180 hits on my articles that I published last week! That's certainly better than I expected. No feedback yet, so I'm not sure if that's good or bad. I've started work on my next article, sending email in .NET 2.0....
I've just wrapped up the second part of my articles on Inserting into SQL Server without the VS Designer. This is only my second article, so comments are welcome! Inserting into SQL Server, without the Designer - Part 2 - Creating a Connection And if you haven't read part 1, you can find it here: Inserting into SQL Server, without the Designer - Part 1 – Creating a Stored Procedure Chris...
Introduction This 3 article series will cover inserting data into SQL Server, without the help of Visual Studio’s drag and drop controls and configuration wizards. A special emphasis will be placed on its application within a tiered environment. Part 1 – Part 2 – Part 3 Part 2 – Creating a Connection Now that we have a stored procedure, we need to be able to connect to our database. I’ll cover a brief overview of a SQL connection string, some basics about the SqlConnection...
Introduction This 3 article series will cover inserting data into SQL Server, without the help of Visual Studio’s drag and drop controls and configuration wizards. A special emphasis will be placed on its application within a tiered environment. Part 1 – Part 2 – Part 3 Part 1 – Creating a Stored Procedure While inline SQL may be an easy way to access databases, it’s far from ideal. Stored procedures are the recommended method of SQL Server access. They protect you from...