Configure SQL Server Database Mirroring: Step By Step
Database Mirroring in SQL Server is deployed as a method to increase the availability of a SQL Server database in...
2016-04-05 (first published: 2016-03-25)
97,633 reads
SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
SQL Server Community Activities under Surat User Group
I am very pleased to announce that I will be speaking about SQL Server Storage Structure, Level 100 session on...
2016-01-20
346 reads
Blog Roll - List of blog post and script contribution
Greetings of the day!!
I am getting frequent emails with questions why I do not write as often I used to...
2016-01-11
502 reads
SQL Server GEEKS Annual summit 2015
Last month, I have requested my manager for an approval so that I can attend SQL Server Geeks Annual Summit...
2015-08-02
689 reads
SSAS– Resolving target machine actively refused
I always wanted to have my hands on SSAS, SSIS and SSRS as I always feel short-hand in these areas....
2013-11-08
980 reads
SQL Server–Security Risk Assessment PMP Way
Recently I had a chance to speak my friend Ashish Sharma who is my colleague too. We were discussing Project...
2013-11-02
1,176 reads
MSDB– cleanup is necessary
Recently I have been asked to work on the task which is to reduce the size of MSDB database. The...
2013-10-21
988 reads
Not so good news for MCM Aspirants
Few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification,...
2013-09-05
746 reads
SSRS – Download all RDL files from Report Server in one go.
Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...
2013-08-07
1,251 reads
How to collect cluster Information using TSQL
Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating...
2013-04-29
1,897 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
FARE LABS Pvt. Ltd. is a Proficiency testing laboratory located in India.
The top proficiency testing facility in India is Fare Labs. We employ particular metrics...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
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