Back with a new focus
First let me say wow can’t believe that it has been almost 3 years since I have blogged. The last few years my career have been focused on transitioning...
2019-05-19
17 reads
Another SQL Geek
SQL 2016 SSIS new feature AutoAdjustBufferSize
If you have not already seen in the What’s New in Integration Services list there is a new property for...
2016-07-21
1,744 reads
Use PowerShell to automate your Azure DB creation
Why create your databases manually if you don’t have to? If there is one thing that I hate to do...
2016-07-20
845 reads
Update to Date and Time Dimensions
Wanted to just post my latest versions of my Date and Time Dimension scripts. It has been a couple years...
2016-05-09
393 reads
Power BI Embedded is here
The announcement of Power BI Embedded came last week during Microsoft’s Build Conference and now enables software vendors or anyone...
2016-04-05
570 reads
SQL Developer Edition is now free!!!
Announced on 3/31/2016 SQL Server Developer Edition is now free and available as a download to all who have signed...
2016-04-01
817 reads
Power BI and Google Analytics
One of the more underused features of Power BI is the Google Analytics data source. Working closely with marketers and...
2016-01-20
1,304 reads
Power BI Export Data
If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is...
2016-01-22 (first published: 2016-01-13)
2,252 reads
Viewpoints from CES 2016
While I never really enjoy a cross country flight back home my feet are very happy that I am finally...
2016-01-11
328 reads
Be an Expert not an Ehhpert!!!
As we embark on a new year I decided to take a look back at my career within I.T. trying...
2016-01-12 (first published: 2016-01-06)
2,239 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