SQL Server “Denali”: Distributed Replay
Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from...
2011-08-10
1,587 reads
James Serra's Blog
Tools to make creating MDX much easier
For those of you who use MDX, I’m sure you share my opinion that MDX is a lot harder to...
2011-08-08
783 reads
Microsoft Certifications and MVP’s – What are they?
I take it for granted that everyone knows all about Microsoft certifications and Microsoft MVP’s. But a few years ago,...
2011-08-05
1,642 reads
How to Run Programs as a Domain User from a Non-domain Computer
As a consultant or contractor, many times the client we are at does not provide us with a laptop, so we must...
2011-08-03
1,329 reads
SQL Server “Denali”: Project Apollo
Project Apollo is a new feature in CTP3 of SQL Server Denali that enables a new columnstore index that offers...
2011-08-01
1,666 reads
Dual monitors, dual laptops, and the best way to manage them
Here is a tip that could make you much more productive: At home, I have a desktop computer with dual-monitors...
2011-07-29
2,289 reads
SQL Server does not script indexes by default
Here is a got-ya that happened to me. In SQL Server I want to generate a script of all the...
2011-07-27
9,100 reads
Setting role security in SSAS for a role-playing dimension
Here is a common got-ya. You are modifying the cube dimension security for a role-playing dimension. You make the changes and...
2011-07-25
2,027 reads
Visual Studio vNext
“vNext” is the codename Microsoft has chosen for the next version of the Visual Studio.
A big feature is improving the application lifecycle management...
2011-07-22
713 reads
SQL Server “Denali”: New Certifications
According to the post SQL Server “Denali” Experts–We Need You! that asks for your feedback on the Microsoft certifications for the...
2011-07-20
1,723 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