Codeplex: SSIS Community Tasks and Components
I recently bumped into this very exhaustive list of SSIS tasks, components and samples in CodePlex http://ssisctc.codeplex.com. The list is maintained by...
2011-12-14
1,332 reads
Blog Posts
Contracting, SQL Server and gethynellis.com
A while back I started posting some contractor related articles.The articles were mainly for the those people that wanted to...
2011-12-14
609 reads
Data Mining
Data mining techniques can be used in virtually all business applications, answering various types of businesses questions. In truth, given...
2011-12-14
2,357 reads
Does the Role of the DBA Need to Evolve?
This editorial was originally published in Database Weekly.
The November 2011 edition of Popular Science magazine was devoted to data. In...
2011-12-14
998 reads
Installing SharePoint 2010 and SQL Server 2012 RC0
With SQL Server 2012 right around the corner and Release Candidate 0 already out there I’m sure you will all...
2011-12-14
5,194 reads
Maintenance Plan mystery
Last week I had interesting (or I can say weird ? ) case of Maintenance Plan. One of the server that we...
2011-12-14
561 reads
Master Data Services Error: Resolving from a long-running stucked Staging Batch with Status “Queued to Clear” or “Not Running”
In some ocassions, you may run into a runaway, long-running or stucked staging batch with Master Data Services in SQL Server 2008...
2011-12-14
1,578 reads
Nic Teaming
Network card teaming or NIC teaming are networking terms describing methods of combining multiple parallel network connections . The main purposes...
2011-12-14
1,765 reads
Notes from the MagicPASS Holiday Party
I haven’t been to a MagicPASS meeting in a while, so it was nice to reconnect with the group at...
2011-12-14
733 reads
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
Subject:Row Versioned Data WarehousesStart Time:Thursday, December 15, 2011 6:00 PM US Pacific...
2011-12-14
807 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers