Geeks With Blogs
Ilya Verbitskiy Thoughts and links about computer programming October 2013 Entries
Microsoft ReportViewer SetParameters continuous refresh issue
I am a big fun of using ASP.NET MVC for building web-applications. It allows us to create simple, robust and testable solutions. However, .NET world is not perfect. There is tons of code written in ASP.NET web-forms. You cannot simply ignore it, even if you want to. Sometimes ASP.NET web-forms controls bring us non-obvious issues. The good example is Microsoft ReportViewer control. I have an example for you. 1: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" ......

Posted On Wednesday, October 16, 2013 11:34 PM

How to change recovery mode for all databases
Changing recovery mode from FULL to SIMPLE for a SQL Server database is not a big deal. You can do it with one simple command. 1: USE master 2: ALTER DATABASE YourDatabase SET RECOVERY SIMPLE But it might be tricky task to do for all databases on your server. Of course, you can to generate a script using using any programming language. I usually use F# for such “quick and dirty” solutions. This time I solved the problem with T-SQL. I had to change recovery mode for more then 200 databases. 1: declare ......

Posted On Thursday, October 10, 2013 6:30 AM

Copyright © Ilya Verbitskiy | Powered by: