Recent Posts - page 3
-
Connect to SSIS on a Named Instance of SQL Server
The Problem: Can’t Connect to Named Instance of SSIS in Management Studio I’ve occasionally run into the following error when attempting to connect to SSIS from Management Studio: “Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The SQL Server specified… Read More ›
-
How to Create a Publisher Policy Assembly
This post is only for a reference in how to create the config file and the command line arguments needed for the Assembly Linker (AL) tool to create the publisher policy file. For a full reference on how to create… Read More ›
-
Add Your Assembly to Visual Studio Add Reference Dialog
When you add a reference to a project in Visual Studio there are several tabs to allow you to “quickly” pick an assembly to reference. The .net tab is the first and, at first glance, appears to show all assemblies… Read More ›
-
Mouse won’t work in MS Word 2007 and Word Crashes on Close
I’ve had this issue a couple of times with MS Word 2007. Word won’t accept any mouse inputs, have to do every thing with the keyboard. Also, when you close Word, it crashes and tries to re-start unless you cancel… Read More ›
-
How to Schedule a Process in ASP.NET
I have on occasion needed to schedule a process to run on a nightly basis, but I did not have access to the server where I could schedule a windows service. So I had to turn to using a timer… Read More ›
-
Convert a ByteArray into a Stream
Often when you need to call a function to save a file to disk or to a database you are required to pass a .NET stream to the function but all you have is a byte array. In pre-.NET days… Read More ›
-
Installing SQL Server 2005 Reporting Service on IIS 7
I’ve had to go through installing reporting services on IIS7 a couple of times now (on Vista machines for development environments – but the same rules apply for IIS7 on Windows Server 2008). When running the install for SQL Server… Read More ›
-
Adding Controls to an ASP.NET form Dynamically
View this article with video and downloads at http://www.learning2code.net/Learn/2009/8/12/Adding-Controls-to-an-ASPNET-form-Dynamically.aspx. At first glance it appears that adding a control to a form dynamically is quite simple. In fact it is. It’s when you need to be able to persist that control… Read More ›
Featured Categories
Misc ›
-
Part II – Idempotence in a Database
March 4, 2019
-
Part I – What is Idempotence?
February 5, 2019
Web ›
-
Angular just keeps going
January 10, 2019
-
ASP.NET – Web Sites vs Web Applications
October 3, 2013
Database ›
-
SQL Server Map Login to User
January 17, 2014
-
Shrinking a Log File in SQL Server 2008
May 5, 2011