N.B. (7/30/2016)

---

The SNAP_DATE column in the tables will be part of the primary key on each table, and used when joining those tables to each other for historical reporting. ...

Hugo Kornelis (7/29/2016)

---

Also, in the past I remember the Australian community organizaing a series of "SQL Saturday" events that were spread out over the country and all just a few...

No. Reclaiming space = shrinking data files.

You could just leave it though. Free space in the data file...

I'm going to be an outlyer, but most of these were paired with a second event in the same region (eg MVP Summit, SQLBits, etc), and I was speaking at...

ZZartin (7/27/2016)

---

GilaMonster (7/27/2016)

---

Eric M Russell (7/27/2016)

---

It can be especially difficult for an organization when the recruiting effort is too focussed on conformity and cultural fit rather than experience and talent...

The copyright page on my blog is more so that when someone starts posting my stuff as theirs, I have something to point them to as to what I consider...

What's the output of:

SELECT * FROM tab1

SELECT * FROM tab2

?

Eric M Russell (7/27/2016)

---

It can be especially difficult for an organization when the recruiting effort is too focussed on conformity and cultural fit rather than experience and talent relevent to...

Easiest is to use a maintenance plan for that, the cleanup task does the file removal, the backup task lets you select specific databases

Eric M Russell (7/26/2016)

---

Rod at work (7/26/2016)

---

If, "The market is too starved for talent to be at a job you kinda like or don't like at all.", I don't see...

curious_sqldba (7/26/2016)

---

if i have a sproc that does bunch of reads from one database and writes it to another database, would the read-only type queries automatically get transferred to secondary...

Let's step back a bit. By 'disk', do you mean old-style spinning disks directly attached to the machine, or do you mean a SAN LUN presented as a drive?

Unfortunately that's not true.

http://blog.purestorage.com/what-is-sql-servers-io-block-size/

twin.devil (7/27/2016)

---

Quick suggestion, you can you PATINDEX to validate Email as well as to get the Birth Year from the email address.

select dob, adj.YEAR_OF_BIRTH, email, IsValidEmail

from

(

Select cast('20160101' as datetime)...

Already fixed. https://labs.detectify.com/2016/07/27/how-i-made-lastpass-give-me-all-your-passwords/

Edit: correction, looks like different exploits.