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

The addition of primary keys, foreign keys, and non-clustered indexes to Clustered ColumnStore makes it more of a mature candidate for data warehousing tables. Also, our department may be implementing...

Has anyone confirmed this works with SSMS and know what steps are needed for the client side connection?

How to configure SSL encryption in SQL Server

https://www.mssqltips.com/sqlservertip/3299/how-to-configure-ssl-encryption-in-sql-server/

I'd be more wary of fresh interns and fly by night contractors than I would consultants.

ODBC is just the provider library. OLEDB is another option, but I guess you're really asking about how to setup a linked server, for querying Oracle within SQL Server.

To create...

Where does optional SSL encryption fit into this picture? Does anyone here use this?

https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx

andrew gothard (3/29/2016)

---

Eric M Russell (3/29/2016)

---

If management measures developer productivity by the daily average number of lines coded and unit tested, then that obviously influences how aggressively you would use...

Ask them what monitoring tools they use: SQLSentry, RedGate SQL Monitor, etc. They should also provide you with regular status reports and visibility into the monitoring logs.

If management measures developer productivity by the daily average number of lines coded and unit tested, then that obviously influences how aggressively you would use line breaks. 😎

Setting the upper limit on a VarChar(X) column is a form of logical constraint where X is the maximum length of data that a user would correctly supply. It's sort...