Toshiba Satellite C655-S5503 Review
If you are “in computers” according to your family and friends, you are typically expected to provide lifetime, free tech...
2012-04-04
1,509 reads
The first blog post….
Daunting! By way of introduction, I’m Mat This blog is mostly for myself, to document what I know and maybe...
2012-04-03
605 reads
Oracle Tips for MSBI Devs #4: Executing an Oracle Stored Proc with IN Parameters in SSIS Execute SQL Task
The first tip I published discussed how to execute an Oracle procedure with no parameters. In this tip, I will...
2012-04-03
744 reads
Powershell – Validating an IP Address
A task that I have had to do several times over the years is determine if an IP Address string...
2012-04-03
4,191 reads
Why an employer should never ask about accessing your Facebook page
There's a brilliant piece of work posted as a fictitious resignation letter that gives some scenarios as to why an employer could...
2012-04-03
1,358 reads
Which product was purchased the most? T-SQL
Suppose you had a list of product sales and were curious about which one was sold the most? It’s a...
2012-04-02
9,420 reads
Execution Plans – Table, Clustered Index and Non-Clustered Index Scan
An important operator to understand in execution plans is a scan. A Scan can be good and bad, so understanding...
2012-04-02
4,326 reads
Unsupported Features in Excel Services SharePoint 2010
Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced. There still remains a...
2012-04-02
1,494 reads
Why you *can't* provide your Facebook credentials
I know this isn't related to SQL Server, but it is related to security and privacy.
If an employer or...
2012-04-02
2,398 reads
Mirroring Support for SharePoint 2010 Databases
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are...
2012-04-02
1,234 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