How Can I Tell if a Windows Login has Rights to My Server?
Introduction
Here is another utility stored procedure that I use. This stored procedure will tell you how a user has access...
2010-04-12
328 reads
Reporting Services 2008 R2 Data Bars
Last week I wrote a blog explaining how the new tool inside Reporting Services 2008 R2 called Indicator will be...
2010-04-12
2,093 reads
Visual Studio 2010 Download Interruptus
Microsoft has made the RTM bits for the various versions and components of Visual Studio 2010 available on MSDN Subscribers...
2010-04-12
342 reads
Seacoast SQL Users Group
Tomorrow is the Seacost SQL Server User’s Group inaugural meeting. I’ll be presenting a session called “Understanding Execution Plans.” It’s...
2010-04-12
742 reads
New SSDs
I ordered a few recently from NewEgg. One for a desktop, one for a laptop. We’ll see how they do,...
2010-04-12
414 reads
SQLSaturday PowerPoint Template – Looking for Suggestions
Sanj Gandham from PASS HQ set up a basic template for SQLSaturday presentations, you can download it from here. Our...
2010-04-12
741 reads
PASS BI Virtual Chapter – Thursday’s Session Postponed
The PASS BI Virtual Chapter’s scheduled session for this Thursday, April 15th, will have to be postponed until a later...
2010-04-12
674 reads
Notes from the R2 Tweetup
Several weeks ago I was invited to attend a ‘tweetup’ by Microsoft on April 8th, an almost all expenses paid...
2010-04-12
443 reads
Book Review: Crush It!
Not long ago, I read a review of Gary Vaynerchuk’s book, Crush It! The reviewer, Michael Hyatt (Twitter | Blog), liked...
2010-04-12
491 reads
db_executor role
This process might not be granular enough for some but there is a nice simple way of creating a role...
2010-04-12
36,662 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
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