SSRS SharePoint Integrated Mode – Report Server URL
This is a short, but hopefully sweet post for someone, whom, like me, might have had to end up spending...
2014-12-03
2,696 reads
Blog Posts
Clustered Columnstore Indexes – part 45 (“Multi-Dimensional Clustering”)
Continuation from the previous 44 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
I have blogged a couple times (part 29 – “Data Loading for Better...
2014-12-02
362 reads
Exam Prep 70-463: Just the facts, ma’am
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-02 (first published: 2014-11-24)
7,980 reads
Get Information on Current Traces Running
This is just a quick informational query to save as a snippet to get some quick information on running traces,...
2014-12-02
939 reads
More Notes From The PASSWatch Project And Thoughts on Transparency
It’s been just over two months since I wrote the first post for PASSWatch. I’m trying hard to keep PASSWatch...
2014-12-02
548 reads
Preparing a Technical Session Part 1: Picking a Topic
So you’ve decided or perhaps were told to do a technical presentation. If this is something that’s new for you...
2014-12-02
825 reads
Review: Ghost of My Father
I finished reading Ghost of My Father by Scott Berkun over the holiday weekend. It’s an intense read about the...
2014-12-02
539 reads
SQL Server 20082008 R22012 || Remove Node from failover cluster
Steps to remove node from failover cluster for SQL Server 2008 onwards :-
Note :-
a) Same process will be used to...
2014-12-02
1,107 reads
Capturing DB Usage stats – sp_spaceused simulation using DMV’s.
SP_SPACEUSED
sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by...
2014-12-01 (first published: 2014-11-24)
6,825 reads
Creating Placeholder Files
I recently wrote about placeholders for disk space. While you can use any file, like large images, video, etc., I’ve...
2014-12-01
1,003 reads
Blogs
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers