My first (well second) thought when I saw the announcement was MS was pulling a *long* running April Fools gag...

My third thought was that my old boss (a serious FOSS...

Gah...

I forgot how long it can take to update a VM, especially when you're being stingy (it's only going to be hosting the controller software for my new in-home wifi...

A couple people have commented on this elsewhere, but what the heck...

https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/

To paraphrase a bit:

Dr. Peter Venkman: This server is headed for a disaster of biblical proportions.

DBA: What do you...

Try explicitly granting the service account Full Control to the folder on the new drive, rather than the root of the drive. I believe, even if a login has...

I'll shoot the concierge an e-mail tonight. At the moment, I'm just trying to get a rough idea as to the price, so I can look at budgeting for...

WayneS (3/4/2016)

---

jasona.work (3/4/2016)

---

I suppose I could toss this question into it's own topic, but meh...

To anyone who has gone on any of the previous SQL Cruises, if you brought your...

gijs.wuyts (3/4/2016)

---

thanks for the many answers. I will try that backup method first

My goal is to run a query to extrqct the data that I need, and use this...

I suppose I could toss this question into it's own topic, but meh...

To anyone who has gone on any of the previous SQL Cruises, if you brought your SO along,...

ThomasRushton (3/2/2016)

---

At the last place, I put a seconds-to-end-of-contract countdown in my PowerShell prompt.

$([Convert]::ToInt32(([datetime]'2016-01-08 16:30' - (get-date)).duration().TotalSeconds))

That was the latest in my stream of various countdown apps. Previously I'd...

Ed Wagner (3/1/2016)

---

Alan.B (3/1/2016)

---

jasona.work (3/1/2016)

---

Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...

Hmm, using DD makes it seem so far away, lets try WEEK...

That's a...

Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...

Hmm, using DD makes it seem so far away, lets try WEEK...

That's a little better...

How about MM?

There...

Correct. Devs get Public and nothing else at...

Yeah,...

So, did some quick-n-dirty testing this evening, and it looks like the same things that don't work when managing a SQL2012 install with SSMS 2008R2, don't work with SSMS 2012...

It's always fun to find ways to use SQL features you never thought about before...

/best Keaneu Reeves as Neo voice

I know OVER (PARTITION BY now...

😀

We're keeping the option of moving...