O, There’s the Data: Using OData in SSIS
The Open Data Protocol (OData) is an open specification created Microsoft to enable exposing data in a standard way from...
2012-07-23
1,290 reads
SQL DEFAULT CONSTRAINT Syntax
This time we show how to use SQL DEFAULT CONSTRAINT to provide values for fields that are not given a...
2012-07-23
634 reads
Windows Cluster: Moving Quorum Disk to Another Node
In my earlier post I have explained about various quorum settings available in Microsoft windows 2008 cluster environment. While we plan to...
2012-07-23
15,410 reads
SQL CHECK CONSTRAINT Syntax
We have now added SQL CHECK CONSTRAINT to Exam Guide 70-461 Querying SQL Server 2012 and SQL Tutorial
2012-07-23
925 reads
SQL PRIMARY KEY CONSTRAINT Syntax
In this tutorial we show how to use ALTER TABLE and add Primary key constraint. This tutorial support our Exam...
2012-07-23
755 reads
TechEd Europe 2012 videos online
Microsoft has posted ALL the session videos for TechEd Europe 2012 and they are available for free! What a great...
2012-07-23
852 reads
As one door closes another one opens
Normally I try and keep the things that happen at work separate from my blog, however it’s been an interesting...
2012-07-27 (first published: 2012-07-23)
2,534 reads
Working at Home Tips for Erin
A friend of mine, Erin Stellato (blog | @erinstellato) is about to change jobs. She’ll go from working in an office...
2012-07-26 (first published: 2012-07-23)
2,581 reads
PowerPivot default measure aggregation
One of the PowerPivot advantages is flexibility of changing measure aggregation for instance changing average to minimum. PowerPivot applies default...
2012-07-23
704 reads
PowerPivot hide fields and unhide in Excel 2013
In this PowerPivot tutorial I show how to improve user experience by hiding fields from PivotTable (client tool) so user...
2012-07-23
827 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
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