Moving MSDB to new location
In recent past we have a situation where in we required to move MSDB, Model and Master databases to new...
2012-03-06
883 reads
SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
Register for SQL Server 2012 Virtual Launch
`As we all are aware SQL Server 2012 virtual launch is scheduled after 60 hours roughly. Earlier I have discussed...
2012-03-05
603 reads
Download free eBook for SQL Server 2012
Microsoft has released one more free eBook, this time it is on SQL Server 2012. However, this is the second...
2012-02-29
3,581 reads
When DBCC INPUTBUFFER disappoints
Today we have an alert from one of the client server about blocking, I have immediately start looking at it...
2012-01-30
1,733 reads
Rebuild System Databases
Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation...
2012-01-29
3,429 reads
Revamping SUG 2nd Meeting
Friends,
Last Saturday, 21st we have 2nd meeting of SUG members and this time we made progress – I, Vinay and Matang...
2012-01-23
610 reads
Roles and Responsibilty of SQL Server DBA
What is a role of a DBA in an organization?What are the daily activities of a DBA?What shall I check...
2012-01-01
754 reads
2011-12-31
What’s new in SQL Server RC0 setup
Datacentre Edition is no longer available as a MS SQL Server 2012 RC0 candidate, Read MoreMS SQL Server 2012 RC0...
2011-12-28
723 reads
Revamping Surat User Group
Dear Friends, we had a user group meeting last week – I and Vinay Pugalia was here. We have discussed many...
2011-12-26
598 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