2021-11-17
8,432 reads
Articles
Getting In A State Using Flyway
Flyway Teams baseline migration scripts are a simple and fast way to deploy new copies of a database, at a specific version, for testing work, or to create a new branch during development.
2021-11-17
Introduction to SQL Server sequence objects
SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set up and use sequence objects.
2021-11-17
Easily Integrate with Any RESTful API Using the CData API Driver
The evolution of APIs has opened up exciting opportunities for businesses. RESTful APIs are a consistent, straightforward way that enables businesses to work with external data and offer access to their own data. In May 2021, the number of public APIs grew beyond 24,000, with about 2,000 APIs added just since 2019. APIs continue to be beneficial to businesses and developers, and with the CData API Driver, it […]
2021-11-15
1,296 reads
SQL Server Row-Level Security: A Comparison with Gallium Data
A quick look at how the native SQL Server Row-Level Security compares with Gallium Data's solution for limiting access to rows of data.
2021-11-15
3,206 reads
SQL Server Database Stuck in Restoring Stat
In this tip we look at different reasons why a SQL Server database will be in a restoring state and things that can be done to access the database.
2021-11-15
What we learned at PASS Data Community Summit
Join Steve Jones, Kathi Kellenberger and Grant Fritchey as they each reveal their highlights, learnings and key takeaways from their 2021 Summit experience.
2021-11-15
A brief history of SSIS evolution
Learn about the history and different versions of Integration Services (SSIS) in SQL Server.
2021-11-12
9,943 reads
SQL Access to Redis Data
Traditionally, importing key-value data stores such as Redis into BI, reporting, and ETL tools is problematic, if not impossible. With the CData Drivers, there are several different ways to building a traditional database model to easily work with Redis data in the BI, reporting, ETL, and custom applications of your choice. In this article, we discuss […]
2021-11-12
1,793 reads
DBAs at work #1: The IT services provider DBA
Our series of ‘DBAs at work’ blog posts feature conversations with IT leaders and experts about the challenges of managing and monitoring their server estates. Episode 1 features Dennis Heitmann, Database Administrator at Atruvia, which provides IT services for banking clients in Germany.
2021-11-12
1,017 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers