What is worse is when people don't clarify their meaning or they don't call the new word into question and blindly except it.

One of the irritating problem with a rockstar...

A Primary Key should not necessarily need to be clustered.

Few developers, and not all the dbas I have worked with actually know what a clustered index is. So for some...

Find someone who does listen and can implement the changes. Which can take many months of many, many small incremental changes.

And keep all the emails about the advice given...

Does Bugger All

Devils Bloody Advocate

jeff.mason (4/26/2016)

---

Microsoft has made SQL Server so big that even "generalists" are usually "specialists". I know of few people who are experts in the DB engine, AND SSAS, AND...

It depends on the company you keep.

One place an MVP I worked with was very impressive on the latches and clerks, but when it cam to disk layout must...

robert.sterbal 56890 (4/19/2016)

---

I'm pretty sure you can buy a service from dropbox to store all of your files and variants for up to a year.

How do I recover previous versions...

Ed Wagner (4/19/2016)

---

Yet Another DBA (4/19/2016)

---

I know from the various contracts that I have signed that if I mentioned anything like we were hacked or had ransom ware I would...

Gary Varga (4/19/2016)

---

bthomson (4/19/2016)

---

join an organization like https://www.infragard.org/ this is a partnership with the FBI. It has chapters in most cities. Supposedly my Houston chapter...

I suppose one problem is if the ransomware sits dormant for a couple of weeks and then activates. A restore from a 2 week? or 5 week old backup would...

I know from the various contracts that I have signed that if I mentioned anything like we were hacked or had ransom ware I would get fired for bringing the...

On the whole I agree as unless you have either worked on a system that has a lot of triggers or have your fingers burnt then they tend to be...

Gary Varga (4/15/2016)

---

Your...

Gary Varga (4/14/2016)

---

Jeff Moden (4/14/2016)

---

...would be interesting to find out what percentage of the world's programmers rely on forums like SSC to actually do their job (sorry, have the job...

The single vs many tempdb files is for me a distraction of where the performance issues tend to be ie the query or the actual design of the database. Most...