---

As you may know by now if you’ve been following SQL 2012 HA capabilities, AlwaysOn availability groups allows readable secondary replicas to allow offloading of backups, database consistency checks, index fragmentation checks, reporting and so on. One of the question I see being asked a lot is how do I tell my connection that I want you to go to read-only ......

---

Its official, my Microsoft Virtual Technology Specialist (VTSP) has been approved, another mile stone to helping clients and partners find value in Microsoft Products in particular SQL Server, Business Intelligence and SharePoint. As per Microsoft VTS Program is defined as: The Microsoft Virtual Technology Specialist Program (VTSP) is a select group ......

---

When creating your partition schemes you get the following error The associated partition function MyPartitionScheme generates more partitions than there are file groups mentioned in the scheme ' MyPartitionScheme'. If you look at the error closely, its yelling that SQL Server has more than one File Group and in your savvy Scheme creation you decided ......

---

So you have two tables that you want to compare to see what’s common between them and what’s not. Traditionally I have used JOINS to get what I need but did you know you can compare the two tables results simply by using the EXCEPT and INTERSECT syntaxes? Let’s look at these two beauties. EXCEPT – returns any distinct values from the left (sounds familiar ......

---

Some literature first If you are not, you should start considering database encryption for your organization as data is the only reason you are in business. If and when it becomes compromised bad things are bound to happen. When TDE is enabled or disabled for that matter a background process is initiated by the server that encrypts all the database ......

---

After configuring user profile you get the correlation id and in event logs you get The Forefront Identity Manager Service cannot connect to the SQL Database Server. The SQL Server could not be contacted. The connection failure may be due to a network failure, firewall configuration error, or other connection issue. Additionally, the SQL Server connection ......

---

Here is the list of all the changes in SQL Server engine that has been removed.

http://technet.microsoft.com/en-us/library/ms143729.aspxv

---

This morning I decided to be a little adventurous and install SharePoint 2010 on SQL 2012 environment and the first thing I noticed is that the installation fails because in SQL 2012 Microsoft has removed [sys].[sp_dboption] system Stored Procedure. This has already been reported as a bug but the response from the MS team was that this is by design ......

---

One of the things that I’ve heard people complain over the years after the release of SharePoint 2010 is the disappearance of Drag & Drop web parts capability. This feature was useful because it allowed the page designer to add as many web parts on a page without having to click add and repeating the process all over again. This feature is available ......

---