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
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
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
Azure SQL Database has been around for over ten years and is constantly evolving with new capabilities and options. Dennes Torres explains 8 features and best practices of Azure SQL Database.
2022-03-02
SQLBits is back online and in-person from March 8-12 and this year they’re taking us all to the Arcade! Register to get access to our exclusive pre-con and conference sessions run by Grant Fritchey, Kathi Kellenberger, and Steve Jones, as they talk database. And get a 10% discount code when you register using REDGATE274.
2022-03-02
Continuous Compliance Automation aims strike a balance between baking compliance requirements into daily operations, and business demands for speed and agility. Redgate's Security Lead, will be joined by a panel of peers to discuss this mindset change and the impact it can have on your organization.
2022-02-28
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Comments posted to this topic are about the item BIT_COUNT() V
Comments posted to this topic are about the item How We Reduced SQL Server...
Comments posted to this topic are about the item An Eventual Consistency Scam
What does this return on SQL Server 2025?
select bit_count(null)See possible answers