Professional Development
How much time do you spend developing your career? Are you actively looking to improve your professional skills? Andy Warren takes a look at how you can focus yourself and a few ideas for your employer as well.
Using a Basic Data Flow Task in SSIS
In this quick video, Brian shows how to use SSIS to make a simple transformation occur of your data. He aggregates and sorts the data before writing the data to a flat file. After you watch this video, you will know how to use the Data Flow task inside of SQL Server 2005 SSIS. Free registration required.
Making Sense of the XML DataType in SQL Server 2005
n SQL Server 2005, XML becomes a first-class data type. Developers can make minor remote modifications to stored XML documents easily, taking advantage of new support for XML schema-based strong typing, and server-based XML data validation.
Using a Script Transform in SSIS
In SSIS, the data you receive from the source is rarely in the format your end users would like to see. To correct this, you can use the Script Component to transform data. In this video demo, Brian shows you how to use the Script transform to make a column proper case in the data flow. Free registration required.
SQL Server and MOM Part II
This article will continue where the last one left off. We will import MOM 2005 Management Packs and Reports and begin monitoring SQL Server 2005.
Using Checkpoints in SSIS
SQL Server Integration Services checkpoints enable you to start a package from where it failed. This helps you avoid having to re-run a 6 hour package over again. Learn how to use this valuable feature with this quick how-to video. Free registration required.
Spotlight on SQL Server - Raul Garcia
Our spotlight series is bringing you a look at the people behind the software at Microsoft and this time we delve into security a little as we get to know Raul Garcia.
SQL Server 2005's Undocumented Solution for Unattended Installs
Automating installations with SQL Server 2000 is easy because it creates a setup.iss file that you can use as input, but Microsoft removed this feature from SQL Server 2005. Learn an undocumented SQL Server 2005 feature that provides similar functionality to setup.iss.
SQL Server and .NET training and career development part 3
Software developers constantly need to learn about new technologies, products and methodologies. Think about what sort of programming you were doing 5 or 10 years ago. If you have been developing software that long, you will, no doubt, be working on very different systems now than you were then.
Analyzing Disk Capacity for SQL Server
Ensuring that your disk subsystem performs well and does not run out of space is a balancing act that many DBAs learn over time through trial and "out of space" errors. New author Arindam Banerjee takes a look at some of the things to consider when capacity planning.
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers