In this series of tips we will introduce PowerShell scripts with T-SQL code that can be used to monitor your SQL Server environment. This first set of scripts creates the core objects needed for this solution.
2020-07-07
Running SQL Server in a container may seem daunting at first, but it’s easy once you understand the handful of commands needed. In this article, Robert Cain demonstrates how to run SQL Server in a Docker container on Ubuntu.
2020-07-06
How well do the SQL Server licenses you own match up with what you need for your current use? William Durkin explains how to use SQL Monitor to find out.
2020-07-06
In this article we cover some things you should consider when determining whether to use Azure Data Factory, SSIS or Azure Databricks.
2020-07-03
Monitoring should be able to happen no matter where you are located. This year organizations around the globe had to adapt to many new challenges including a distributed workforce and managing their estate when they can’t be in the office. This blog outlines the reasons and benefits of adopting remote monitoring.
2020-07-03
SQL Monitor 10.1 now gives you a comprehensive overview of your SQL Server licensing, so you know which licenses are in use, and which versions are on which servers. This simplifies license auditing and lets you unearth misconfigurations that could potentially cost you money. The new version also integrates with Microsoft Teams and Splunk, and supports complex Active Directory environments.
2020-07-02
Because of its many roles, tempdb is the source of performance issues in SQL Server, and there are recommended configuration changes to mitigate this. In this article, Fabiano Amorim demonstrates another issue with tempdb performance that you probably didn’t know about.
2020-07-02
Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly in the financial, business, education, government and healthcare industries. Learn about how DbDefence performs SQL Server Data Masking as a portion of a three pronged approach to protect your data.
2020-07-01
This July we're taking Redgate Streamed down under, bringing together expert industry speakers from Australia and New Zealand for a full day of online sessions, knowledge sharing and networking.
2020-06-30
Learn about the concept of views in SQL, and how they work. Read on to see clear examples of how to implement views.
2020-06-30
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers