Using PowerPivot to Monitor Reporting Services
PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you...
2012-06-12
1,535 reads
Blog Posts
Creating a Filetable
How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable...
2012-06-11 (first published: 2012-06-05)
5,438 reads
ORM Tools
ORM tools. They’re great. They’re evil.
In the right hands, used the proper way, they can be a very powerful, very...
2012-06-11
3,494 reads
Performance reviews – Self-evaluations
My annual performance review at work is coming up shortly, and this year they’ve decided to do things a bit...
2012-06-11
3,073 reads
RANKING Function in plain SQL
Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using RANK() function.DECLARE @StudentScore TABLE(StudentName VARCHAR(1),StudentScore INT)INSERT @StudentScore VALUES ('A',85),...
2012-06-11
64 reads
RANKING Function in plain SQL
Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using...
2012-06-11
321 reads
Slipping in a Break
I know some people like long holidays, but I tend to prefer short ones. Today is one of those breaks...
2012-06-11
861 reads
Sorry, Mikko, the box was already open
In a blog post F-Secure's Chief Research Officer, Mikko Hypponen (blog | twitter), indicated that with the US participating in cyberattacks...
2012-06-11 (first published: 2012-06-05)
2,397 reads
SQL Server 2012 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-11
1,721 reads
Data Quality; the road to Accurate Reporting
I am sure you have heard of the term; garbage in garbage out. This maxim is even more true when...
2012-06-10
924 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