MORE ABOUT ME

server Tag

If you were given the chance to build the ultimate server, what would you draft first? ...

For years I have found myself often needing these three pieces of information with regards to SQL Server:When was the last time the server was restarted?When was the last time the SQL instance was restarted?When was the last time the SQL Server wait stats were cleared?If the server itself is restarted, then the...

One thing I have noticed in all my years as a data professional: few users understand (or care) how far away they are from their data. Quite often they expect instant results from their queries despite there currently being an upper bound due to things like network bandwidth, the speed...

Performance tuning is hard. Everyone knows that.Has anyone ever tried to figure out why?Sure, there's that big old "it depends" that gets tossed about. Look, at the end of the day you only have so many possible resource bottlenecks: disk, memory, CPU, and network. I don't care if you are...

Last week I was reminded that opinions are split as to whether or not installing the database client tools (SSMS, Database Control, etc.) onto database servers is a good idea or not.I've worked at companies where the installation of such tools was discouraged. I've also known companies where the installation...