Reasons not to upgrade to SQL Server 2012
As exciting as SQL Server 2012 is, with its multitude of new features, it’s not always possible to upgrade right...
2012-11-29
2,847 reads
Lost in Translation – Deprecated System Tables – sysremotelogins
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-29
1,854 reads
Interview questions for SQL Server Performance Tuning Specialists
If you are the regular reader of my blog posts, you could easily judge in which topics i spend much time these days.
I have...
2012-11-29
10,147 reads
HDInsight: Trying again
And I thought this would be so easy.
Latest attempt. I just did an uninstall of HDInsight. Then I found all...
2012-11-29
1,932 reads
Tables without a Clustered Index
Yesterday while adding some new logic to an existing process I noticed an unacceptable level of performance degradation with the...
2012-11-29
1,540 reads
Chicago: The Travels of a SQL Server Consultant
As regular readers of my blog will now as part of role as a SQL Server consultant and SQL Server...
2012-11-29
2,125 reads
Plan cache bloat by SQLAgent (Prior to SQL2008) !
Recently I was checking the plan cache utilization with the help of the below query which I normally use for...
2012-12-05 (first published: 2012-11-29)
2,473 reads
NY SQL Server User Group Meeting - Bill Pearson
Thursday, November 29, 2012, brings us the November
meeting of the NY SQL
Server User Group, with BI expert, SQL MVP and...
2012-11-28
1,825 reads
Significant Achievements
As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s...
2012-11-28
738 reads
HDInsight: First Pass
I installed HDInsight with no errors. The install is so brain-dead, I couldn’t see how there could be errors. But,...
2012-11-28
895 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
Alamat Kantor BCA KCU Galaxy Tlp:(08218154374)
WA CS 628218154374 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya,...
Alamat Kantor BCA KCU Malang Tlp:(08217555651)
WA CS 628217555651 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa...
Alamat Kantor BCA KCU Rungkut Tlp:(0817825533)
WA CS 628217825533 Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers