Introduction Last week I attended a webcamp with Scott Hanselman and he showed Webmatrix and how cool it really is. So today I had some time to try it out and make myself a cool website. Installation He said it was only 8MB to download. It is only 8MB to download untill you click the install button after which it starts downloading a whole lot more software. It probably is no problem for people with fast internet.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
The last part of the series that shows how to create an SSIS Package to find and backup configuration files found on a server will go over the Data Flow Task (DFT). The DFT part of this process is split as half of the total processing that will be done in the package. The DFT will only be a small percentage of the overall processing time because of the Foreach Loop and staging area consuming the higher cost to the process.
When inserting to a database I find it more convenient to catch a key conflict than to perform a select in order to check for duplicates. Defining a column as unique will ensure data integrity at the lowest level. create table customer ( id int auto_increment, name varchar(20), address varchar(50), email varchar(50), constraint primary key(id), unique(email) ); Catching a user attempting to register with an email address which is already in the database is fairly simple when using DBI:
In part one and two we walked through design and the flow of the loop container for the package that will insert all files we specify into a SQL Server database. This is being developed to automate the task of backing up and maintaining changes of configuration files that reside on servers. This provides an easy and fast way to recover lost configuration files or use the configuration files during upgrades or migrations.
Introduction The computers in my domain get a standard (but very well designed) background to look at. I set this via a group policy. The problem Yep a black background instead of my beautifully designed background. You can find several solutions on google but there is one that works. And it’s this one KB977944. I would link to the download page but MS has decided that this hotfix is not for the faint of hart and you have to request it and then you get an email and the you may unzip it after you give it a password.
At my company, security for IT personnel is a bit interesting. Each IT employee has two accounts, a regular account, and a “1” account. The one account is our regular account with a 1 appended to it. How this works is our regular accounts have normal access to everything, then our 1 accounts have elevated privileges. I’m still not sure if I agree with this model but it’s what I’m stuck with.
Introduction For this report I had to make I needed to show an image I had on file, an image that should be made at runtime, actually it was a graph and I needed to show a color or two. I databind to objects not SQL. This is what it looked like in the end. Solution 1 This is the image that comes from a file. This pretty easy.
In the first part of building the package that will look at the complete contents and back up the files found in a directory and subdirectories, we discussed the designing phase of building the package itself. In this part we will take that design and start the development process. For the first step in the flow chart we defined, there is the starting process which first executes the actual work of looping through the directory and finding the files that we request.
Today was the Belgian webcamp with Scott Hanselman, Drew Robbins and Gill Cleeren and Katrien De Graeve. Needless to say I was there, yes, I know I’m not a webdeveloper but there is always room to learn. And I do some webdev for this site. Anyway, for me the webcamps started on saturday when we had diner with Scott, Drew, Gill, Katrien and a dozen other people. It also happened to be Scott’s 37th birthday and he doesn’t look a day older than 37.
This morning I got up, went to the gym and ran three miles, and headed to a testing center to take the Microsoft MCTS 70-432 SQL Server Implementation and Maintenance exam. I wasn’t expecting to ace it, since I’d been struggling with the practice exams. But I was hoping that three years of work with SQL Server and two months of studying would get me through. I arrived early and got to start early.