2014 PASS Summit 2014 Board Q&A Notes
As has occurred in previous years at the PASS Summit the PASS Board of Directors held an open Q&A session...
2014-11-17
721 reads
Kendal Van Dyke
PASS Chapter Leaders - Remember To Talk About Elections With Your Chapters!
Last week before our monthly MagicPASS meeting I went through my usual routine of grabbing the PASS chapter deck and...
2014-09-23
539 reads
Presenting At OPASS August 2014 Meeting On 8/28
Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User...
2014-08-27
1,207 reads
Thoughts On The 2014 PASS Summit Selections
The session lineup for the 2014 PASS Summit was announced today and I'm honored to be selected as a presenter....
2014-06-25
1,352 reads
I'm A Candidate For The 2014 PASS Nomination Committee
The 2014 PASS election cycle begins today when voting opens for the Nomination Committee (NomCom) and I'm one of eleven...
2014-06-03
1,132 reads
Using sys.objects When Scripting Permissions? You're Missing Something!
I suspect most DBAs have a script in their T-SQL toolbelt which scripts out database permissions for a specific user...
2014-02-04
1,123 reads
How To Get The TableDiff Utility
Tablediff is a command line utility that comes with SQL Server to compare the data and schema in two tables...
2013-12-05
2,591 reads
Windows 8.1 Upgrade Deletes VirtualBox Host-Only Network Adapter
Windows 8.1 was released to the Windows Store last week and aside from having to download the same 3.9 GB...
2013-10-22
1,224 reads
SQL Power Doc Update - Version 1.0.2.1
I'm at the 2013 PASS Summit in Charlotte, NC, this week, and presented a session about documenting your databases using...
2013-10-17
1,299 reads
What Does The PASS Community Mean To You?
In less than 72 hours I'll be in Charlotte with over 3,000 of my closest SQL Server friends for the...
2013-10-11
721 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