Working With Compliance
Most larger and all publicly held companies will have some sort of compliance team – often a few varieties, ranging from...
2012-08-09
583 reads
How to prevent ‘Select *’ : The elegant way
UPDATE 2012-09-12 For my latest adventures with TSQL Parsers please see this post.
I’ve been doing a lot of work with the...
2012-08-09
1,996 reads
August 2012 – Monthly SQL Server Checklist
Summer is beginning to wrap up for those of us in the northern hemisphere and were finally to August. Maybe...
2012-08-09
1,156 reads
Excluding Schemas in SQL Compare
I saw this question posted the other day and thought it was a great idea.
I haven’t been a big...
2012-08-09
2,455 reads
Service pack Native Client, SQL XML4 and VSSWriter failed
One of my client accidentally executed a 32 bit service pack on a 64 bit SQL Server, the service Pack...
2012-08-09
1,562 reads
Forcing network protocol to connect SQL server
Whenever there is a network issue or a SQL server browser issue we might need to connect SQL server in different...
2012-08-09
1,254 reads
SQLSaturday 159 - KC Can Sure Throw a SQL Saturday!
This past weekend was SQLSaturday159 - Kansas City. I drove down with my wife and our sons (2 years old and...
2012-08-09
960 reads
Using a Dedicated Administrator Connection (DAC) on SQL Server
Dedicated Administrator Connection (DAC) allows administrators emergency access to SQL Server via SQL Server Management Studio (SSMS) or via command...
2012-08-09
1,512 reads
Don't Use Passwords That Can Be Social-Engineered
A Facebook thread by one of my friends brought this one to mind. He was asking about what the current...
2012-08-09
1,956 reads
Lenovo’s Cancellation Policy is not consumer-friendly
I recently placed an order for a ThinkPad W530 from Lenovo. One day before the estimated shipping date, I noticed...
2012-08-09
3,398 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