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

It should be considered best practice to drop the 'SA' account. However, I still create a MSSQL authenticated account with SYSADMIN membership, because there are a handful of occasions where...

TomThomson (3/28/2016)

---

...

Most stored procedures should fit onto a page (A4 or American letter) - say 60 lines of tex using sensible font. A page and a half or...

You can add db_name() function to the resultset.

exec sp_MSForEachDB

'

USE ?;

if exists

(select table_name...