This SQL Server blog was created to share our knowledge and experience and make it available to anyone (including ourselves). You can use the search facility at the top or use the list below or use the unstructured list below (which we hope to structure soon):
Below are Top 50 most recent blog posts (some are work in progress)
SSIS Union All Transformation
Video SSIS Union All Transformation
Help Katie and Emil
Video SSIS Interview Questions
SSIS Data Conversion Transformation
Video SSIS Data Conversion Transformation
SSIS Merge Transformation
SSIS Merge Join Transformation
Video SSRS Interview Questions
Video SSIS Merge Transformation
Video SSIS Lookup Transformation
Video SSIS Merge Join Transformation
SSIS Row Count Transformation
Video SSIS OLE DB Command Transformation
Video SSIS Row Count Transformation
Video SSIS Script Component Transformation
Video Create SSRS Report
Video SSIS SCD Typ 0 Fixed Attribute
Video SSIS SCD Type 1 Changing Attribute
Video SSIS SCD Type 2 Historical Attribute Dates
Video SSIS SCD Type 2 Historical Attribute Dates
Video SSRS Concatenate Two String Fields
SSRS Video Tutorial
angelika-test
SQL Reverse Function
SQL Replace Function
ssis-ole-db-command-transformation-update-ssis-2012
SQLBits 11 2nd-4th May 2013 Nottingham
Competing with Microsoft on YouTube
ssis-scd-type-2-historical-attribute-dates
SSIS Free Webinar
SQL Basics Tutorial
SSAS Tabular vs Multidimensional
PowerView Demo Video
MicrosoftBI vs KatieAndEmil YouTube Channels Growth
Video SQL Interview Questions
Video SQL SELECT Statement Basics
Video download and install adventureworks tabular model
Video SSAS Install instance in Multidimensional Mode SQL Server 2012
video ssis oledb vs ado.net vs odbc performance test
video ssis oledb vs ado.net vs odbc performance test
sql select case when then else
Video SSIS Sequence Container
Video SSIS For Loop Container
video SSIS for each loop container - File Enumerator
Video SSIS Lookup Transformation is Case Sensitive
SSIS Data Flow Transformations Tutorial
Video Download and Install Adventure Works DW 2012
SSIS Create a Simple Package Video
Video SQL What is a collation
SQL Server Blog posts by Category
SQL Server Exam Guide Katie and Emil 70-461 Exam Guide Querying Microsoft SQL Server 2012
SQL Server Exam Guide Katie and Emil Tutorial to 70-462 Administering Microsoft SQL Server 2012 Databases
SQL Server Exam Guide Katie and Emil exam guide to 98-364 database fundamentals
SQL Server Exam Guide Katie and Emil Microsoft SQL Server Exam Guides
Interview database interview questions
Interview How to interview someone for a job
Interview sql server interview questions and answers
Interview interview questions and answers
Interview Business Intelligence interview questions
BI Tutorials SSIS Conditional split transformation
BI Tutorials SSIS lookup transformation
BI Tutorials ssis property paths
BI Tutorials ssis dynamic configuration of variables with validation
BI Tutorials ssis unit testing slowly changing dimension script
BI Tutorials ssis framework log rejects using generic approach
BI Tutorials sql and ssis deployment
BI Tutorials SSIS. SQL Server Integration Services
BI Tutorials SSIS Package
BI Tutorials Create SSIS Project
BI Tutorials How to create SSIS Package
BI Tutorials SSIS Tutorial
BI Tutorials BI Tutorials
BI Tutorials SSIS conditional split transformation
BI Tutorials ssis conditional split default output name
SQL SQL UNION ALL multiple queries
SQL SQL Unique Constraint
SQL SQL DEFAULT CONSTRAINT Syntax
SQL SQL PRIMARY KEY CONSTRAINT Syntax
SQL SQL FOREIGN KEY CONSTRAINT Syntax
SQL SQL CHECK CONSTRAINT Syntax
SQL SQL Server date and datetime error
SQL SQL CHARINDEX Function
SQL SQL Joins Examples
SQL SQL CREATE VIEW Statement
SQL sql server get identity after insert stored procedure
SQL Three reasons for normalization in database
SQL What is a database table
SQL data manipulation language
SQL data definition language
SQL SQL DROP table
SQL SQL DROP View
SQL SQL DROP Stored Procedure
SQL SQL DROP Index
SQL SQL DROP Function
SQL create database in sql server 2012
SQL SQL Server INTERSECT operator
SQL SQL TRUNCATE TABLE
SQL SQL DELETE Statement
SQL Index
SQL sql server performance tuning overview
SQL SQL CREATE TABLE
SQL Purpose of tables in a database
SQL SQL Server 2012 Data Types
SQL t-sql-group-by-having
SQL SQL Soundex
SQL sql group by month and year
SQL What is SQL
SQL sql clauses list with order of execution
SQL sql from clause
SQL sql server move database to a different drive
SQL sql server shrink log file
SQL sql server except example
SQL installing sql server 2012 step by step BI edition
SQL sql server 2012 restore database
SQL sql server 2012 backup database
SQL sql server 2012 adventureworks download and install
SQL sql server 2012 add user login with sql server authentication
SQL What is a database
SQL T-SQL Find column name in database
SQL T-SQL Check if database object exists
SQL T-SQL read registry
SQL Microsoft sql server error 18456 login failed for user
SQL sql tutorial for beginners
SQL sql select
SQL SQL alter table add column
SQL SQL show running queries
SQL SQL queries examples
SQL SQL Update
SQL SQL WHERE Clause
SQL SQL GROUP BY
SQL SQL having
SQL SQL INSERT INTO statement
SQL SQL SELECT INTO STATEMENT
SQL SQL Insert multiple rows
SQL SQL Bulk Insert
SQL SQL Identity Insert
SQL SQL Insert Date and DateTime
SQL SQL Insert if not exists
SQL T-SQL YYYYMMDD
SQL T-SQL Quarter
SQL T-SQL Output Clause
SQL T-SQL Month Name
SQL T-SQL Merge
SQL T-SQL Last Month
SQL T-SQL last day of previous month
SQL t-sql last day of month
SQL T SQL Function Number Of Days In Range For Date Range
SQL T SQL function grouping rows in query result
SQL t-sql first day of previous month
SQL t-sql first day of month
SQL t-sql day of week
SQL t-sql day of week name
SQL t-sql database name
SQL t-sql current time
SQL t-sql current date
SQL t-sql check if database exists
SQL sql age function
SQL date dimension sql
SQL sql union
SQL how to create basic table using script in SQL Server
SQL using-not-operator-t-sql
SQL how-to-use-like-wildcard-operator
SQL how-to-use-wildcard-filtering-in-t-sql
SQL how-to-use-IN-operator-in-t-sql
SQL sql server update progress
SQL sql remove special ascii characters
SQL sql group by year
SQL sql group by count
SQL sql group by date range
SQL sql convert date and time int into datetime
SQL sql check if schema exists
SQL sql age bands
SQL sql find table size
SQL sql add primary key to table with existing primary key
SQL sql server check if column exists
SQL sql server check if table exists
SQL sql check if record exists
SQL sql check if record exists before insert
SQL sql check if record exists before update
SQL SQL len function
SQL SQL LTRIM Function
SQL sql server check if temp table exists
SQL sql server wait for delay
SQL sql server clean orphaned users
SQL sql case sensitive string comparison
SQL SQL Server Compressed backup without enterprise edition
SQL sql server add linked server
SQL SQL Server Merge for SCD Type1 and Type2
SQL SQL Trigger update
SQL SQL Replace Function
SQL SQL Basics Tutorial
SSIS SSIS Union All Transformation
SSIS SSIS SCD Transformation
SSIS ssis backup
SSIS ssis truncate table
SSIS SSIS aggregate transformation
SSIS ssis log rejected rows
SSIS data profile viewer
SSIS ssis data profiling task column null ratio request
SSIS ssis if then else
SSIS SSIS Framework Get rows affected
SSRS SSRS dashboard
SSRS ssrs median function 2008 R2
SSRS ssrs concatenate two string fields using expression
SSRS ssrs action go to report
SSRS ssrs sparkline
SSRS ssrs create simple parameter
SSRS SSRS subreport
SSRS SSRS Tutorial
SSRS ssrs iif expression
SSRS ssrs table initial sorting
SSRS ssrs drop down box parameter
SSRS ssrs percentile function
SSRS SSRS Switch function
SSRS ssrs report builder 3 permissions
SSRS ssrs create reports
SSRS SSRS Reports Examples
SSRS SSRS alternate row color group
SSRS SSRS alternate row color
SSRS SSRS decimal format
SSRS SSRS export to excel formatting
SSRS SSRS gantt chart heat map
SSRS SSRS gantt chart
SSRS SSRS milestone dashboard
SSRS ssrs the feature shared dataset is not supported in this edition of reporting services
SSRS SSRS thousands separator
SSRS SSRS XML
SQL Server Blog SQL Server Denali release date 2012
SQL Server Blog MDX Order
SQL Server Blog MDX Order By Dimension
SQL Server Blog MDX Order By Date
SQL Server Blog MDX Mulitple Order
SQL Server Blog MDX Exclude Unknown
SQL Server Blog When to use pie charts
SQL Server Blog Who invented the pie chart?
SQL Server Blog deploy database project from msbuild
SQL Server Blog mstsc admin bypass connection limit
SQL Server Blog sql error codes for microsoft sql server
SQL Server Blog SQL Server 2011 codename denali
SQL Server Blog A severe error occurred on the current command
SQL Server Blog SQL Server Denali CTP 3
SQL Server Blog Junk dimension
SQL Server Blog ssas nvarchar max data type dimension set up
SQL Server Blog Shrunken dimension
SQL Server Blog Powershell dtutil
SQL Server Blog Visual Studio custom build
SQL Server Blog TFS Get latest version
SQL Server Blog SQLCMD pass parameters
SQL Server Blog SQL Server compressed backup tool
SQL Server Blog SSAS format number
SQL Server Blog windows environment variables restart explained
SQL Server Blog sqlcmd run sql script
SQL Server Blog Emil Glownia
SQL Server Blog Microsoft exam 70-463 beta review
SQL Server Blog building a data warehouse
SQL Server Blog Kimball Bus Matrix
SQL Server Blog test-page
SQL Server Blog Katie and Emil new web design
SQL Server Blog how to subscribe to rss feed
SQL Server Blog Source System Analysis
SQL Server Blog building a data warehouse wall of fame
SQL Server Blog 98-364 database administration fundamentals
SQL Server Blog Hire Katie & Emil
SQL Server Blog What Microsoft has to offer BI Platform
SQL Server Blog Scrum Agile and Kimball Data Warehousing
SQL Server Blog Microsoft BI Architecture Diagram
SQL Server Blog exam 70-463 implementing a data warehouse with microsoft sql server 2012
SQL Server Blog short-tutorial-template
SQL Server Blog how to create database project in visual studio 2010
SQL Server Blog SQL Server blog
SQL Server Blog RSS pubDate format in SQL Server
SQL Server Blog Excel 2013 with PowerView
PowerPivot Enable PowerPivot add-in
PowerView PowerView Demo Video
SSAS Tabular vs Multidimensional
ssis-ole-db-command-transformation-update-ssis-2012
SQLBits 11 2nd-4th May 2013 Nottingham
Competing with Microsoft on YouTube
ssis-scd-type-2-historical-attribute-dates
SSIS Free Webinar
Video Video SSIS Union All Transformation
Help Katie and Emil
SSIS Video SSIS Interview Questions
SSIS Data Conversion Transformation
Video Video SSIS Data Conversion Transformation
SSIS Merge Transformation
SSIS Merge Join Transformation
SSRS Video SSRS Interview Questions
Video Video SSIS Merge Transformation
Video Video SSIS Lookup Transformation
Video Video SSIS Merge Join Transformation
SSIS Row Count Transformation
Video Video SSIS OLE DB Command Transformation
Video Video SSIS Row Count Transformation
Video Video SSIS Script Component Transformation
Video Create SSRS Report
Video Video SSIS SCD Typ 0 Fixed Attribute
Video Video SSIS SCD Type 1 Changing Attribute
Video Video SSIS SCD Type 2 Historical Attribute Dates
Video Video SSIS SCD Type 2 Historical Attribute Dates
Video SSRS Concatenate Two String Fields
SSRS Video Tutorial
angelika-test
SQL Reverse Function
SQL ALTER TABLE DROP COLUMN
SQL ALTER TABLE ALTER COLUMN
TFS Scrum iterations and areas
Scrum what are story points
SQL Basic SQL Interview Questions
Building Data Warehouse Building a datawarehouse day 3 project plan
Building Data Warehouse building-a-data-warehouse-day-4-decisions-and-analysis
Building Data Warehouse building a data warehouse day 5 software and licensing
Building Data Warehouse building a data warehouse day 6 agile approach
Building Data Warehouse building a data warehouse day 0 the idea is born
Building Data Warehouse building a data warehouse day 1 requirements gathering
Building Data Warehouse building a data warehouse day 7 thank you microsoft
Building Data Warehouse building a data warehouse day 8 source system analysis
Building Data Warehouse building a data warehouse day 9 project plan update
Building Data Warehouse building a data warehouse day 10 team fight
Building Data Warehouse building a data warehouse day 11 data profiling
Building Data Warehouse building a data warehouse day 12 Katie and Emil Bus Matrix
Building Data Warehouse building a data warehouse day 13 sprint
70-462 Administering SQL Server SQL Server Policy Based Management
Building Data Warehouse Katie and Emil bus matrix spreadsheet template
70-462 Administering SQL Server SQL Server 2012 facets
70-462 Administering SQL Server SQL policy condition
how-to-use-cast-function
what-is-the-difference-between-cast-and-convert-function
70-462 Administering SQL Server create policy sql server 2012
Functions SQL Functions
SQL string functions
Functions SQL SUBSTRING function
Functions SQL LOWER Function
Telephone SQL telephone interview questions
Functions SQL UPPER Function
Telephone sql telephone interview questions for beginners Set 01
Telephone sql telephone interview questions intermediate level set 01
non empty vs nonempty in mdx
Emil and his random thoughts Emil and his random thoughts
Emil and his random thoughts 2012-09-23 sql server blog and plan
sql telephone interview questions advanced level set 01
Katie and Emil "10 Steps" guide to building a data warehouse
SSIS telephone interview questions for beginners Set 01
SQL Count Aggregate Function
how-to-use-sum-aggregate-function
Configuration SSIS Configuration
Wishlist
Configuration SSIS 2012 Parameters
Configuration SSIS 2012 Create Catalog
Configuration SSIS Configuration
enable automatic execution of integration services stored procedure at sql server startup
how-to-use-avg-function
SQL MAX Aggregate Function
SSIS 2012 Project Parameters
SQL MIN Aggregate Function
Configuration SSIS 2012 Parameter Required Column
SSIS 2012 Create OLEDB Connection
SSIS Sort Transformation
SSIS 2012 Parameterize
Video Video SSIS Aggregate Transformation
Video SSIS Video Tutorial
ssis-tutorial-transformations-template
SSIS Derived Column Transformation
Video video SSIS Conditional Split Transformation
SQL constraints list
technorati blog directory sql server blog
PowerPivot PowerPivot Tutorial
PowerPivot PowerPivot import data from SQL Server 2012
PowerPivot PowerPivot create relationships
SQL DROP PRIMARY KEY constraint
PowerPivot PowerPivot diagram view missing
PowerPivot PowerPivot hide columns and unhide
PowerPivot How to use PowerPivot in excel 2013
PowerPivot Excel 2013 Preview download and install
SQL DROP CONSTRAINT syntax
TFS Scrum Tutorial
tfs scrum create product backlog item
PowerPivot PowerPivot default measure aggregation
PowerPivot PowerPivot create calculated measure
70-462 Administering SQL Server SQL Server 2012 evaluate installation requirements
PowerView PowerView Tutorial
Video video SSIS Conditional Split Transformation Default Output Name
Video Video SSIS Conditional Split Transformation IS NOT NULL
Video Video SSIS Conditional Split Transformation Configure Error Output
Video Video SSIS Sort Transformation
SSIS Sort Transformation Pass Through
Video Video SSIS Sort Transformation Pass Through
SSIS Sort Transformation Remove Duplicates
Video Video SSIS Sort Transformation Remove Duplicates
SSIS Precedence Constraint Logical OR
SSIS Multicast Transformation
Video Video SSIS Multicast Transformation
ssis conditional split configure error output
ssis conditional split is not null
70-462 Administering SQL Server reconfigure vs reconfigure with override
70-462 Administering SQL Server transparent data encryption steps
PowerPivot excel enable PowerPivot add-in
mds-how-to-create-table-in-mds
mds-how-to-create-new-model-in-mds
mds-how-to-create-drop-down-box-in-mds
Katie and Emil helping whisper
Functions SQL Right function
Katie and Emil website ad space for sale
PowerPivot PowerPivot old menu look on windows xp
Katie and Emil - Experts in BI Solutions
Building Data Warehouse building a data warehouse day 2 bus matrix review
Functions SQL RTRIM Function
Functions SQL LEFT Function
SQL sql interview questions
SSIS SSIS interview questions and answers
SSRS SSRS Interview questions and answers
