ThomasRushton (12/15/2015)

---

ThomasRushton (12/15/2015)

---

Steve Jones - SSC Editor (12/14/2015)

---

Any of you see the Advent of Code?

http://adventofcode.com/

I've been solving them in Python and PoSh, practicing some code. Thought some of you might...

jevitts (12/15/2015)

---

Great thoughts! I'd also like to add that the SQL Server certifications are an excellent way to gain exposure to technologies that you may not have an opportunity/desire to...

roger.plowman (12/15/2015)

---

It's all very well to say you should keep up with changing SQL Server stuff, but the reality for many of us is our companies either refuse to replace...

Nope. Sounds like lots of...

Gary Varga (12/15/2015)

---

I sometimes hear people say that the new features in the particular technology that they use is not appropriate for their area of work. I tend to think...

Yet Another DBA (12/15/2015)

---

Unfortunately too many companies see frequent job changes as detrimental. I cant remember which of the forums veterans it was who made the comment that a short...

Snow day!

I'll say that I think Access v SQL is highly dependent on what you do. If you're doing word by word, the round trips, and load on the server might...

Any of you see the Advent of Code?

http://adventofcode.com/

I've been solving them in Python and PoSh, practicing some code. Thought some of you might have fun doing this in T-SQL as...

Jack Corbett (12/14/2015)

---

rodjkidd (12/13/2015)

---

Hey Grant,

I have a ticket for Marillion in Boston Friday Nov 4th. 🙂

It's a early show - doors at 6.

I then have one for New...

xsevensinzx (12/11/2015)

---

Personally, I look at this problem as the same way I do when doing any ETL development. You must verify consistency before moving on.

In the classic data warehouse ->...

David.Poole (12/14/2015)

---

Sadly it is on the job training at best.

When Windows was riddled with buffer overrun vulnerabilities I hunted high and low for a good article on "how not to...

RonKyle (12/13/2015)

---

It might be helpful to know when we should be concerned about this. Presumably most everyone knows about SQL injection. But is writing an ordinary select statement...

roger.plowman (12/14/2015)

---

The editorial mentions revoking and reissuing keys for TDE.

To my knowledge that isn't possible. It's not like message exchange, when you encrypt the whole disk you're talking about...

Start building scripts: http://powershell.com/cs/forums/t/19301.aspx

Some ideas:

http://blogs.technet.com/b/heyscriptingguy/archive/2010/11/03/use-powershell-to-change-sql-server-s-service-accounts.aspx

http://stefanteixeira.com/2015/09/01/automating-sqlserver-config-with-powershell-wmi/

https://www.mssqltips.com/sqlservertip/2358/using-powershell-to-pull-sql-server-services-configuration-information/