How To Video: Creating a Proxy Account
In this session by Brian Knight, he shows you how to create a proxy account for SQL Server Agent to use. Proxy accounts and SQL Server 2005 credentials help you impersonate another Windows account in Agent.
SQL Server Spotlight on Sameer Tejani
The people that develop SQL Server are very interesting in addition to being some of the top software developers around. Steve Jones
continues with his look behind the development team with an interview with Sameer Tejani.
A Discount on SQLMaestro
SQLMaestro has a new version and is offering a discount to SQLServerCentral.com members.
SQL Server 2005 Integration Services - Part 44 - Bulk Insert Task
Recent installments of our series dedicated to SQL Server 2005 Integration Services have discussed individual Control Flow tasks. This installment covers one of the few remaining items in this category, the Bulk Insert task.
Are you ready for Data Warehouses?
Data warehousing is being used more and more everyday and longtime data warehouse DBA Janet Wong brings us a short look at
her first project and some thoughts about warehousing in general.
Introduction to Data Warehousing Part 1
In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.
More Problems with Data Warehousing
In response to the first part, new author Richard Gardner brings us a few more issues that you should be aware of when planning
your data warehouse.
SQLServerCentral.com Site Migration
A short look and some notes from the SQLServerCentral.com site migration.
Mastering Enterprise BI: Time Intelligence Pt. II
BI Architect Bill Pearson continues his introduction to enhanced features in Analysis Services 2005 for Time Intelligence support. In this session, we examine new, wizard-driven features that support the easy addition of Time Intelligence within our cube.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Purpose of the Rice Purity Test
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers