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/

The best way to load a dictionary of 300k words is store it as an Access file and download it. You can index the local file and query it quickly.

Is...

TomThomson (12/12/2015)

---

Not a survey placed on the SQLServerCentral.com...

ThomasRushton (12/11/2015)

---

#10? Really? Why not just...

julienchappel 38298 (12/13/2015)

---

Hi Steve,

Which is your right piece of code:

A./

CREATE TABLE MyTable

( myid ID

, myFS varbinary(max) FILESTREAM

);

go FROM THE SQLServerCentral.com <subscriptions@sqlservercentral.com>

OR

CREATE TABLE MyTable

( myid INT

, myFS varbinary(max) FILESTREAM

);

go

from THE...

Take this week's survey. don't look anything up, first thing that comes to mind. Be serious, not silly.

https://www.surveymonkey.com/r/JGFCKDW

David.Poole (12/11/2015)

---

Given that data is committed in an operational system and that commitment process plays no part in the confirmation of delivery to the reporting process I'd say that eventual...

Search automatic restore, or restore all files here. Lots of scripts that you can use or might help you with a base to modify.

ID is probably a bad idea. I was thinking a UDDT, but I should have left is as an INT.

Changed.