Using a Display Folder for a SSAS calculation
I was having a problem getting the display folder to work for a calculation in SSAS. Turns out, it will...
2011-09-09
1,354 reads
James Serra
- Twitter: @https://twitter.com/JamesSerra
- Website: https://www.jamesserra.com/
- LinkedIn: https://www.linkedin.com/in/JamesSerra/
Thinking about taking a contract position? Questions to ask
Over the years, I have accumulated a set of questions that I usually ask the placement firm about a contract position...
2011-09-07
1,153 reads
System Center and Visual Studio Team Foundation Server 2010
Because the relationship between application development and the IT operations teams is critical, Microsoft has released a CTP of a new...
2011-09-06
1,077 reads
Preventing projects from deploying when debugging a SSIS package
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am...
2011-09-02
1,408 reads
Receive error #13119 in toolbox instead of tools in Visual Studio 2008
A couple of times over the past few months, while in Visual Studio 2008 working on an SSIS package, I went...
2011-08-31
2,152 reads
When to use T-SQL or SSIS for ETL
When doing ETL, you have the choice of using T-SQL or SSIS. What things should you consider when deciding which...
2011-08-29
10,213 reads
Microsoft SQL Server Parallel Data Warehouse (PDW) Explained
Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server...
2011-08-26
3,752 reads
Microsoft Small Basic
This is a bit off-topic, but I wanted to mention a great tool for beginners to learn how to program. ...
2011-08-24
2,029 reads
Tracking down KPI error in PerformancePoint
On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me:
So...
2011-08-22
748 reads
Methods for populating a data warehouse
Source tables change over time. A data mart or data warehouse that is based on those tables needs to reflect these...
2011-08-19
4,930 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
How to Repair Corrupt MySQL Tables
Comments posted to this topic are about the item How to Repair Corrupt MySQL...
The Funny Dynamic SQL
Comments posted to this topic are about the item The Funny Dynamic SQL
sqlbackups through veeam not updating msdb tables
We have veeam backups happening everyday on a server where all sql databases are...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers