Any programmer will be X times more efficient when given an assignment that matches their skillset, a clear set of specifications, sufficient managmement/QA/DevOps support, and sufficiently sized blocks of uninterrupted...

I'm not a freelancer, so I don't have the option of context switching to another client. So, when...

Rod at work (9/16/2016)

---

(We've been having network problems this week so am late in reading any email.)

I just read this. WOW, I am almost salivating reading about this Down Tools...

If this is something like a data warehouse, where you have very large tables that are sourced for reporting purposes from other transactional databases, then consider more of a Kimball...

jerry-621596 (9/15/2016)

---

I tried your script and get and error saying the request to stop the job was refused because the job is not currently running.

Seems like the mystery runs deeper...

I find it convenient to use xp_cmdshell to do things like execute NET or DOS commands for informational purposes, like in environments where the host server doesn't allow RDP connections....

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...