his article will explore various methods of accessing SQL Server from inside Microsoft Expression Web. Microsoft Expression Web is a graphical development tool for creating web pages and is part of the new Expression Studio.
2007-05-10
2,274 reads
The .NET Framework 2.0 introduces a very handy new class in the System.Data.SqlClient namespace called SqlBulkCopy that makes it very easy and efficient to copy large amounts of data from your .NET applications to a SQL Server database. You can even use this class to write a short .NET application that can serve as a "middleman" to move data between database servers.
2007-05-09
3,525 reads
Allen White provides an SMO script for automating database log backups, using either native backup or Red Gate's SQL Backup tool.
2007-05-07
2,426 reads
In this session, Brian shows you how to use configuration files or a configuration file to dynamically configure your packages. With configuration files, you can seamlessly migrate an SSIS package from QA to production without worry and without having to reconfigure the package.
2007-05-04
2,582 reads
In this session, Brian shows you the basics of the SQL Server Integration Services Control Flow. He shows you how to orchestrate a package in the control flow with precedence constraints and how they relate tasks together in the control flow and how to tasks are executed and in what order. He also shows some of the advanced properties of the control flow that help with parallelism.
2007-05-03
2,533 reads
In this presentation, Ira shows you how to data profile in SSIS using a Script transform and some creative methods like RegEx. He shows you how to look for patterns in your data to find bad data that wouldn't be obvious to the eye or casual viewer.
2007-05-02
4,307 reads
In this demonstration, you'll quickly learn how to create a basic cube using the Cube Wizard upon a data warehouse. Brian walks through the entire process in this 10 minute video to get you started with creating a browsing a cube.
2007-05-01
3,441 reads
In this first video of the series, you'll learn what SQL Server Integration Services does and a little about the environment. After you see this video you should be able to understand much of the terminology and toolset that SSIS developers use.
2007-04-30
3,155 reads
Having a consistent SQL Server environment is important. Gregory Larsen discusses one method of scripting your installation to ensure all of your SQL Server 2005 machines are set up the same.
2007-04-27
2,692 reads
This article looks at logging your database changes from a developer's perspective.
2007-04-26
4,581 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers