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 »
Have you ever wondered where is the setting to sort the List Views you created in Sharepoint? That drop down beside the list name that shows all the views available for that list. Well if you are looking for it then you can search and search forever until the new version of Sharepoint comes out… Read More »
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.
A while ago I have this post which parses a delimited string column in SQL to rows little did I know that I will needing it the other way around parsing rows to delimited string. So in case you need that solution here is how I have done it.
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 »
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 »
Have you ever wondered how would you convert that SQL column which is comma delimited into Rows so that you can effectively join it with other tables or use that infomration better. This might happen for those of you who have saved the keywords lets say of a blog application in a single column delimited… Read More »
Automating Backups on SQL Server Express Version is not as it does not have a SQL Server Agent installed with the instance but dont worry as you can still do backups but manually using the free SQL Server Management Studio Express or automated by using a combination of scheduled task (Win2k3 below) / Task Scheduler… Read More »
If you want to audit whats happening on your SQL Server then look no further as SQL Server 2008 have a built in function for that, so you can log all Queries like Select, Insert, Updates and Deletes perfromed on a cetain table easily, before you will be needing third party tools to do this… Read More »
Have you ever thought of restricting access to the Database by Application Name or Host Name, that’s on top of the user credentials. For example you don’t want users to use SQL Query Analyser but instead they should use MS Access instead or another 3rd party application, or you want only a certain Workstation can… Read More »