Using MDX to work with the File System
There are sometimes some cool things you can do with a language that is not really it’s primary focus. T-SQL...
2010-02-20
401 reads
Important SSAS Dimension Properties
When configuring a SSAS Dimension, there are many important properties to pay attention to. This blog will give you a...
2010-02-20
450 reads
Why don’t lookup columns appear in no match output?
I often get asked when we are discussing loading dimension tables in SSIS, why the key columns from the table...
2010-02-20
356 reads
Improve your SSMS Interaction
Ever wanted to liven up your life some with some color in your day to day DBA duties. There are...
2010-02-20
252 reads
LastPeriods and PeriodstoDate
There are several ways for calculating “To-Date” calculations the longer way. These normally include a more granular level of control...
2010-02-20
605 reads
MDX Time Calculation Shortcuts
There are lots of ways to calculate time comparisons in MDX, but there are some great shortcuts. The functions WTD,...
2010-02-20
292 reads
Connecting to DB2 AS\400 with SSIS
We have a lot of projects in our organizations that require us to work with database systems other than SQL...
2010-02-20
4,513 reads
Carrier Pigeon Beat Local Telcom
It’s not often that we find stories that make us laugh out loud, unless they have to do with situations...
2010-02-20
247 reads
Automate Back Slashes in Your File Path Expressions in SSIS
One of the most aggravating things when work with the SSIS expression language is when you have to combine file...
2010-02-20
2,330 reads
Keynote Speaker!
Actually it’s not as big a deal as it sounds, but still a little exciting. I was asked to be...
2010-02-20
685 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
T-SQL in SQL Server 2025: REGEXP_LIKE
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers