Communication is at the heart of DevOps, but it can be difficult to achieve. Mike Cuppett explains how to improve DevOps communication clarity.… Read more
When I was a DBA responsible for 40 to 50 SQL Server instances, I didn’t have many third-party tools to help me do my job. I remember that I was able to buy a tool to compress database backups before that functionality was built into SQL Server. I also had a handful of licenses for … Read more
Since Microsoft discontinued their cloud-based load testing services, developers need a new way to test applications. Julio Sampaio demonstrates how use one solution, JMeter.… Read more
I’ve noticed that some television shows have been incorporating the Covid-19 pandemic into their recent episodes. (There are some spoilers here, so read with caution!) A medical series, “The Good Doctor,” featured it in two episodes and then, magically, the pandemic was over. The popular series “This is Us” is trying to set a good … Read more
Out-of-control tempdb growth must be managed to keep the server running. Monica Rathbun gives her strategy to handle unexpected tempdb growth. … Read more
Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database level object that allows you to provide an alternative name for another database object such as a view, user defined table, scalar function, stored procedure, inline table valued function (tvf), or extended stored procedure. They can also be … Read more
Lean software development means delivering applications efficiently and fast. Robert Sheldon discussions the business value of lean software development.
… Read more
Recently, the editor of SQLServerCentral.com, Steve Jones, shared a video in our team Slack channel that talked about how you shouldn’t feel like an imposter when you get out of your comfort zone. It talked about how incredibly successful people didn’t know how to do what they eventually accomplished back when they started. For example, … Read more
This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a SQL execution plan for software design.… Read more
Understanding SQL Server security is a critical skill. Greg Larsen explains SQL Server authentication methods, logins, and database users in this article.… Read more