SQL Server is amazing, its rich tool sets makes DBA’s, Devs and Engineers life easier and easier each day that passes, now with Azure its even more amazing! One of the best features of SQL is its ability to replicate from On Premise to Azure and there are many ways to achieve this, from Always… Read More »
If you are using Citrix Director not on a Platinum Edition and you want to report on your trends beyond last month then most probably you are out of luck as the Citrix Director web interface only supports the following time periods: Last 2 hours, Last 24 hours, Last 7 days and Last Month. It became… Read More »
You might have upgraded your Sharepoint to 2013, have this “Sorry, something went wrong error” and you don’t know whats causing it. This was my issues several week ago when I migrated our Sharepoint. I looked at the old version and it all works fine but on the new instance it does not work, I checked everything and compare… Read More »
Are you new to LINQ and trying to figure out how to create dynamic LINQ queries like the same way you do with ADO.Net? Well it’s not that hard at all and all you need to do is use a combination of the “Where” Extension method and “IQueryable” interface.
You might have SQL Mirroring enabled in your Enterprise but might not have alerting enabled or you don’t know how to enable it. If you want to enable that functionality just follow this 2 easy steps.
Before we start lets define what a Median is first, in laymans term the Median is the “middle number” in a sorted list of numbers.
There are many ways that you can let your application handle failover situations and here are some suggestions I had used in my past projects. But before you start with my suggestions make sure that you have the same database names for both and the same goes for user accounts and permissions. The items here… Read More »
If you encounter this error: OLE DB provider “SQLNCLI10” for linked server “LinkedServerName” returned message “The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.”. Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset “DBSCHEMA_TABLES_INFO” for OLE DB provider “SQLNCLI10” for… Read More »
Mirroring a database is not really a hard task to do, you just need this easy and simple 11 steps to start mirrored SQL Server. Doing it will not just improve you disaster recovery capabilities on your application but also you are leveraging the high availability database mirroring feature you find in SQL Server 2005… Read More »
After my post here, It seems that everything is working fine but I need performance out of it an my last resort is to Execute Stored Procedures in Parallel so I can run multiple instances in one run. To achieve that I need to create a CLR Stored Procedure so I can run Execute commands… Read More »