Automate Yourself to a Coffee Break
A DBA should be working to automate their tasks, and find time to do things that are really important. Like keeping their coffee cup topped off 🙂
Premature Optimisation
Learning how to tune a system is a bit of science and a bit of an art. Gail Shaw gives some guidelines on when you might want to tune and how to go about it so as not to unnecessarily undertake the effort.
Watson Freemium
IBM has released a free version of its Watson service to help people perform analytics on their data.
Prevent Confidential Data at the Application Layer from getting into SQL Server
In this tip Tim Smith looks at different approaches to stop confidential data from getting into the database.
Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets
SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".
No Compelling Reason
Steve Jones wants to know if you have compelling reasons to upgrade or not upgrade this week.
A TDD Journey: 3- Mocks vs. Stubs; Test Frameworks; Assertions; ReSharper Accelerators
Test-Driven Development (TDD) involves the repetition of a very short development cycle that begins with an initially-failing test that defines the required functionality, and ends with producing the minimum amount of code to pass that test, and finally refactoring the new code. Michael Sorens continues his introduction to TDD by implementing the first tests and introducing the topics of Test doubles; Test Runners, Constraints and Assertions.
Data Mining Part 17: Working with Reports
In this chapter, we will learn how to create Data Mining Reports using Reporting Services.
Data Mining Part 17: Working with Reports
In this chapter, we will learn how to create Data Mining Reports using Reporting Services.
The 10 (.5) Commandments for IT Professionals
A list of the commandments, or at least suggestions, that Simon Holzman sees as important for IT professionals.
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers