Magenic Company Blog (Archive)

Magenic Sponsors SharePoint and SQL Saturday

Blog: Magenic Sponsors SharePoint and SQL Saturday

There were multiple Microsoft events taking place this past weekend in the Twin Cities. Both SharePoint Saturday and SQL Saturday happened on October 12 and Magenic was there for each. In addition to sponsoring both engagements, we had speakers on hand at as well. Below is a recap of both events and who was involved.

Comments (0)

Database Unit Testing

Database Unit Testing

I’ve been doing database unit testing for some time now as part of my normal development process. I was even doing it before Microsoft first began to release tools for database unit testing in Visual Studio 2005 Team Edition for Database Professionals. It has always been a second nature to me. However, this is not true for every developer and so I decided I should write about what database unit testing is and how can it add value to development.

Comments (0)

Guidelines for Successful Data Warehouse Projects

Thought Leader Blog Post

A good data warehouse is a core component of any organization’s BI infrastructure. It is used to create the cubes, reports and dashboards that deliver business value. For this reason, it is extremely important that any new data warehouse project is successfully executed, otherwise the rest of your BI infrastructure will be negatively affected.

Comments (1)

Magenic at PASS Summit 2012

Magenic at PASS Summit 2012

For the second year in a row, Magenic sent multiple SQL Server professionals to the PASS Summit. Seven consultants from Magenic regional offices around the country were in attendance at the conference this year. Check out what we learned.

Comments (0)

BI Summit Recap and BI Twitter Updates

Magenic on Mobile

This past Thursday, Magenic hosted a Business Intelligence Summit in Chicago. We had some customers, partners, and consultants present on the role that business intelligence has in their worlds. It was great to see our customers talk about how their projects were implemented and how we overcame both business and technology challenges.

Comments (0)

Why I Am Excited about SQL Server 2012 (Part 2)

Magenic Blog: Integration Services Catalog in SQL Server 2012

We are coming up to the end of “Launch Month” for SQL Server 2012. On March 7, Launch Day, I published the first five reasons I was excited. In honor of the local SQL Launch in Minneapolis, I thought I would add to the list. So, in no particular order here are five more reasons I am excited about SQL Server 2012 that should excite you as well.

Comments (1)

SQL Server 2012 will make it a hard sell – It's worth it!

Magenic Blog: SQL Server 2012 will make it a hard sell – It is worth it

With thundering applause, SQL Server 2012 is released to manufacturing! OK, it may not have been that exciting for most but for SQL Server professionals, a new release event is always an exciting and critical step in the evolution of SQL Server. With each release of SQL Server, we’ve seen great advancements in what is offered as an overall complete and powerful database engine and feature set.

Comments (0)

Increasing Performance and Value in your Data Warehouse with Columnstore Indexes

Increasing Performance and Value in your Data Warehouse with Columnstore Indexes

Today I would like to talk about columnstore indexing one of the many new features that stand out in latest release of SQL Server 2012. Columnstore indexes are primarily designed for use in dimensional data warehouses and data marts and are optimized to improve query performance from a star or similar join in some cases boosting execution times up to 100 times faster than a traditional row based index.

Comments (1)

Getting Started with SQL Server Data Tools (SSDT)

Magenic Blog: Getting Started with SQL Server Data Tools (SSDT)

After the SSDT product shipped, I spent some time converting an existing project ( dbproj / Data Dude based project) to SSDT. Actually, I decided not to convert the project, even though I was prompted to do so. Instead, I decided to re-import the SQL 2012 database. My reason to do so was the fact that the old project was breaking down each table into multiple files, one per object.

Comments (3)

Categories

© 2013 Magenic, All rights Reserved