David.Poole (6/9/2016)

---

The trick is to know how long to retain the information for. It depends on how fast your website changes. If your website changes radically over time...

David.Poole (6/9/2016)

---

Yes, there are genuine Big Data generators and consumers out there, particularly in the hard science and high end financial sectors.

Personally I'd be curious what people estimate...

I only run into issues when the work is poorly managed and communication is dropping. Ideally, if we are all working together, then very few merge conflicts happen regardless of...

Interestingly enough, as data grows for most of us, we also have ways of dealing with it.

For example, I have a rather large transactional data warehouse. Without notice, one of...

sestell1 (5/18/2016)

---

Darn, it looks like that uses the MS Office API to connect to the workbook and do the conversion. I was hoping for a command-line utility that does...

Haven't ran into this specifically, but have heard about it.

Ideally, you're getting the RPC_E_WRONG_THREAD call here, which means:

A RPC_E_WRONG_THREAD error occurs when a thread calls via an interface pointer which...

As no one has answered this in regards to SSIS specific ways, here is what I do.

When I want to pull data via a third-party API service using HTTP/HTTPS, I...

As others recommended is good.

I just moved mine by backing up, restoring to the same version of SQL Server from on-premise to a data center. Transfer happened over a period...

I've been interviewing for some new DBA positions. I've asked every single hiring manager and senior DBA what the DBA does at their organization. It's not because I don't know...

Thanks again everyone.

I started the conversations on my possible transition out due to a offer on the table and that didn't go too well yesterday. It's pretty obvious me leaving...

Thanks for the feedback guys!

I work for...

Hey guys,

Need some advice. I got a really good job offer recently to work at a company as a DBA. I'm currently a data architect that built and manages a...

That...

Alan.B (4/28/2016)

---

Yet Another DBA (4/27/2016)

---

jeff.mason (4/26/2016)

---

Microsoft has made SQL Server so big that even "generalists" are usually "specialists". I know of few people who are experts in the DB...

I absolutely recommend RedGate SQL Prompt for SSMS. It's a great plugin for SQL development.

For data modeling and so forth, I think Excel and Visio still work fine. I normally...