Off-Hours Work: A Guide For Managers
If you work in software development or IT long enough eventually you're going to find yourself in a situation where...
2009-10-02
2,012 reads
Kendal Van Dyke
Off-Hours Work: A Guide For Managers
If you work in software development or IT long enough eventually you're going to find yourself in a situation where...
2009-09-29
1,860 reads
SSMS "Connect to Database Engine" Prompt Behavior When Dragging And Dropping Files
A minor annoyance of mine for a long time has been how SSMS will sometimes prompt you to connect to...
2009-09-17
391 reads
Networking While On Vacation
There's been a lot of attention given to professional networking (e.g. Andy Warren's blog posts) recently and if you recall...
2009-09-15
609 reads
How To Get Table Row Counts Quickly And Painlessley
Just a quick note to call out that I've had an article posted on SQLServerCentral that shows how to retrieve...
2009-09-02
456 reads
Why Does Code Outlining In SSMS Only Work When Connected To SQL 2008?
Code Outlining has been part of Visual Studio since VS.NET 2002. If you're not familiar with it, code outlining is...
2009-08-04
475 reads
Things You Need To Know If You Use DFS Replication
In addition to being a SQL DBA I'm also a network administrator, or at least I pretend to be. This...
2009-07-31
2,980 reads
SQL Logins For Windows Domain Accounts Limited To Pre-Windows 2000 Format
You may have noticed that when you create a login on a SQL server that's mapped to a Windows domain...
2009-07-28
661 reads
Interested In *Free* SQL Training? Attend A SQL Saturday Near You!
Can't make the PASS summit? Or maybe you're going but looking for something whet your appetite between now and November....
2009-07-27
767 reads
So You Want To Meet People At PASS…But What Do You Say?
Going to the PASS Summit this November? Let's fast forward and pretend it's November 2. You've made it to Seattle...
2009-07-23
524 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