Additional Articles


External Article

Faking Arrays in Transact SQL

It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL. In a perfect relational world, it isn't necessary, but real-world data often comes in a form that requires one of the surprising variety of routines that Anith Sen describes, along with sage advice about their use.

2008-09-24

5,751 reads

External Article

Scheduling Jobs in SQL Server Express

As we all know SQL Server 2005 Express is a very powerful free edition of SQL Server 2005. However it does not contain SQL Server Agent service. Because of this scheduling jobs is not possible. So if we want to do this we have to install a free or commercial 3rd party product. This usually isn't allowed due to the security policies of many hosting companies and thus presents a problem. Maybe we want to schedule daily backups, database reindexing, statistics updating, etc. This is why I wanted to have a solution based only on SQL Server 2005 Express and not dependent on the hosting company. And of course there is one based on our old friend the Service Broker.

2008-09-23

3,241 reads

External Article

Kalen Delaney: Geek of the Week

Kalen Delaney has been involved in SQL Server from the beginning. Her talks and her writings are always interesting but, most important of all, she was able to successfully take on authorship of the 'Inside SQL Server' series of books from Ron Soukup, and make them her own. Despite her own protests that she is a trainer first and foremost, she richly deserves our accolade of 'Geek of the Week'.

2008-09-22

2,473 reads

Technical Article

Build a Metadata-Driven ETL Platform by Extending Microsoft SQL Server Integration Services

SQL Server 2008 Integration Services (SSIS) provides a flexible and scalable architecture that enables high-performance data extract, transform, and load (ETL). The Microsoft Business Intelligence Center of Excellence has extended SSIS to a metadata-driven platform to more effectively build, deploy, and manage ETL processes in large data warehousing environments.

2008-09-19

3,818 reads

Technical Article

Data Warehouse Capacity Planning as Capacity Enforcement

Capacity planning is a problem for a data warehouse because it sets contrasting functional requirements against each other. On one hand, data warehouse customers consume data warehouse capacity as they query the data in the data warehouse business intelligence (BI) reporting. Meanwhile, applications consume data warehouse capacity as they load data into a data warehouse through the extract, transform and load (ETL) process.

2008-09-19

3,269 reads

Blogs

Data Céilí 2026 Call for Speakers!

By

Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...

Streamlining Azure VM Moves Into Availability Zones

By

One of the more frustrating aspects about creating an Azure virtual machine is that...

Monday Monitor Tips: Native Replication Monitoring

By

Redgate Monitor has been able to monitor replication for a long term, but it...

Read the latest Blogs

Forums

Deprecated Feature Tracking

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deprecated Feature Tracking

Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL

By utsav

Comments posted to this topic are about the item Think LSNs Are Unique? Think...

A Big PK

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Big PK

Visit the forum

Question of the Day

Deprecated Feature Tracking

From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?

See possible answers