Quick Tip: Installing SharePoint Farm with SQL Server 2012

Today, I was trying to install SharePoint Farm on my computer with SQL Server 2012. Everything ran smoothly until I started the SharePoint 2010 Products Configuration Wizard. Initially, the wizard started smoothly, asked me DB Name and other details but suddenly while it was processing it threw an error: Failed to create a database. An…

0

Did you Experience the NEW SQL Server 2008 R2 [Kilimanjaro]

Kilimanjaro is now SQL Server 2008 R2. This is the next version of SQL Server 2008 that will give your organization a power steering to drive the Business Intelligence efforts much faster & focused in your organization. Why I say that it is the next version of SQL Server 2008 instead of “SQL Server” is…

0

Performance Boost for SQL Queries – Filtered Index in SQL Server 2008

SQL Server 2008 introduces an enhancement to the way the indexes are created which helps to get better performance from the same queries. This new little guy is known as ‘Filtered Index’. This is actually an Optimized Non-Clustered index which is well suited to cover the subset of data with in a table. Every organization…

0

How to get the current time of any TimeZone in SQL Server 2008

We create ASP.Net applications which is hosted at a Central Location say Seattle (USA) but the customers using the application are located all around the world and when they enter the transaction they want their local time to be considered but when we call the function GetDate() the SQL Server will take the server time…

0

Easy Table Partitions with SQL Server 2008

I am glad to see people realizing the value of SQL Server 2008 platform and they are happily migrating to the SQL Server 2008 platform. Thank you very much for visiting this article. In case if you are not on the MSDN blogs then I would request you to please visit my blog at http://blogs.msdn.com/manisblog…

0

How to deploy SQL Server 2008 Express as a prerequisite with ClickOnce

People often ask me how to deploy SQL Server 2008 Express with applications as a prerequisite with Visual Studio 2008. Most often this situation is encountered when people want to deploy applications using the ClickOnce or they want to build a MSI package with SQL Server 2008 using Visual Studio 2008 and include the SQL…

0

SQL Server 2008 - Resource Governor - Part II

Hi Friends, I was a bit caught up during these days so I could not update my blogs since a long time. Today again it is a weekend and I have some time so I am writing the article on Resource Governor Part II which is overdue since a long time. In my first post…

0

SQL Server 2008 - Resource Governor - Part I

Hi Friends, I am back with one more blog post on an interesting feature in SQL Server 2008. Today I was discussing about run away situations with my colleagues and I found that only few people read about this excellent feature available in SQL Server 2008 so just thought why not to blog about it….

0

SQL Server 2008 - Auditing

Hi Friends, I am back again with one more blog post on SQL Server 2008 Auditing. As we all know that SQL Server 2008 is coming up with *Cool* enhancements that will help the End Users, DBAs, Developers in improving their productivity. Today I am going to blog about a feature which would be liked…

0

Policy-Based Management : SQL Server 2008

NOTE: Declarative Management Framework has been renamed to Policy-Based Management so I just changed the Title of the article, the contents are unchanged. Hi, I am writing this post after somewhat long time … I hope you all are continuing with your learning on SQL Server 2008. Today I have some time to blog so…

0