Error 8117 appears when you SUM a BIT column, because bit is invalid for sum operator. I reproduce it with a small table and show a simple workaround.
SQLAuthority News – Learning Never Ends – Becoming Student Again
Learning should never stop. Visiting a friend’s new training center got me thinking about Becoming Student again, and why I keep learning even from old material.
SQL SERVER – Beginning of SQL Server Security
The beginning of SQL Server security: how authentication, logins, users and permissions work together to keep your data safe from misuse.
SQL SERVER – 5 Videos from Joes 2 Pros Series Exam Prep Series 70-433 – SQL in Sixty Seconds
Five short videos from the Joes 2 Pros series for Exam 70-433, starting with SQL Server security basics: securables, principals and permissions.
What Distributed SQL Means and What It Costs
Understand distributed SQL through data placement, compute and storage roles, write coordination, and the latency and operating costs behind scale.
What Is a Cursor in SQL Server, and When to Avoid One
A cursor in SQL Server took 260 milliseconds where one SELECT took 4. Why the gap exists, how to turn a loop back into a set, and the three cases where a cursor really is the right answer.
Upcoming Birthdays in the Next 30 Days With T-SQL
Find upcoming birthdays with T-SQL across year boundaries, choose a February 29 policy, and build a clear next-30-days list.