XP_CmdShell isn’t Evil
Bonus summary: xp_cmdshell is limited to admins, unless you specifically grant permissions to users. And if you’re an admin, you have...
2016-04-14 (first published: 2016-04-09)
1,773 reads
VI Editor Basic Commands
A few months back I came across an instance of using VI Editor. Trust me being a SQL DBA it...
2016-04-09
5,157 reads
VMware CPU Co-Stop and SQL Server Performance (continued)
A number of you sent me some excellent questions about this topic, and my favorite asked me for the query...
2016-04-08
738 reads
Win a SQLBits Pass
You can win a free conference pass to SQL Bits, in Liverpool, May 4-7. It’s easy, just post a review...
2016-04-08
571 reads
SQLCover Code Coverage for SQL Server T-SQL
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage?
Code coverage is a way to see how...
2016-04-13 (first published: 2016-04-08)
4,432 reads
SQLCover Code Coverage for SQL Server T-SQL
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...
2016-04-08
45 reads
SQLCover Code Coverage for SQL Server T-SQL
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...
2016-04-08
56 reads
SQLCover Code Coverage for SQL Server T-SQL
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see how many statements in your database code have been...
2016-04-08
12 reads
MongoDB – Drop database
The dropDatabase command drops the current database, deleting the associated data files.
Different methods to drop database
Method 1:
1. select the database...
2016-04-08
484 reads
Implementing Full-Text Indexes
In my previous blog we saw the Full-Text Index architecture.
http://sqlandmorewithkruti.blogspot.in/2016/04/all-about-searching-full-text-indexes_7.html
In this blog we shall see its implementation. Before you proceed...
2016-04-13 (first published: 2016-04-08)
2,642 reads
Blogs
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...
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