Database snapshots
At work, we do our Dynamics AX development on VMs, set up with a full install of AX (SQL Server, AOS, and AX client). Prior to our R3 upgrade, we […]
SQL
Classic ASP – SQL Injection
We still have a few old sites at work that are in classic ASP. One of the problems that tends to occur on these old sites is SQL injection attacks. […]
SSMS Tools Pack
Stumbled across the SSMS Tools Pack today. How has this been around since 2007, without me knowing about it? I installed it at work, and I’m already finding it useful.
found it
Following up on my post from a couple of days back, I found my invalid nulls today. There were null values where there shouldn’t have been on 20 records in […]
fun with stored procedures
I had some fun today optimizing a stored procedure. It was taking about 10 minutes to run, and I got it down to running in two seconds with a pretty […]
stored procedures
I had to debug a problem with a third-party e-commerce system today at work. It took a while to isolate the problem, and when I did, it led me to […]
more SQL silliness
Well, after thinking I had my SQL problem licked, it came back. I finally got a callback from a support guy at Microsoft, and he had me update statistics on […]
SQL patching fun
After all the patching I did over the weekend, it seemed like everything was fine on my main SQL server. However, on Monday, we discovered that a couple of oddball […]
reference vs. value types, and LINQ
One of the people I work with was having some trouble with reference vs. value types (in C#) this week. This article seems to give a pretty clear explanation of […]
VS.NET 2005
I just got done installing VS.NET 2005 on my new desktop machine at home. I’m still working my way through ASP.NET 2.0: A Developer’s Notebook. I’m just starting the Data […]