They reimage the system regularly, and I've had some flakiness. My guess is...

Miles Neale (2/7/2013)

---

Back in 1975 IBM or one of it's team unofficially stated it would take a two story computer the size of the state of Texas to replicate the...

I think they've moved to tags instead of categories, which I like. That's one thing I'd liket o have here.

I sent this to a few people, but anyone with comments on this platform, please feel free to post them. I've set up a forum here for feedback, comments, discussion,...

Miles Neale (2/6/2013)

---

It has been said that every picture tells a story. Well every picture can tell many stories depending on the perspective of the viewer/teller. Our data...

AFAIK, every physical core/CPU in a server has to be licensed if SQL Server can use it, even potentially. The affinity mask doesn't count here. I assume that for VMs,...

Show off

A couple things: AlwaysOn is Enterprise only. I forgot about that, so your read only replica is going to be core licensed if you go that route.

For replication, it doesn't...

This should help:

SELECT T1.Name AS DatabaseName,

Isnull(Max(T2.recovery_model), 'No Backup Taken') AS recovery_model,

'Log' AS BackupType,

Isnull(CONVERT(VARCHAR(23), CONVERT(DATETIME, Max(T2.backup_finish_date), 131)), '') AS LastBackUpTaken

FROM sys.sysdatabases T1

LEFT...

Miles Neale (2/5/2013)

---

Remember how things work. Bleeding edge -> cutting edge -> early adopters -> the norm -> late bloomers and never made its. There is a cycle....

We've already reported, or at least a few people have. I missed the first practice, but I need to start throwing for sure.

I heard back that you can write powershell scripts to do this, which would make it repeatable, but require development on your part. I'll try to track down a sample...

I'm not sure it does, but it packages things up, so there might be a hack. I'll ask.

Deployment Manager from Red Gate handles some of this. I know there are some open source tools, but I don't know of anything integrated. Since most of these are scriptable,...

gsmith 7350 (2/1/2013)

---

We autochart KPI's on control charts to watch for trends, special causes, etc. . Most of these charts are X-bar with R-charts with control limits calculated to +-...