Yes, it is best to create the table with real...

TRY_CONVERT() is also useful for check constraints. For example, below we are requiring that "date" values stored in a VarChar column called FooDate can be casted as an actual Date.

create...

To quantify the overhead cost of TDE, one approach is to run a test workload, something like replaying a profiler trace, against both a TDE version of your database and...

Some good ideas (like open source software, open IT floor plans, and telecommuting) come out of startups and are adopted by the larger corporate establishment. However, much of the "big...

Years ago, I started working for a company where the developers didn't check their .sql scripts into version control, or at least the smaller team I worked with didn't. However,...

Orlando Colamatteo (2/3/2016)

---

Eric M Russell (2/3/2016)

---

Let's assume that the business requests a high priority modification to functionality currently in production. Let's also assume that the development team has recently made...

Let's assume that the business requests a high priority modification to functionality currently in production. Let's also assume that the development team has recently made an unrelated bug fix or...

What matters most is outcome. At the risk of sounding like an apostate; I'll assert that methodologies, souce control repositories, and roles are just frameworks and tools that exist only...

Coincidentally, just last week I was just searching the web for a good pattern for implementing a queue in SQL Server. How well this works depends on dequeue volume and...

Orlando Colamatteo (2/2/2016)

---

Eric M Russell (2/2/2016)

---

From the perspective of a DBA, I'm sure most of us would prefer that stored procedures an views be stored in clear text and that...

From the perspective of a DBA, I'm sure most of us would prefer that stored procedures an views be stored in clear text and that we have the option to...

Are we talking about management, monitoring, or both? There is this thing called Microsoft Operations Manager, which is used to manage and collect operational stats for servers across the enterprise.

......

Steve Jones - SSC Editor (2/1/2016)

---

...

Here's the rub.

Let's say you have an issue in production with a proc/view/table/function. You want to test it. However development has changed. I can't necessarily...

One reason why the production version of some objects can differ somewhat from the latest in development source control is that the DBA may perform some last minute adjustments to...

JonnoJ (2/1/2016)

---

I've searched and read similar topics about licensing questions for more than a few hours, but couldn't find any to answer my question.

Basically I'm planning to use a Developer...