SQL Server: String Pattern Matching
It is common scenario that, we might need to extract the data from the SQL server based on some pattern....
2012-09-13
11,735 reads
Yesterday I was hacked
That’s right, for all my years in IT yesterday I was the victim of a vicious and deeply distressing incident....
2012-09-13
1,056 reads
Winner Winner Chicken Dinner!
I have spent a lot of time on the road this year with work but over the summer I was...
2012-09-13
653 reads
Labor Day Bloopers
The raw footage of all the mistakes I’ve made since the Fourth of July.
Part 1
Part 2
Filed under: Blog Tagged: Humor,...
2012-09-12
1,005 reads
SQL Server: Understanding GAM and SGAM Pages
We know that SQL server stores the data in 8 KB pages. An extent is made up of 8 physically contiguous...
2012-09-12
26,791 reads
Interview on RunAsRadio #281 with Richard Campbell
I recently had a chance to record a 33 minute podcast interview on RunAs Radio #281 with Richard Campbell, where...
2012-09-12
1,207 reads
Sometimes Failure Is An Option
Wouldn’t it be nice if failure was an option? You could go along in life, screw it all up and...
2012-09-12
780 reads
Master Data Services Terminology Overview
When moving from a data warehouse world to MDM, there is some new terminology to learn. Each of the terms...
2012-09-12
1,008 reads
Pearls in the Ocean – Part 1
In our day to day life with SQL Server, We refer web for many reasons.
This includes understanding new SQL...
2012-09-12
820 reads
Misc Reading for September 12, 2012
Sharing some stuff I’ve read recently that I found interesting – and that you may find interesting!
Help More, Judge Less. I’ll...
2012-09-12
668 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