What is an Easy Way to Return Results from a CLR Stored Procedure?
Introduction
What is an Easy Way to Return Results from a CLR Stored Procedure? The question sounds simple enough but yet...
2010-07-07
999 reads
Blog Posts
What is an Easy Way to Return Results from a CLR Stored Procedure?
This post describes a helper class that I came up with to handle returning values from a CLR stored procedure. Continue reading ?
2010-07-07
199 reads
WHERE to begin
Many people, once they start getting comfortable writing SQL, begin asking the same questions. One such common question is “Does...
2010-07-07
1,304 reads
Why Work on a SQL Saturday?
I was having a long call with Andy Warren (blog | Twitter), fellow founder of SQLServerCentral and SQL Saturday. We were...
2010-07-07
630 reads
Before You Begin Auditing...
There is a fine line between auditing and attacking. The line actually is one built based on authorization. Same tools,...
2010-07-06
951 reads
MDX Puzzle #2 Solution
MDX Puzzle #2 Solution
Download Script
This puzzle was a little more challenging than the first, but it was definitely fun and...
2010-07-06
1,059 reads
MDX Puzzle #3
The next puzzle comes from a BIDN.com forum post. Here are the requirements:
Columns: Internet Order Quantity and Percentage Of Total...
2010-07-06
519 reads
Mix & Match – Day 2
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-06
438 reads
MS Access Annoyance: Yes, Save the Password, Again
Here’s another quirk that has been there forever. Open up the linked table UI and select a handful of tables,...
2010-07-06
302 reads
Newest Pragmatic Works’ Team Book on Amazon
Check out our latest book on Amazon. It’s not for sales yet, but just seeing the title up there is...
2010-07-06
338 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers