Cross Database Queries in Azure SQL Database
Cross database queries in Azure SQL Database aren't as straightforward as you might think, but they aren't hard to implement. Follow along to learn how to implement them.
2019-07-25
38,274 reads
Articles
Modeling Time
There are those who argue that time doesn’t really exist; it’s just an illusion. That debate won’t keep you from storing and manipulating dates and time in SQL Server. In this article, Joe Celko discusses some of the many ways that SQL Server treats temporal data types.
2019-07-25
Static Data and Database Builds
Whichever way you wish to ensure that a database, when built, has all the data that will enable it to function properly, there are reasonably simple ways of doing it. Phil Factor explains the alternatives.
2019-07-25
Do you really know what’s happening with your servers?
As estates continue to grow and evolve, SQL Server professionals must continually adapt. But do you really know what’s happening with your servers? Jamie Wallis highlights the 4 key elements that are currently impacting the working life of an IT leader. Find out what they are here.
2019-07-24
How to Enable SQL Server CLR Integration using T-SQL
In this tip we look at how to enable SQL Server Common Runtime Language aka CLR using T-SQL commands.
2019-07-24
2019-07-23
10,623 reads
Data privacy next steps: Compliant Database DevOps
Over the last year we’ve seen a shift in customer concerns around personal data, as well as new legislation. Now is the time to implement a robust process to safeguard your data and your business, without hindering your DevOps journey. Read this blog post to find out the next steps for data privacy.
2019-07-23
Data Transfer Strategies between MongoDB and SQL Server
There are a variety of days to move data between MongoDB and SQL Server. This article covers some of your options and gives you ideas on which method might work best for you.
2019-07-22
14,053 reads
How to find Updated Column in SQL Server Trigger
In this tip we look at how to which columns have been updated when using a SQL Server trigger by using the update and columns_updated functions
2019-07-22
SQL-On-Hadoop: Hive - Part I
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-19 (first published: 2017-07-26)
12,822 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