I just took a look at the recovery model used for my instance of the SQL Express database, and I see it is set to Simple. Under those circumstances, what...

DEK46656 (3/6/2014)

---

I think the fundamental issue that drives people to using EF and similar tools is a lack of understanding for relational data concepts. SQL is not OO, or...

My environment is somewhat different. We have MS SQL and MS SQL Express, so in essence the DBMS. However we still use a ORM to help us write our code....

I like your analysis, Stephanie. Very good.

I recently went through this. We have a somewhat older ASP.NET website, that doesn't want to work with Internet Explorer 11. But more and more of our external users are...

Grant Fritchey (2/25/2014)

---

humbleDBA (2/25/2014)

---

It won't work if...

Grant Fritchey (2/25/2014)

---

That's kind of nuts. I wouldn't even bother with log backups there. Just have the daily one since it's extremely likely you'll only ever be able to go...

Hello Grant and Gail,

Yes, they are only running a single log backup. It happens once a day, immediately after the backup of the database occurs.

The ASI database is using the...

v.collazos (2/14/2014)

---

Rod at work (2/14/2014)

---

Mauricio N (2/14/2014)

---

I've used VMWare Player (now Player Plus) and VirtualBox. Both are good, unfortunately it's not so easy to change from one to another (I've...

Mauricio N (2/14/2014)

---

I've used VMWare Player (now Player Plus) and VirtualBox. Both are good, unfortunately it's not so easy to change from one to another (I've tried this week).

With...

Craig, it was your suggestion of running a server side trace that put me onto the possibility that the code had left something out. All I saw was the SELECT...

OK, I think I've found out what the problem was. There wasn't a call to the save routine, in the user control that hosted those 8 data elements. I've put...

Evil Kraig F (1/27/2014)

---

I'd start with running a serverside trace on the 2012 server to determine if the commands are even getting there.

If the commands are reaching the server, then...

Good article, Steve. I don't see how to get around this one. Where I work there aren't a lot of people who even know how to open up Excel, let...

Sean Lange (1/15/2014)

---

Rod at work (1/15/2014)

---

Hi Sean,

At this point I'm considering the possibility of using NVARCHAR. We didn't, back in the day when the database and tables were first created...