A lot of companies have several departments and want to limit the sub sites users can view. For example, the...

2013-12-20 (first published: 2013-12-16)

1,553 reads

Nine T-SQL best practices

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

SQL Server databases are the backbone of many enterprise applications, and good Transact-SQL (T-SQL) code is the best way to...

2013-12-16

978 reads

Case-Sensitive Updates in a Case-Insensitive World

by Will Assaf

SQL Tact

Assuming you're in a case-insensitive ("CI" in the collation name) column, this UPDATE statement:

UPDATE tablefoo
set foo = 'Z'
where foo = 'z'

will just...

2013-12-20 (first published: 2013-12-16)

1,818 reads

Talk Your Boss Into A Free Lunch and Giveaways!: Day 6

by Bill-(DBAOnTheGo)

DBA On The Go

Monday Giveaway!

It's Monday again! I know we all hate Mondays, but let's have a Fun Monday!It's another week to give...

2013-12-16

660 reads

Recent events wrapup

by kleegeek

Technobabble by Klee from @kleegeek

The last two weeks were just incredible! I gave my first SQL Saturday PreCon training session in Washington DC and...

2013-12-15

664 reads

MDX Implementing Logical OR On Members of Different Hierarchies

by Jennifer-Salvo

Salvo(z) SQL

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In MDX, when two or more members of the same set are placed on a...

2013-12-15

20 reads

MDX Implementing Logical OR On Members of Different Hierarchies

by Jennifer-Salvo

Salvo(z) SQL

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In MDX, when two or more members of the same set are placed on a...

2013-12-15

46 reads