steve000 (3/9/2015)

---

Do you have a sample you would be willing to share? (Stored proc working with csv?) I do SSIS CSV imports all the time!! I didn't know i could...

t.mounika01 (3/6/2015)

---

Actually, what i meant was that I just have thereotical knowledge and I have been practicing queries on ssms installed in my laptop. I want to know how...

That's what I'm doing right now,...

tom.artz (3/9/2015)

---

Nice article. Unconsciously or unknowingly I have categorized our databases into six categories - a 2X3 array. One axis is disaster / recovery axis with two high level options;...

Wendell, that did it! What I needed was to add a cboSchool.requery to the On Current of the form. I had the query right, just needed to refresh...

Thanks, Wendell. I'll give that a shot, that sounds like what I'm looking for. And Piet, I'm not ignoring your approach either.

Everything is a risk. Upgrading is risking business disruption, not upgrading is risking having previously unknown low-level vulnerabilities being discovered and exploited, aside from possibly hitting max limits that...

I am considering that, I'm not yet committed to it. The one good thing is that even though this system will be used state-wide is that I can only...

podmate (3/4/2015)

---

...I would write a screed about how slow SSRS is, how bloated the report files are and how painful the report builder/bids tools are to use, but then you...

Another way you can do it in SQL Server 2014:

SSMS:

Right click on the database, select Tasks, select Generate Scripts.

Click 'Select specific database objects'.

Expand the Tables tree and click the box...

Very interesting! I really should spend some time exploring DMVs, I used to love rummaging around in system tables in older versions of SQL Server.

Having said that, I'm getting...

Hey! "Smash Your Stack For Fun and Profit!" is the name of my forthcoming intro programming book, how did you...

To safeguard yourself against MDB corruption, store as little dynamic information in Access as possible. I've got lookup tables for combo boxes in my current Access project, everything else...

I have no problem with Express edition. Over the years I've developed scripts and batch files for running DBCCs backups against it via the Win OS scheduler and that's...

eric.notheisen (2/27/2015)

---

...For example, I was the applications architect on an E-Commerce project for a large insurance company. I needed a server for the purposes of testing the application. ...