Kevin Kline does a good 200 level talk on SQL Server architecture, starting with how the database engine receives SQL queries and then parses, compiles, caches / re-uses, executes, retreives...

GoofyGuy (6/30/2015)

---

... I've interviewed a lot of folks for the position of "Sr. Developer" and "Sr. Database Administrator" over the last several years and with great disappointment. Most of the...

Jeff Moden (6/30/2015)

---

Eric M Russell (6/30/2015)

---

Jeff Moden (6/29/2015)

---

...

As some of you may know, I've interviewed a lot of folks for the position of "Sr. Developer" and "Sr. Database Administrator" over...

My wife has often uttered a particular saying during stressful times in her career. She spent 20 years working in computer telephony and speech, often in sales, and would remind...

Jeff Moden (6/29/2015)

---

...

As some of you may know, I've interviewed a lot of folks for the position of "Sr. Developer" and "Sr. Database Administrator" over the last several years and...

DBCC OPTIMIZER_WHATIF

Assuming you have a large table which is batch loaded, essentially a flat data warehousing type table (not OLTP), and there is a need to perform ad-hoc type queries against...

What I do sometimes is click on the 'Print' link to display the article in print friendly layout, and then I'll save it as a PDF document using the PDF995...

While there have always been DBAs that tightly controlled their systems and acted as impediments to change, I think those positions are disappearing fast. More and more companies, if they...

GilaMonster (6/26/2015)

---

The 'exit' statement that I made when I left the bank (after 4 years of working there and ~2 weeks of being intermittently belittled and insulted by some of...

Jeff Moden (6/26/2015)

---

David.Poole (6/26/2015)

---

I know someone who was disappointed to get a Survey Monkey exit interview. The gist of the survey was as to whether the company was good,...

My background is more DevOps, thinking back to the 2012 exams, it was the installation and disaster recovery related questions are what I struggle with, especially replication and mirroring (bleh!)....

David.Poole (6/26/2015)

---

I know someone who was disappointed to get a Survey Monkey exit interview. The gist of the survey was as to whether the company was good, outstanding or...

You can find equal numbers of SQL Server versus Oracle developers, and the same goes for C# versus Java developers. Also in terms of features they are similar. However, the...

I do occasionally rename variables, temp tables and such when refactoring a stored procedure. So long as the input / output parameters and resultset columns don't change, then this type...