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 »
Well its been quite sometime now since our last post, was so busy with lots of things now that I manage three teams, Development, Operations and Project Management. My programming activity drastically went down as I do a lot of juggling between three roles plus managing them, imagine a portfolio of 63 projects last year… 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 are migrating your SSIS Packages from an old version SQL Server to a new SQL Server version, it worked perfectly fine before but once it was deployed on the new environment you get an error similar to this one. Message Executed as user: YourDomainYourUser. Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for… Read More »
Have you ever encountered this error when you are trying to add a database on your Always On Availability Groups? “This database is encrypted by database master key, you need to provide valid password when adding it to the availability group.” You get this on the Wizard after warning you that a Password is required… Read More »
If you are looking for the most complete LDAP Query in SQL Server to extract all your Active Directory Users then look no further this is the solution for you, in one query you can extract all the necessary users on your Active Directory using TSQL.
SQL Server AlwaysOn Availability Group has been existing since SQL Server 2012 and its one of the best features SQL has to offer, while I haven’t used it in production since it was launched I tried using it for only testing but now that we have an Enterprise License we can use it in Production… Read More »
To make your Sharepoint database reliable you need to mirror it, meaning what ever happens on SQL Server A will be mirrored or replicated on SQL Server B and it’s quite easy to achieve you just need two steps to do it. First is to mirror your SQL Server databases, you can achieve that all… Read More »
You might be in a scenario where you were assigned to find a certain text on all the records on your database. Well you might think that’s easy, well yes if you have only one database with few tables and records but what if you have a large database with tons of tables then its… Read More »
Ever wondered how do you export TAB delimited reports in SSRS? It’s quite easy as you can configure SSRS to export it using the CSV render inside the ReportingServices rendering engine of SQL server. You can do that by updating the rsreportserver.config file which can be found in the following path C:\Program Files\Microsoft SQL Server\MSRS{YourSQLServerVersion}.MSSQLSERVER\Reporting… Read More »