Hi Joe,

Thanks for the script, it will save a lot of effort when I need to restore a database in the future.

I original got the original from Jason's site. Oops!...

I have tried Microsoft Virtual Academy[/url], which is free which...

I prefer to learn from several different sources depending on how urgent the need is, and how much I already know.

Classroom and workshop based courses are a great...

We can get quite a good price on standard edition licenses, but Enterprise edition is still expensive. Of course, if you want to set up a failover cluster for...

Eric M Russell (1/21/2016)

---

How about a licensing model that simply charges for and caps the number of concurrent connections or non-system session SPIDs without concern for number of cores, distinct...

The PostgresSQL licencing model is nice as well,...

Hi Jason,

One of the things I see regularly (and used to do myself until I realised how expensive it was) is the use of non-deterministic functions in a query. ...

You forgot to mention full disk encryption. Windows 10 Pro comes with Bit-locker which while not great is better than nothing. All of our work laptops are encrypted...

Steve Jones - SSC Editor (10/7/2015)

---

Alex Gay (10/7/2015)

---

I used to work for a hospital that had a clinical letters system written in Clipper, for an XBase file based database, that...

I used to work for a hospital that had a clinical letters system written in Clipper, for an XBase file based database, that was 15-20 years old when replaced with...

Raghavendra Mudugal (11/4/2014)

---

(to my knowledge..) DIR is a DOS command which also can be used in PS without aliasing. Once you connect to the SQLPS use the CD command to...

DIR is an alias. The command behind it is Get-ChildItem.

When I was at school Computer Programmer wasn't even an available career path, and we had no structured Programming course. I remember that we did write a programme to...

Can you explain how to reduce licensing costs for SQL server when virtualizing.

I was told by our software licence supplier, that if we wanted to run SQL Server 2008R2 on...

Thanks for the views and code to generate the index DDL.

While we probably won't automate it, this definitely gives us a starting point to look at indexing.

But for now I'll...