Write your tests so they can be run manually or automated.

It's a similar effort. You'll run manual tests many times anyway.

Today is late. My fault. I scheduled everything in the newsletter and assumed I'd done the newsletter as well.

Sending

jasona.work (2/24/2016)

---

So a question to everyone: Would you prefer if someone posts a quick "reported as spam" reply to the spam topics after they report them, or nothing? ...

Interesting thread. Just found it, and decided to add a few thoughts.

I don't think there's fundamentally anything wrong with usp_, but I'm not sure it's helpful. These days we have...

As an example, here's DDL with data.

CREATE TABLE dbo.MyTable ( mystring VARCHAR(200) );

GO

INSERT dbo.MyTable

( mystring )

VALUES

( 'This is a 7'...

The TIFF file should be in a binary format (binary or varbinary). This means you need to extract the binary data and write it to a file.

I'm guessing that...

The answers have been updated, and I'm awarding back points to this time.

Steve

A backup is copy of the pages. There is no effort made to recompute anything or look at the contents. They are copied to disk on backup, copied back on...

The main reasons have been listed. Using normalized storage gives you slightly more complex queries with joins, but easier updates, easier and simpler growth if you expand the model, less...

I know, lots of management doesn't. However devs still get value. Write the tests to exercise your code, so that when you alter it, you know if it still works.

Alan.B (2/23/2016)

---

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

The R or Python stuff is useful if the statistical work is more complex. Most of what can be done in R can easily work in Python, which is a...

Insert is a modification. In this case, you shouldn't have collisions, but there are ways to handle things. I'd urge you to look at replication.

Eric M Russell (2/23/2016)

---

Assuming you could load GB of disk storage, GB of RAM, Windows, and SQL Server, a Raspberry PI would be severely under powered for even single user...

kiwood (2/23/2016)

---

I think the government needs to do the right thing and get involved in the hospital's operations for awhile. It should start with a fine for not having things...