How do you secure the SQL Server instance after enabling xp_cmdshell ?
OR
How do you allow non-administrator to use xp_cmdshell ?
From the day I started working with SQL server, I have heard
about...
2012-03-22
4,559 reads
Blog Posts
March #Meme15 Round-up – Facebook
Are you ready for the round-up of last week’s #meme15 Facebook question?
In total, there were eight participants in this month’s...
2012-03-22
1,019 reads
Restore fails with tail of log error
For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to...
2012-03-22
698 reads
RYO Maintenance Plan – History Cleanup
The last step in our campaign to rid the world of maintenance plans deals with housekeeping: the history cleanup step....
2012-03-22
999 reads
2012-03-22
34 reads
SQL Server 2012 Unattended Installation on Windows Server 8
In part 5 will install SQL Server 2012 on 3 Windows Server 8 VM’s using GUI and unattended installation to...
2012-03-22
1,120 reads
2012-03-22
5 reads
2012-03-22
6 reads
2012-03-22
12 reads
Choosing the Right Microsoft Reporting Technology Part 3: PowerPivot
Today I’ll be continuing in a blog series designed to help you decide which presentation tool is best for your...
2012-03-21 (first published: 2012-03-16)
2,954 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...
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