Miles Neale (9/19/2014)

---

Truth be told I kind of like the preproduction code...

Updatable ColumnStore indexes, in-memory OLTP tables, and Delayed Durability are game changing features for which the SQL Server engineering team should be applauded. However, I still think Microsoft marketing department...

I believe that how Microsoft numbers their version releases should be carefully considered by the marketing department from several different angles. For example, SQL Server 2014 generates a lot of...

Steve Jones - SSC Editor (9/11/2014)

---

Jim P. (9/11/2014)

---

Another thing that you should do is create a portfolio of your accomplishments. That makes it easier to interview. The first section is...

Doctor Who 2 (9/10/2014)

---

...

The first and biggest surprise to me, once I joined the ranks of the unemployed, was when I discovered just how long it takes for anything at...

It is surprising to see someone put PowerShell at the top of the list; maybe because the website is geared toward Windows Server administrators, and Microsoft is phasing out VBScript...

mai.quangvinh (9/9/2014)

---

My colleague who is a dba help me investigate the issue, she found that the destination table has primary key which is a composite index including 3 column and...

Ideally, you don't want to shrink your transaction log, because it's more efficient to re-use the same log. However, 100 GB of logging on a 6 GB table (or 6...

Gotta love the title "Chief Happiness Officer". 🙂

If you are the designated person who is expected to stand in for the role of organizational president, even if it's only required on rare occasions, then you should have...

I didn't build most of the software running this site, but I do think that SQLServerCentral as a total entity is the thing I'm most proud of. I'm not sure...

Using T-SQL to parse EDI records is probably not the best way to accomplish whatever it is you're doing. You would get more useful advice posting this question in a...

That a schema name, not a database name. Coincidentally, your default schema must be the same as your database name.

Perahps most IT development shops in 2014 are in the "Early Industrial Age", where is goal is leveraging tools to crank out a lot of "good enough" code but there...

If sufficient functional requirements are not provided upfront, then all these "fixes" in production are really just change requests and phase I, II, ~ deployments. A solution that has been...