SQL Server 2008: Table-valued parameters
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass...
2009-11-24
820 reads
Blog Posts
The most optimal join type
What’s the best join type for a query? Should we aspire to seeing nested loop joins in all our queries?...
2009-11-24
982 reads
Check out my new blog location
My new blog has been centralized at http://www.bidevelopernetwork.com/blogs/AdamJorgensen/. Check it out for all my new updated content.
2009-11-23
529 reads
Deploying Reports on Windows 7
Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate....
2009-11-23
1,115 reads
Great Post from Jamie Thompson
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting...
2009-11-23
660 reads
MDX and DMX Templates
One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA....
2009-11-23
594 reads
New 2008 Microsoft BI Certifications Reviewed
I am not about to get into a theoretical discussion of whether certifications will benefit you in your career. I...
2009-11-23
456 reads
Opening Doors – Part 1
As a speaker, blogger, even a DBA at work it’s hard to know when you’re having a positive impact on...
2009-11-23
722 reads
Opening Doors – Part 2
Yesterday in Part 1 I wrote about opening doors – the art of showing others what is possible within the context...
2009-11-23
535 reads
Raising a Technology Savvy Daughter
I was introduced to electronics at a very young age. I think I was three when I first started doing...
2009-11-23
711 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers