Blog : What’s On Our Mind?

Sharing Our Point of View
By Owens Gollamandala | On March 30th 2015
Designing Custom SharePoint Workflows with .NET
Many Microsoft SharePoint uses aren’t aware of its power when coupled with .NET. This powerhouse duo is especially useful for creating workflows. A workflow refers to the movement of documents or items relating to a business process through various actions or tasks. This can include creating applications or documents, tracking sales leads, or routing purchase orders. Any task requiring multiple approvals as well as the completion of a series of interrelated, complex tasks—namely, software development—can have a workflow created for…
By Pinal Dave | On March 27th 2015
If we ask any DBA about the types of indexes in SQL Server, most likely they would answer – clustered index and non-clustered index. This is no longer valid from SQL Server 2014 onwards, in which Microsoft introduced new types of tables called in-memory tables. The storage of these tables is not a traditional MDF file where data is stored in 8 KB pages. Traditional indexes are also no longer valid for these in-memory tables. There are two new indexes that can be…
By Pinal Dave | On March 23rd 2015
Four Things To Remember While Planning SQL Partitioning
Before covering what to remember, let’s cover the basics. What is table partitioning in SQL Server? In SQL Server a partitioned table is one that is referred to as one table but is subdivided into multiple partitions in which data is partitioned horizontally. A partitioned table has the following properties: Partition Scheme: This defines which file group the partitions’ data will be stored. Partition Functions: This defines how the data is partitioned (think of it as a WHERE clause, which segregates data into separate partitions.) This ensures that a group of rows are mapped together into partitions.
By Andy McDermid | On March 18th 2015
SQL Server Enterprise Edition Features You Didn’t Know You Could Use
Features Supported by the Editions of SQL Server Microsoft has very nice documentation covering which features are available for each version and edition of SQL Server. I refer to these pages fairly often, usually on Mondays when I can’t remember if some particular feature is available in Standard Edition (SE) or if it is Enterprise Edition (EE) only. If you zoom in on the Enterprise Edition features for any category you’ll notice a very rich set of amazing…