Tampa IT Pro Camp Coming on September 22,2012
The Tampa IT Pro Camp will be held September 22 at New Horizons in Tampa (different location than last time)....
2012-07-25
663 reads
The Tampa IT Pro Camp will be held September 22 at New Horizons in Tampa (different location than last time)....
2012-07-25
663 reads
I took a break from work today to look in on an informal event a friend was hosting at his...
2012-07-25
726 reads
You can enforce referential integrity (ensure you don't get orphans) by adding Foreign Key Constraint and in this tutorial you...
2012-07-24
943 reads
In this blog psot we show how to restrict users from entering duplicated data by using SQL UNIQUE Constraint. In...
2012-07-24
793 reads
This last weekend, I had the pleasure of being invited down to Louisville, KY to speak at SQL Saturday #122....
2012-07-24
1,025 reads
As part of my preparations for 70-462 Administering SQL Server 2012 today I have created a blog post covering "evaluate...
2012-07-24
1,314 reads
I define DBA operation productivity as the total positive values brought to the work environment by a DBA in a...
2012-07-24
1,092 reads
Some of you might be wondering why Diagram View is missing in some PowerPivot windows. This is related to Microsoft...
2012-07-24
2,391 reads
The question was posed on Twitter recently (or perhaps more along the lines of “why can’t we”), suggesting that our...
2012-07-23
781 reads
My home state of Colorado has been devastated by wildfires. My vacation this summer was semi-cancelled with a fire closing...
2012-07-23
1,291 reads
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item 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