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

When creating a non-clustered index, each covered column is sorted in ascending order by default, but you can specify optional DESC (decending) or ASC (ascending) keyword following a column's name.

It's important for a software tool, especially a database management tool like SSMS or VS, to provide a visual queue that environmental context has changed. I believe we've all experienced...

Clean SQL runs better for the same reason that a clean car runs better. It's simply that those same developers who take time to format their code in a meaningful...