Categories
Top Posts & Pages
- Microsoft Visual Studio is unable to load this document
- Rolling period with shell dimension SSAS
- Using a Custom Assembly to search an Analysis Services dimension
- How to get SSAS to return the correct currency format.
- So you think you need Enterprise Edition, huh?
- Why I need to go to SQLskills Immersion Training
- Subtle differences in Teradata and SQL Server
- SSIS Script Task and Proxy Auto Configuration (PAC) Script
- Restored database konflikter med et opdaterings deploy fra VS DB Ed.
- Telerik inline edit mode needs dummy row when using ObjectInstanceDataSource
Recent Comments
- TSQL Tuesday #63 – How do you manage security: Rollup - SQL Server - SQL Server - Toad World on TSQL Tuesday #63 – How do you manage security
- TSQL Tuesday #63 – How do you manage security: Rollup - SQL Server - SQL Server - Toad World on TSQL Tuesday #63 – How do you manage security
- Donald Parish on Run your cubes in Warp Speed – Really Really Fast!
- Kenneth M. Nielsen (@DoktorKermit) on How to Process Multiple Dimensions via BIDS and SSMS
- Jens Vestergaard on Teradata based Data Source Views in Analysis Services
Tags
.Net 3rd. ed. AMO Analysis Services BI Business Intelligence Bønner C# Certificering Coffee D&D Espresso FAIL Fejl Humor Kværn MCP MDX MSConnect NFL Personal Powershell Presenting Roleplay Security SQL SQL2008 SQL2012 SQLBits SQLBits X SQLPASS SQL Server SQLServer SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL Teradata vandkøling VS2008 VS2010LinkedIn
I am happy to connect on LinkedIn:
Tag Archives: SQL
Subtle differences in Teradata and SQL Server
Imagine the hair pulling experience, when you port knowledge from one RDBMS to another, and it just doesn’t work. I had one such experience today, when I had to generate a certain filter for at Query. I wanted to combine … Continue reading
How to do a String REPLACE in Teradata
String Replace does not exist but can be accomplished with the following procedure: INSTALL REQUIREMENTS:– 1) GRANT ALL ON “%TDUser%” TO “%TDUser%” WITH GRANT OPTION 2) C++ compiler, if running the TD Demo How to replace “old” with “new” so … Continue reading
Restored database konflikter med et opdaterings deploy fra VS DB Ed.
Jeg løb ind i et lidt filøjerligt issue her til aftens da jeg skulle lave et opdateringsdeploy fra VS ud til min dev instans af en database. Jeg havde modtaget en backup fra en kollega, der indeholdt en masse testdata, … Continue reading
Kør SQL statement mod alle databaser
m4s0n501 Der findes en udokumenteret system stored procedure fra Microsoft, der gør det muligt at eksekvere en T-SQL sætning mod alle databaser. Uden at skulle sætte en cursor op mod sysdatabases tabellen. Syntax: EXEC sp_MSforeachdb @command (hvor @command er en … Continue reading
” == 0
Opdagede i dag en meget underlig måde at programmere på. Under en portering fra SQL Server 2000 til SQL Server 2005 stødte jeg på en fejlbesked i en stored procedure. Fejlbeskeden lød meget mærkelig og det viste sig også at det ikke … Continue reading