Data Science belongs more on the Business Intelligence wing of the IT department, rather than over in the DBA wing. Certainly we as a DBA can leverage tools like Excel...

This happens for me occasionally, and I use the following script to update sysjobactivity to reflect that the last run ended, and then it calls procedure to stop the job.

declare...

djackson 22568 (9/15/2016)

---

Eric M Russell (9/15/2016)

---

But going back to Steve's editorial, organizations need to implement application level encryption (ie: PGP for emails) and database level encryption rather than relying on...

Gary Varga (9/15/2016)

---

Eric M Russell (9/15/2016)

---

But going back to Steve's editorial, organizations need to implement application level encryption (ie: PGP for emails) and database level encryption rather than relying on...

I'd reccomend against an indexed view for reasons mentioned earlier by others.

However, if this view is giving the reporting users everything they need, and they can tolerate some degree of...

Analyzing data while in the process of performing your job as a DBA is not really "science". It's just like knowing a little something about chemistry can help you be...

But going back to Steve's editorial, organizations need to implement application level encryption (ie: PGP for emails) and database level encryption rather than relying on infrastructure encryption like SSL, VPN,...

Iwas Bornready (9/15/2016)

---

Jeff Moden (9/14/2016)

---

Night? Free brainstorming for the company and it's at night?

I've heard of "Down Tools" or "Down...

You can't really elminate the number of tables joined unless you refactor your data model. However, Common Table Expressions can reduce the complexity, and sometimes improve the performance, of queries...

By setting the property RetainSameConnection = True on the Connection Manager, temporary tables created in one Control Flow task can be retained in another task. You would have X number...

Gary Varga (9/14/2016)

---

It is this sort of thing that has me longing for from the freelancers world that I live in. That none of my clients have yet to do...

djackson 22568 (9/14/2016)

---

Eric M Russell (9/14/2016)

---

djackson 22568 (9/13/2016)

---

I think more...

How did you end with a 12 GB mssql ERRORLOG file, if that's what you're talking about?

Anyhow, there are some Hex editors like HxD or XVI32 that can browse and...

sqlenthu 89358 (9/14/2016)

---

Table is not partitioned and also...

djackson 22568 (9/13/2016)

---

I think more people than those at the...