fsugeiger.blogspot.com
fsugeiger: April 2012
http://fsugeiger.blogspot.com/2012_04_01_archive.html
Architecture and implementation of advanced BI solutions using MSSQL, SSIS, SSAS, SSRS, PerformancePointServer, WSS, MOSS and TSQL. Wednesday, April 4, 2012. SQL Server Index and Statistics Maintenance. Http:/ ola.hallengren.com/sql-server-index-and-statistics-maintenance.html. This script creates all the objects and jobs that you need. You can also download. The objects as separate scripts. The SQL Server Maintenance Solution is free. Select databases. The keywords SYSTEM DATABASES, USER DATABASES, ...
fsugeiger.blogspot.com
fsugeiger: DimDate Dimension
http://fsugeiger.blogspot.com/2013/05/dimdate-dimension.html
Architecture and implementation of advanced BI solutions using MSSQL, SSIS, SSAS, SSRS, PerformancePointServer, WSS, MOSS and TSQL. Thursday, May 23, 2013. If you are looking for a DimDate script for your EDW, this one may work for you. IF OBJECT ID('DimDate') IS NOT NULL. CREATE TABLE [dbo].[DimDate]. DateKey] [int] NOT NULL ,. CalendarDate] [smalldatetime] NULL ,. CalendarWeek] [varchar](8) NULL ,. CalendarWeekNumber INT ,. CalendarMonth] [varchar](8) NULL ,. CalendarMonthName] [varchar](30) NULL ,.
fsugeiger.blogspot.com
fsugeiger: October 2012
http://fsugeiger.blogspot.com/2012_10_01_archive.html
Architecture and implementation of advanced BI solutions using MSSQL, SSIS, SSAS, SSRS, PerformancePointServer, WSS, MOSS and TSQL. Tuesday, October 23, 2012. I am working a list of my favorite free WPF controls. Http:/ navigationpane.codeplex.com/. Check back for more updates. Posted by Bryan K Geiger. Moving to Microsoft Visual Studio 2010. Programming Windows 8 Apps 2nd Preview. Programming Windows Phone 7. Programming Windows Phone 7 (Special Excerpt 2). Microsoft Office 2010 First Look. Technical re...
fsugeiger.blogspot.com
fsugeiger: AWS RedShift/S3 Data Warehouse Solution
http://fsugeiger.blogspot.com/2014/02/aws-redshifts3-data-warehouse-solution.html
Architecture and implementation of advanced BI solutions using MSSQL, SSIS, SSAS, SSRS, PerformancePointServer, WSS, MOSS and TSQL. Thursday, February 13, 2014. AWS RedShift/S3 Data Warehouse Solution. Creating an account with amazon, most of you already have one you just need to sign into the AWS Console. You need to setup a drop point in S3. This allows you to drop bulk operation files into the online store for batch operations over to RedShift. List of PostgreSql data types. Found the AWS SDK and they...
fsugeiger.blogspot.com
fsugeiger: November 2012
http://fsugeiger.blogspot.com/2012_11_01_archive.html
Architecture and implementation of advanced BI solutions using MSSQL, SSIS, SSAS, SSRS, PerformancePointServer, WSS, MOSS and TSQL. Thursday, November 1, 2012. C# FileSearch and Parse. I was in need of a simple recursive key word search in a file structure. This console app helped me search for a key word in CiscoReports .srd files. System.Collections.Generic;. Counter = 0;. Read the file and display it line by line. Line = file.ReadLine()! Posted by Bryan K Geiger. MDX Guide for T-SQL Users. Before we m...
fsugeiger.blogspot.com
fsugeiger: June 2013
http://fsugeiger.blogspot.com/2013_06_01_archive.html
Architecture and implementation of advanced BI solutions using MSSQL, SSIS, SSAS, SSRS, PerformancePointServer, WSS, MOSS and TSQL. Thursday, June 20, 2013. PL/SQL Purge Recycle Bin. Recently came across several objects that needed to be purged from our Oracle DW. It seems after a drop table the object still remains in the RecycleBin. Example to query for the objects:. Select 'purge table "' object name '" ;' , original name, type, can undrop as "UND", can purge as "PUR", droptime from recyclebin. Date][...
fsugeiger.blogspot.com
fsugeiger: March 2012
http://fsugeiger.blogspot.com/2012_03_01_archive.html
Architecture and implementation of advanced BI solutions using MSSQL, SSIS, SSAS, SSRS, PerformancePointServer, WSS, MOSS and TSQL. Wednesday, March 28, 2012. PowerPivot for SharePoint DataSource Issues. Service Account for PowerPivot permissions on the Analysis instance. Pull up SSMS and servername powerpivot instance. Take a look at the properties of the instance. Make sure your service account has admin permissions. This is needed to be able to create new "sandbox" dynamic cubes. Http:/ powerpivotgeek...
fsugeiger.blogspot.com
fsugeiger: invoke-expression for sqlcmd from powershell
http://fsugeiger.blogspot.com/2014/01/invoke-expression-for-sqlcmd-from.html
Architecture and implementation of advanced BI solutions using MSSQL, SSIS, SSAS, SSRS, PerformancePointServer, WSS, MOSS and TSQL. Monday, January 6, 2014. Invoke-expression for sqlcmd from powershell. Having some issues running a sqlcmd via powershell on a sql instance with custom ports. Try the following command. Sqlcmd -S USHXXDBWD002 I0007DS01,4070 -E -Q "select getdate()". Query = "select getdate()". Cmd = "SQLCMD -S `"USHGNDBWD002 I0007DS01,4070`" -h-1 -Q `"$query`". Write-host "command is: $cmd".
fsugeiger.blogspot.com
fsugeiger: Value of a Partitioned Table
http://fsugeiger.blogspot.com/2013/05/value-of-partitioned-table.html
Architecture and implementation of advanced BI solutions using MSSQL, SSIS, SSAS, SSRS, PerformancePointServer, WSS, MOSS and TSQL. Wednesday, May 22, 2013. Value of a Partitioned Table. IF OBJECT ID('dbo.TestPartitionTable') IS NOT NULL. DROP TABLE dbo.TestPartitionTable. CREATE TABLE [dbo].[TestPartitionTable]. Pkcol] [int] NOT NULL ,. Datacol1] [int] NULL ,. Datacol2] [int] NULL ,. Datacol3] [varchar](50) NULL ,. SELECT @val = 1. WHILE @val 1000001 - million rows. INSERT INTO dbo.TestPartitionTable.
fsugeiger.blogspot.com
fsugeiger: May 2013
http://fsugeiger.blogspot.com/2013_05_01_archive.html
Architecture and implementation of advanced BI solutions using MSSQL, SSIS, SSAS, SSRS, PerformancePointServer, WSS, MOSS and TSQL. Thursday, May 23, 2013. If you are looking for a DimDate script for your EDW, this one may work for you. IF OBJECT ID('DimDate') IS NOT NULL. CREATE TABLE [dbo].[DimDate]. DateKey] [int] NOT NULL ,. CalendarDate] [smalldatetime] NULL ,. CalendarWeek] [varchar](8) NULL ,. CalendarWeekNumber INT ,. CalendarMonth] [varchar](8) NULL ,. CalendarMonthName] [varchar](30) NULL ,.