Bug? Can’t Pass TVP to SQL Function Twice
I run into a bug recently with SQL Server 2012. I believe this exists in SQL Server 2008 as well....
2012-06-20
1,106 reads
Blog Posts
Contracting – Your best clients are your current clients…
and your old clients too.
Before I started my contracting business five years ago I realised the importance of selling and...
2012-06-20
840 reads
Corrupt Model database
An interesting case arose at work the other day. SAN issues had caused SQL Server to shutdown and it was...
2012-06-20
763 reads
Get Your Ass to PASS!
This year there are to be no excuses, and I mean it.
You know what I’m talking about. There’s always some...
2012-06-20
829 reads
My journey finally ends at the SQLPASS 2012 Summit
Yesterday SQLPASS revealed the sessions that were selected for the upcoming SQLPASS
summit in Seattle from November 6 – 9. I'm very...
2012-06-20
801 reads
SQL Server 2008 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-20 (first published: 2012-06-11)
3,073 reads
SQL Server 2012 CU2 – Have a little fun (#AppliedSQL)
SQL Server 2012 Cumulative Update (CU) 2 is out! If you’re like Me-from-10-years-ago, you couldn’t care less!
But there are actually...
2012-06-20
1,294 reads
SQLBits X videos online
All the videos for this popular conference are online or will be soon (69 of them). Take a look at the...
2012-06-20
1,132 reads
Vacation Notes
I wrote this over the course of 10 days, so it’s a bit rambling, but maybe you’ll find a good...
2012-06-20
802 reads
Enumerating Index Fragmentation with Powershell and SMO
I wish I could say that this was a simple task, but as I dove into SMO and some of...
2012-06-19
2,753 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers