(Benjamin Nevarez) While most of the information, blogs and documentation about SQL Server 2014 have focused on Hekaton and other new features, not many details have been provided about the new cardinality estimator. Currently BOL only indirectly talks about it on the What’s New (Database Engine) se
Author: SSWUG Research
Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files
(Marcin Policht) So far, we have been operating under the assumption that our existing schema and data are not fully compatible with the requirements imposed by the Azure Software as a Service (SaaS) platform.
Microsoft Fakes Framework in Visual Studio 2012
(Raj Aththanayake) In Unit Testing/Test Driven Development (TDD) Isolating dependencies, sometimes referred to as “mocking objects” or “faking objects” is a norm. There are many books/articles that have been written on this topic.
ADO.NET: How to Filter Data in a DataTable
(Ged Mead) This post is about how to filter data once you’ve pulled it from the database and are working with it in a disconnected state. Obviously, if you know your exact filtering requirements when first fetching the data you can use a simple SELECT … WHERE query to filter in what you want. The
DBA Rules of Thumb – Part 9 (Call on Others for Help When Needed)
(Craig S. Mullins) Remember that you do not have to do everything yourself. Use the resources at your disposal. We have talked about some of those resources, such as articles and books, Web sites and scripts, user groups and conferences. But there are others.
Top DB2Night Show DB2 LUW Replay Downloads of 2013
(Scott Hayes) As we bid farewell to 2013 and welcome 2014, it is time to review our most popular DB2 for LUW shows for 2013! Check out DB2 community favorites and download the replays that you’ve missed! Here’s the list…
Reading SharePoint Surveys and Lists using a SQL Server Integration Services SSIS Package
(Pavel Pawlowski) You may need to read SharePoint list or survey’s data into SQL Server for further processing. For reading SharePoint lists there are the SharePoint List Source and Destination adapters on CodePlex. The SharePoint Surveys are in fact a list. Unfortunately they are a special kind of
Query optimization versus caching
(Morgan Tocker) Today I wanted to look at the relative merits of different optimization paths that can be taken on a Greenfield project. That is to say, one that has no constraints imposed on it by previous decisions made, and has received little to no optimization work to date.
Adopting ASP.NET MVC enhancements in an Existing Web Forms Project
(Suprotim Agarwal) Whenever we are starting with a Greenfield project, that is a new project from ground up, we prefer using the latest in the technology stack to the point where the team is comfortable with.
Get the number of users that are online using SignalR
(Dean Hume) In a recent experiment, I was looking for a way to retrieve the number of online users in an ASP.NET application. There are a number of techniques that can be applied, such as incrementing based on ASP.NET session state, or using Google Analytics to keep track of active users. I wanted t