Rolling your own index lookups
Over the past few weeks, I’ve been training developers in what they really need to know about SQL Server to...
2011-08-01
1,351 reads
August Question: How Do You Manage Your Transact-SQL Scripts?
Whether it is Transact-SQL for applications you are developing, or just for routine administrative tasks, managing Transact-SQL has never been...
2011-08-01
833 reads
SQL Server “Denali”: Project Apollo
Project Apollo is a new feature in CTP3 of SQL Server Denali that enables a new columnstore index that offers...
2011-08-01
1,685 reads
Notes from SQLSaturday #81
I started by journey to Birmingham by leaving work at 1130 and getting to the airport in time to have...
2011-08-01
309 reads
We Have Another New Contributor…
I’d like to introduce you all to my friend Ian Treasure who has kindly volunteered to write some posts and...
2011-08-01
617 reads
Telecommuting - Hype or Happening? - Making the Case to your Higher-ups
We've seen the argument before, that working from home, actually increases productivity. This is one of the major cases in...
2011-08-01
2,560 reads
PowerPivot – Creating Hierarchies
Hierarchies are one of the long awaited features that will now be available in the latest version of PowerPivot. Hierarchies...
2011-07-31
4,850 reads
Spoke at #sqlsat81
I presented two sessions this weekend in Birmingham AL at SQL Saturday 81. I was in the first slot of...
2011-07-31
1,456 reads
The Good, the Bad and the Ugly SQL Cursor types
T-SQL cursors are generally bad approach and are often misused. In today’s world of correlated subqueries, CTE’s, recursive CTE’s, ranking...
2011-07-30
1,963 reads
Lookup functions in SSRS 2008 R2 - III
Introduction
This is the final post to discuss the last Lookup function Multilookup(). The other two – Lookup() and LookupSet() have already...
2011-07-30
11,368 reads
Blogs
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...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
My PASS Summit West 2026
Comments posted to this topic are about the item My PASS Summit West 2026
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers