roger.plowman (2/5/2016)

---

Eric M Russell (2/3/2016)

---

As a DBA, if I get a 2am call that a critical application is down, because a select in a stored procedure is missing a join...

Never noticed your avatar pic before: is that you playing a Strat?

PSB (2/5/2016)

---

Hi,

Integration: Error at server : XYZ. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

The sample URL used is :

https://teamspace.abc.com/sites/LLL/LLL-SAP/SARNew/Archive/_vti_bin/listdata.svc

We access the...

SQL!$@w$0ME (2/4/2016)

---

Hi Guys,

Could you please give some guidance on selecting hardware for a new DB server. This will be a new Operational Data Store setup. Expecting moderate ETL load (SSIS...

Michael L John (2/4/2016)

---

Grumpy DBA (2/4/2016)

---

Michael L John (2/4/2016)

---

GilaMonster (2/4/2016)

---

jasona.work (2/4/2016)

---

Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important...

jasona.work (2/4/2016)

---

Luis Cazares (2/4/2016)

---

jasona.work (2/4/2016)

---

Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't...

For each combination of machine/instance?

Without knowing your table structures, the examples provided are as real...

Grant Fritchey (2/4/2016)

---

Grumpy DBA (2/4/2016)

---

In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code review I would point...

I think you might need to extend...

Edvard Korsbæk (2/4/2016)

---

Well, I found the correct answer in the end.

checked on the DB, which was used by the customer - it had level 110.

Next question is of cause, what...

Your own, presumably? 🙂

You seem to have found the correct answer, using the wrong technique 🙂

Different versions of SQL Server support different compatibility levels (see here).

Within a SQL Server instance, databases can have...

Have a look at TFS Power Tools.

You'll need to select the correct version for your environment. Once you've done that, you'll get a certain amount of TFS functionality available to...

Orlando Colamatteo (2/3/2016)

---

SQL_Surfer (2/2/2016)

---

I've about 200 SSIS packages that needs to be run on 10 different instances. What is the best way to configure this dynamically? Ideally I'd like to...