2014 Year In Review
As is our want, we must look back over the past year to see what happened. While I normally focus...
2015-01-11
617 reads
DataOnWheels
Create your own SQL Tools with PowerShell and Windows Forms
Steve:
Check out a new blogger who is sharing secrets of the DBA world. In his first post, James shows us...
2014-12-09 (first published: 2014-12-03)
7,235 reads
Power Testing ETL with Power BI – Creating the Tests with Power Pivot
This is the second deep dive into Power Testing ETL with Power BI. At this point, we have created the...
2014-11-13
1,166 reads
Power Testing ETL with Power BI – Shaping The Data with Power Query and Power Pivot
This blog post digs into the details of shaping the data with Power Query and Power Pivot in order to...
2014-11-19 (first published: 2014-11-12)
8,108 reads
Power Testing ETL with Power BI – The Process
This is a short blog series on using Power BI tools to support testing ETL processes. I have presented on...
2014-11-11
1,282 reads
Creating a SharePoint Server Farm on Azure from the Gallery
As many of you know creating a SharePoint farm for testing can be a daunting task. I volunteered to help...
2014-10-16
786 reads
Lync 2013 Video Issues on Windows 8
Part of the reason I have a blog is to document issues and resolutions I do not want to forget....
2014-10-15
539 reads
Temporary Post Used For Theme Detection (919ceef8-1031-4873-93f5-7a833585812f – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e5bad5db-3b7d-4641-ba91-15ab900e8f70 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2014-10-09
417 reads
The Only Constant Is Change
In March of this year, I celebrated 10 years at Magenic. I blogged about it and called out values and...
2014-10-05
478 reads
T-SQL Window Functions – Part 4: Analytic Functions
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-07-24 (first published: 2014-07-17)
11,149 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers