Top ADO.Net Interview and General FAQs
1. What is ADO.Net?
ADO.Net is set of components (classes) that are used to access data based on disconnected dataset and XML.It...
2014-09-04
1,280 reads
Audit Webinar Tomorrow (4 September 2014)
I will be given a webinar on how to audit SQL Server through MSSQLTips.com.
Webinar Registration Link
The abstract:
Don’t become a statistic....
2014-09-03
507 reads
Off to Flowcon 2014
With all of the work on a deployment pipeline and Continuous Integration (CI) and Continuous Delivery (CD) I’ve worked on,...
2014-09-03
812 reads
Left or Right?
No, this is not about politics. It’s about your WHERE clause… and your JOIN criteria… and your HAVING clause. It’s about a...
2014-09-08 (first published: 2014-09-03)
6,775 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
3,052 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
789 reads
PASS Summit 2014 Announcements
In case you do not receive the PASS connector, here are some announcements for this year’s summit on Nov 3rd...
2014-09-03
818 reads
Restoring Toggle Results Window as Ctrl+R in SSMS
Recent versions of SQL Server Management Studio have unmapped Control+R as the toggle for the Results window in a typical...
2014-09-03
1,875 reads
4 Things I Wish I Knew Sooner
I was recently called out by Tim Costello on a blog series started by Mike Walsh. http://www.interworks.com/blogs/tcostello/2014/08/27/4-things-i-wish-i-knew-sooner-bi-consultant
The series calls for...
2014-09-02
1,335 reads
SQLSaturday Orlando Marketing Plan-Part 40
Last week we were at 332, this morning at about the same time we’re at 356. Not bad for a...
2014-09-02
553 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