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 ?
The post What is an Easy Way...
2010-07-07
7 reads
Blog Posts
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,307 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
632 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
953 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
304 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
341 reads
Q2 Goal Review
I have a monthly reminder, which is currently making me feel guilty. It’s there to tell me to review my...
2010-07-06
381 reads
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Alamat kontak resmi BCA KCP Blok M Tlp/Wa:0817-866-887
WhatsApp:0817866887 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Alamat kontak resmi BCA KCP Benhil Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Bendungan Hilir No. 44/I, RT.8/RW.1, Bend. Hilir, Kecamatan Tanah Abang, Kota Jakarta...
Alamat kontak resmi BCA KCU SCBD Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers