SQL Prompt's new command palette provides a fast way to navigate the tool's functionality via a single keyboard shortcut: ALT+S. Phil Factor explains how you can use the command palette to find and execute SQL Prompt functionality and common SSMS commands, as well as search for database objects.
2022-03-11
To return detail data using DAX, use the table functions. Adam Aspin covers UNION, EXCEPT, INTERSECT, and CALCULATETABLE in this article.
2022-03-09
Managing your entire SQL Server estate, on premises, in the cloud or a hybrid, with instant problem diagnosis, intelligent and customizable alerting has never been more vital. Discover how Redgate’s SQL Monitor enables all this from a single pane of glass.
2022-03-09
Learn how to use Azure Data Studio to access a Central Management Server.
2022-03-07
2,509 reads
Describing a route from a basic, 'managed' system of database development to use of branching and merging and CI, using Flyway. By taking these steps, you'll reduce development conflicts, lift testing restrictions, and the organization will have much more flexibility on the release of features and bugfixes.
2022-03-07
In this article we cover situations where using a loop in T-SQL to process data for time series analysis is beneficial to get the desired results.
2022-03-07
This article looks at the way in which you can convert unmanaged devices to the ASM filter drive in an Oracle system.
2022-03-04
3,778 reads
You can perform PostgreSQL backups with the pg_dump command. In this article, Grant Fritchey explains how to back up and restore with the pg_dump and pg_restore utilities.
2022-03-04
With our four dedicated development teams, weekly updates and a commitment to listening to your feedback, SQL Monitor keeps getting better and better! If you haven't looked at it for a while, you might just be pleasantly surprised with how far it has come and how it can help your team work smarter. Take a look at the key features - and benefits - we've added since 2018 in this interactive infographic.
2022-03-04
While analyzing SQL Server's network protocol, I came across a weird fact: when a database client logs in using SQL Server authentication (as opposed to Windows authentication), it has to send the user's password to the server, in blatant violation of common security guidelines. At first, I couldn't believe it; SQL Server generally does an […]
2022-03-02
5,367 reads
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
I have a measure with totals for specific dates with the LastNonEmpty aggregation, and...
I moved a table from MsSql to Postgresql that had a field defined as...
I tried to find an appropriate forum to post the question. This one seems...
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers