SSIS: Script Component Asynchronous Transformation
The SSIS script component can be configured to use synchronous or asynchronous outputs. If the script component is configured for...
2012-03-20
8,161 reads
Microsoft Releases SQL Server 2008 SP2 Cumulative Update 9
Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has...
2012-03-20
1,814 reads
PASS for Today (and Tomorrow)
I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate...
2012-03-20
591 reads
Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database. If not you, then possibly a manager or client. Usually this comes up...
2012-03-20
5 reads
Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database. If not you, then...
2012-03-26 (first published: 2012-03-20)
2,438 reads
Get Free Learning
A couple of different events going on today and tomorrow:
Today (03/20) at 3pm CDT - "Choose Your Own Adventure: Performance Tuning"...
2012-03-20
492 reads
Free E-Book on SQL Server 2012, Great Job by Ross Mistry and Stacia Misner (yes, they have done it again :)
Free E-Book: Introduction to SQL Server 2012
Ross Mistry and Stacia Misner have again done a wonderful job on this free...
2012-03-20
2,423 reads
FILESTREAM and Snapshot Isolation Mode in SQL 2008
FILESTREAM and Snapshot Isolation mode are incompatible in SQL 2008.
In SQL 2008 R2 however...
http://msdn.microsoft.com/en-us/library/ms173763.aspx
In SQL Server 2008 R2, snapshot...
2012-03-27 (first published: 2012-03-20)
2,211 reads
Powershell - Working with Cluster Resources - Byte Arrays
Over the next few weeks, I plan to share some of the discoveries I've had when working with Windows 2008R2...
2012-03-19
2,494 reads
SQL in the City: Free SQL Server Event in London
Red Gate Software has announced “SQL in the City: London,” to be held on Friday, July 13, 2012, at the...
2012-03-27 (first published: 2012-03-19)
1,613 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers