Category Archives: SQL Server

Book Announcement! Introducing “Programming Microsoft SQL Server 2012″

By Lenni Lobel | November 21, 2011

I’m very happy to announce that I am authoring Tallan’s new book on SQL Server 2012! The full title, “Programming Microsoft SQL Server 2012” will technically be published by O’Reilly, yet it will be branded as a Microsoft Press book, and will feature Tallan’s logo on the front cover. O’Reilly recently acquired MS Press, but [...]

Also posted in Microsoft | Tagged | Leave a comment

Leonard Lobel Awarded Microsoft MVP for SQL Server!

By milyevsky | October 13, 2011

This month, Microsoft awarded 143 exceptional technical community leaders with the Most Valuable Professional (MVP) title and re-awarded 764 MVPs worldwide. Tallan is thrilled to announce that Lenni Lobel has been recognized as an MVP in SQL Server!
According to the Microsoft MVP Award Program Blog, there are more than 100 million social and technical community [...]

Posted in SQL Server | Tagged , | Leave a comment

Using SqlFileStream with C# to Access SQL Server FILESTREAM Data

By Lenni Lobel | August 22, 2011

FILESTREAM is a powerful feature in SQL Server that stores varbinary(max) column data (BLOBs) in the file system (where BLOBs belongs) rather than in the database’s structured file groups (where BLOBs kill performance). This feature was first introduced in SQL Server 2008, and is now being expanded with the new FileTable feature coming in SQL [...]

Also posted in .NET Framework | Tagged , , | 6 Comments

Introducing SQL Server Developer Tools (code-named “Juneau”)

By Lenni Lobel | August 1, 2011

With SQL Server Denali CTP3 released just two weeks ago, I’ve been ramping up fast as I write the new edition of Tallan’s SQL Server book (Programming Microsoft SQL Server 2012, O’Reilly) and prepare for upcoming presentations at the NJSQL User Group (Sep 20) and the SDC event in the Netherlands (Oct 2/3). I recently [...]

Posted in SQL Server | Tagged , , | Leave a comment

The SQL Server OVER Clause

By Dylan Barrett | July 26, 2011

One useful feature in SQL Server is something called the OVER clause. The OVER clause has been available since SQL Server 2005 and allows you to perform window functions over a set of data.  SQL Server provides two types of window functions: aggregate window functions and ranking window functions.  I will explain what aggregate [...]

Posted in SQL Server | Tagged , , | 4 Comments

Using Table Valued Variables instead of Dynamic SQL

By Michael Gerety | December 21, 2010

I had a situation today where I have a stored procedure that is structured as follows:

1 CREATE PROCEDURE _Entity_GetByKeywordTypeDateRange(
2 @keyword varchar(255) = null,
3 @typeA bit = 0,
4 @typeB bit = 0,
5 @typeC bit = [...]

Also posted in Business Intelligence, Enterprise .NET | Tagged , , | Leave a comment

Introduction to Analysis Services

By achandler | April 10, 2009

This post is intended to introduce Analysis Services 2005/2008 foundational concepts.
SQL Server Analysis Services is a component included in the Microsoft SQL Server product, and its use is fully covered under the same license (which applies to Integration Services and Reporting Services as well). Like the database engine, SSAS has a range of features stratified [...]

Also posted in Analysis Services, Microsoft, Warehousing | Leave a comment

MS BI News Roundup

By achandler | January 27, 2009

Two big pieces of news on the Microsoft BI front:

Performance Point Server is being dismantled. After the next service pack, MS will cease develop of the product as its own entity. The Monitoring & Analytics capabilities will be bundled into the enterprise version of SharePoint. The Planning application looks to be dead in the water, [...]

Also posted in Analysis Services, Microsoft | Leave a comment