Have you ever wondered how much an IT staff member working for Department of Homeland Security earns?

http://php.app.com/fed_employees11/results.php?fullname=&topagency=DEPARTMENT+OF+HOMELAND+SECURITY&agency_name=%25&job_title=INFORMATION+TECHNOLOGY+MANAGEMENT&statename=%25&Submit=Search

🙂

Steve Jones - SSC Editor (2/9/2016)

---

Eric M Russell (2/9/2016)

---

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions...

ThomasRushton (2/9/2016)

---

Eric M Russell (2/8/2016)

---

There has been explosion in the number of relational SQL databases developed over the past 20 years. The broad sentiment that RDMS don't scale is due...

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions on the use of that data, but the...

There has been explosion in the number of relational SQL databases developed over the past 20 years. The broad sentiment that RDMS don't scale is due to the unfortunate fact...

If employees have interesting projects to work on, are well compensated, and generally happy with the direction of the organization, then having a "corporate culture" in place will give them...

Basically what you're describing is the underlying tables of a "distributed partitioned view" design pattern.

https://technet.microsoft.com/en-us/library/ms188299(v=sql.105).aspx

What you'll need to do is have each table insert identity values within a unique range....

Beatrix Kiddo (2/8/2016)

---

Thanks; I hope you're right. I'm very concerned that I'm getting de-skilled here. It's really sad; nobody cares, nobody wants to do anything well, nobody wants to improve...

roger.plowman (2/5/2016)

---

Eric M Russell (2/3/2016)

---

As a DBA, if I get a 2am call that a critical application is down, because a select in a stored procedure is missing a join...

TomThomson (2/4/2016)

---

Eric M Russell (2/4/2016)

---

Some good ideas (like open source software, open IT floor plans, and telecommuting) come out of startups and are adopted by the larger corporate establishment. However,...

It sounds like your concerns are to load data from old table into a new table while mimimizing transaction logging, downtime, and risk.

Consider this approach.

1. Using BCP, bulk copy your...

Yes, it is best to create the table with real...

TRY_CONVERT() is also useful for check constraints. For example, below we are requiring that "date" values stored in a VarChar column called FooDate can be casted as an actual Date.

create...

To quantify the overhead cost of TDE, one approach is to run a test workload, something like replaying a profiler trace, against both a TDE version of your database and...