Building a Kimball Data Warehouse
Learn about the Kimball method for data warehouses and how you can get started building one.
2023-06-14
4,863 reads
Lee Everest
Introduction to Bitmasking in SQL Server, Part 2
In part 2 of his series, Lee Everest expands upon bitmasking and integrates this with the SQL CLR.
2009-05-21
21,469 reads
Introduction to Bitmasking in SQL Server 2005
The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.
2007-12-05 (first published: 2006-12-13)
18,436 reads
Blogs
SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow
Want to build a data analytics foundation that transforms raw data into valuable business...
Using SQL Compare in Read-Only Databases
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
T-SQL Tuesday #179 Roundup: The Data Detective Toolkit
By Tim Mitchell
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...
Forums
Date Type ETL Question
I'm not sure that I'm posting this in the right section, so please mods...
Possible oddity in msdb.dbo.backupset
Hi all I've written a script to keep track of how long backups...
Operand data type varchar is invalid for sum operator
I have this view [dbo].[Asset Metrics - Client(Rama -Client-Test)], which makes use of multiple...
Question of the Day
Data Migration Assistant Sources
In the current (Sep 2024) Data Migration Assistant, what are the possible sources for on-premises SQL Server instances?
See possible answers