In this article we will look at Azure Boards which is hosted by the Azure DevOps Service and offers a cost-effective, customized and interactive process for planning, tracking and managing your projects.
Downtime is costly and directly impacts the business with lost productivity and sales. As SQL Server DBAs we have a number of responsibilities, one of which is to ensure the uptime of our databases. Unfortunately, resolving database corruption...
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them...
I am new to SQL Server and want to learn about the JOIN options. What are all of the JOIN options in SQL Server? What is the significance of each of the options? I am a little confused on the differences and syntax, can you provide some examples?
Sometimes you may have issues connecting to SQL Server and you may get messages such as could not open a connection to SQL Server. In this tip we look at different things you can check to resolve this issue.
My team needs to manage hundreds, if not thousands of scheduled processes that run against my environment with numerous versions and editions of SQL Server including Express. How can we manage the processes more efficiently?
Our company’s entire IT infrastructure is growing rapidly, but our SQL Server environment is growing exponentially faster. My team needs to make sure we have consistency across our SQL Server instances.