It’s that time of year…..Exceptional DBA Awards 2012
Being a 2011 finalist I felt I should try and rally all those who truly are exceptional to get their...
2012-06-25
794 reads
Killing me softly with Service Broker…
A few days ago, I found a very interesting behavior regarding Service Broker on a
customer system. The main thing is...
2012-06-25
3,468 reads
And the results are in…..SQL Server 2012 beta exams
Well after being a bit late in trying to book the beta exams I managed to get three of the...
2012-06-25
962 reads
Unable to activate a Windows 2003 VM on Hyper-V behind a proxy
Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I...
2012-06-25
2,743 reads
How to use a multidimensional cube with Power View
The requirements for Power View state that it can only use tabular models as data sources. So if you want to...
2012-06-25
2,326 reads
Speaking at PASS Summit 2012
It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held...
2012-06-25
962 reads
Almost an MCSA
I took four beta tests earlier this year for SQL Server 2012. I had debated writing another book, and I’ve...
2012-06-25
1,297 reads
Goals – The end of one year, start of another
Just about a year ago, I talked about the importance of setting goals for yourself, both personally and professionally, making...
2012-06-25
1,036 reads
Does Encryption Affect Seeing Statements in Deadlock Graphs?
Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:
CREATE PROCEDURE DL2e
...
2012-07-03 (first published: 2012-06-25)
2,278 reads
Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times...
2012-06-25
21 reads
Blogs
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...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
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