I can understand deficits in terms of SSMS giving visibility but SYS.objects and INFORMATION_SCHEMA. ROUTINES identify them pretty clearly and also reveal lineage.

I'm reluctant to condemn any weapon in my...

Steve Jones - SSC Editor (4/14/2016)

---

Agile isn't about just coding whatever. Many of the successful projects are engineered well, with thought about what they will do, and won't do,...

I've spent a lot of time analysing project failures.

It boils down to breakdowns in communication and failure to check that communication has been successful.

Requirements are given and received. Both...

The value I got out of the original SQL Server 6.5 courses (admin & developer) was largely due to the trainer who was 26 but looked 46. He'd been...

There are still systems in common use out there with surprisingly short length naming restrictions. I seem to remember that there is something like an ANAME record for Linux...

Consistency is all otherwise it will be hell for all.

Trying to remember the CustomerNumber, AccNo, PersonId and any number of alternatives actually store the same thing until one day they...

Situations change over time.

I'd like to work in Canada but I'm reaching the age where emigrating from the UK would be far harder than doing so in my 20s.

With the...

Steve your last April Fool was for SQL Server on Linux!

If you can imagine it then it can be built

I've used it for trivial tasks. Have I got the wrong end of the stick in thinking of it as Bash for Windows but with access to the .Net...

I used to work for a web company that was proud of it's triple AAA usability designs. They allowed for visual impairments, cognitive difficulties, mobility disabilities etc.

Arthritis is a...

I wish SQL Server had the option to support multifactorial authentication.

I know later editions of Active Directory support it but that presumes Windows only authentication.

As to the comment about Microsoft's...

I can't pretend to know vast amounts about replication but a group of us spent a lot of time working out how it worked, how to diagnose and rectify faults,...

I'm a little hazy on the huge cost detraction. To an individual the size of the hardware and software licencing may look huge. To a company that setup...

Amazon don't allow SA access to RDS instances. If you are planning to query an instance over the Internet I'd expect VPN access and SQL Server in a ...

I'm in my early 50s, just getting back to working full-time in IT after separating from my husband. I have 2 big black "X"s already. I'm over 50...