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.
Designing A Data Warehouse: Part 1 Dimension Types
In this first part of a multiple part series, Brian Knight shows the different types of slowly changing dimensions you'll use and the business reason for using each type.
Different forms of CrossJoin
This article is about different syntactical ways to write CrossJoin in MDX, all of which are completely equivalent from the functional and performance standpoint. Therefore, the article doesn't convey any practical information, and can be ignored. Readers curious about history of MDX can keep reading, however.
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers