Have you considered downloading SQL Server Express (free) or buying SQL Server Developer Edition (about $50)? You'd have your own full-blown copy to play with then.

Matt Miller (#4) (9/14/2015)

---

Eirikur Eiriksson (9/14/2015)

---

Jeff Moden (9/14/2015)

---

Eirikur Eiriksson (9/13/2015)

---

Using heap to speed the inserts is like a very bad Credit Card deal, no transaction fees but X000% Annual interest...

erichansen1836 (9/11/2015)

---

I think it is important to ask questions such as whether it is more prudent to use:

MS-Access, MS-Jet Engine(w/o MS-Access), SQL Server Express, or SQL Server for any particular...

Eric JOATMON (9/8/2015)

---

Most of our training seems to be common sense type things. Depending on the topic, I will skim the materials (for unfamiliar things) or just click NEXT...

A couple more sources. ...

Very interesting. And if you change the second line to SET @TrueValue = ' '; then you get 123 as the output.

Definitely worth knowing.

This is REALLY weird. I'm running '14 Developer's Edition on my desktop and I can't do a select * from sys.configurations. The system comes up and says "Incorrect...

Shortcuts taken early in the project can have significant costs in the later stages, so is it really a savings? For me the takeaway is that developers need to...

Eric M Russell (8/28/2015)

---

... I spend my days in an office working with other IT professionals, not hanging out at a coffee shop with friends or watching episodes of Oprah...

Wow, a 35,000 word article? That's a short story! It took me pretty much a full day to read it! (don't tell my boss)

It had a lot of...

Happy to help, Rod! Either your developer knew to apply them or the upsizing wizard might have added them. You might want to keep the new fields rowversion...

Ed Wagner (8/26/2015)

---

Jeff Moden (8/26/2015)

---

Wayne West (8/26/2015)

---

Jeff Moden (8/26/2015)

---

dwain.c (8/25/2015)

---

Thank the Buddha for whoever came up with the idea of a Tally table in the first place! I just...

Rod, if your database's front end is Microsoft Access, or if people are using Access against it, you might want to keep it. Access likes rowversion to see if...

Very interesting, I need to remember to keep an eye out for that @.

Thanks for the good article, Mike!

I think the most telling part of that comic is what the cursor hovertext describes. I've learned to ALWAYS read the hovertext,...