PASS Call for Nominations
The call for nominations for the PASS Board of Directors is open until Sep 3rd and I want to reiterate...
2009-08-26
1,298 reads
Building a Better Blog - Next week during the 24 hours of PASS
I've got a new presentation on blogging slated for next week during the 24 hours of PASS. The event is...
2009-08-26
828 reads
Corruption in sys.dependencies
The second type of corruption I want to look at is that of missing references in sys.sql_dependencies. This typically appears...
2009-08-26
461 reads
Error Importing DTS package in SQL Server 2008
Opening DTS packages on a 2008 SQL Server requires several steps to be able to view the packages in a...
2009-08-26
1,594 reads
Writing Technical Articles - A Few Simple Tips
A few simple tips that I've learned over the years. Keep these in mind as you write your next article.
That...
2009-08-26
1,044 reads
Application and Multi-Server Management With SQL Server 2008 R2
Microsoft has published a good whitepaper that explains the new functionality in SQL Server 2008 R2 that will allow you...
2009-08-26
612 reads
Microsoft SQL Server 2008 Books Online (July 2009)
Microsoft has released the July 2009 standalone version of Books Online (BOL) for SQL Server 2008, which you can get...
2009-08-26
683 reads
PASS Connector Editorial for August 26, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-08-25
555 reads
Continuous Integration in a Development Environment using Red Gate Backup and SQL Compare
My co-worker and fellow DBA, Leigh Freijo has a blog entry about a Powershell script he created to re-integrate QA/Development database changes...
2009-08-25
1,115 reads
Database Mirroring Across Domains, Using Certificates.....
Database Mirroring w/o a Domain, Can be a Pain - but it can be done......
Have you ever had to setup mirroring...
2009-08-25
6,550 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