What problem are you trying to solve? The execution plan for a stored procedure will be cycled out the plan cache when it hasn't been called for a long period...

FTP is a logical choice for providing scheduled data extracts to an external client, especially if they can potentially be more than a handful of MB. If what they need...

Actually there is a fork of MySQL 5.5 that supports ANSI-2011, PL/SQL, and T-SQL 2012. In addition to that, it has distributed scale out capability.

https://sourceforge.net/projects/mysql_hydra

It's all about disparities in the economic of supply and demand. You want to position yourself so that it's works for you rather than against you. Students who graduate from...

First, learn what a table is, and what relational data is. I also suggest the Stairway tutorials found here as a study guide. In your case, specifically the following as...

Frankie-464050 (4/1/2016)

---

I found it once on the web but cannot find it again. I believe it had to do with Data Tools. We have many projects that we...

First, if...

I can see the potential value for an interactive "3D" view of a database's schema, storage allocation, topology, etc. displayed on existing flat screens. Maybe a SSRS or PowerView report...

You are performing a equijoin between Students and a filtered aggregation of Students that contains only repeated combination of name and dob.

Where I am now, there is an on-call rotation for DBA team members. If you're on-call for current week, then you're the primary contact for production support issues during or...

raven066 (3/3/2016)

---

HI All,

Recently i was thinking about Oracle, beacuse right now I'm MS SQL DBA/DEVELOPER.

Some people said that oracle is future, and i'm little bit confused.

Can Senior members in...

Live Query Statistics, the ability view the execution plan of a running query, that just awesome.

https://msdn.microsoft.com/en-us/library/dn831878.aspx

For those of you who routinely work overtime, does your boss ask you to work overtime, or do you simply feel compelled to put in extra hours when working on...

Jeff Moden (3/30/2016)

---

Manic Star (3/30/2016)

---

Powershell is awesome! Then i'm a former developer, so it was like the power of .net without the annoying user interface layer to program. It just...

kiwood (3/30/2016)

---

While I agree with tracking your consultants, this tends to miss huge issue. For all you know, the guy who appears to need help opening a web browser...