Fundamentals of Storage Systems – RAID, An Introduction
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-15
4,053 reads
Articles
Keep Your Purpose in Mind
A well run company will help you keep your purpose at work in mind. However many companies don't do a good job here and Steve Jones laments the lack of leadership in many companies.
2009-12-15
1,779 reads
Keep Your Purpose in Mind
A well run company will help you keep your purpose at work in mind. However many companies don't do a good job here and Steve Jones laments the lack of leadership in many companies.
2009-12-15
1,522 reads
Keep Your Purpose in Mind
A well run company will help you keep your purpose at work in mind. However many companies don't do a good job here and Steve Jones laments the lack of leadership in many companies.
2009-12-15
1,815 reads
Convert String to a Table using CTE
Explains how to convert a list of Ids passed as string and convert it to a table
2009-12-14
14,140 reads
PowerPivot
A new direction in BI, with a new flagship interface for Business Intelligence from Microsoft. Steve Jones talks a little about the back story he heard from Microsoft.
2009-12-14
1,839 reads
PowerPivot
A new direction in BI, with a new flagship interface for Business Intelligence from Microsoft. Steve Jones talks a little about the back story he heard from Microsoft.
2009-12-14
1,893 reads
PowerPivot
A new direction in BI, with a new flagship interface for Business Intelligence from Microsoft. Steve Jones talks a little about the back story he heard from Microsoft.
2009-12-14
1,649 reads
SQL Server Integration Services (SSIS) - Design Best Practices
In the previous tips (SQL Server Integration Services (SSIS) - Best Practices - Part 1, Part 2 and Part 3) of this series I briefly talked about SSIS and few of the best practices to consider while designing SSIS packages. Continuing on this path I am going to discuss some more best practices of SSIS package design, how you can use lookup transformations and what considerations you need to take, the impact of implicit type cast in SSIS, changes in SSIS 2008 internal system tables and stored procedures and finally some general guidelines.
2009-12-14
5,747 reads
TSQL Challenge 19 - Working with consolidated calculations on hierarchical structures
This challenge involves generating an organizational hierarchy and calculating the total orders created by each employee and his/her subordinates. It involves a number of challenges such as generating a resultset in the correct hierarchical form, calculating the orders created by each employee and his/her subordinates and finally calculating the total orders created by self and all the subordinates.
2009-12-14
2,432 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers