Business Intelligence in SQL Server 2014 – SQL Server Data Tools (SSDT)

  Updates to Design Tool installation   SQL Server Data Tools for Business Intelligence (SSDT BI), previously known as Business Intelligence Development Studio (BIDS), is used to create Analysis Services models, Reporting Services reports, and Integration Services packages. In this pre-release version of SQL Server 2014, SQL Server Setup no longer installs SSDT BI. The…

25

Why create a TechNet Wiki article when you can just link to an MSDN Forum thread?

So why should you create a TechNet Wiki article when you can just link to an existing forum thread? This blog post is part of the Social Synergy series.   Well, I think the need for a Wiki really hit me a few years back when I was searching for a solution to get my software…

6

T-SQL Guru – Dynamic Pivot on Multiple Columns

Naomi N is our TechNet Guru for May! See more about the Technology Guru TechNet Wiki for May contest.  She had two winning articles. Here is one:  T-SQL: Dynamic Pivot on Multiple Columns        And here’s an excerpt from the article: The problem of transposing rows into columns is one of the most common problems discussed in Transact-SQL…

7

How to Embed SQL Server Express in an Application

Today’s featured TechNet Wiki article can be found here. It was originally authored by Larry Franks. =============== Which Edition of SQL Server Express to Use There are several editions of SQL Server Express, from a database only install to database, advanced services, and manageability tools installation. SQL Server 2008R2 Express Management Studio Basic Runtime Only…

10

How to use a SQL Server database with your ASP.NET web site

Today’s featured TechNet Wiki article can be found here. It was originally authored by Larry Franks. ===============   Intended audience: Web developers who are not familiar with SQL Server, yet want to learn how to use a SQL Server database with their ASP.NET web sites. This information assumes that you are already familiar with ASP.NET….

1