The Hybrid Cloud: Having your Cake
With a hybrid cloud, can you get the freedom and flexibility of a public cloud with the security and bandwidth of a private cloud? Robert Sheldon explains all the ins and outs.
One System to Rule Them All
Can a single piece of software work well for most situations? Steve Jones wonders if we're not attacking the problems of large software applications in the right way.
Automating SQL Server Agent Notification
This article looks at some automated approaches of monitoring SQL Server agent jobs.
Data Mining: Part 13 Powershell
In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.
Data Mining: Part 13 Powershell
In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.
The Brittleness of Replication
Replication is a great feature in SQL Server, but it seems brittle. When things go wrong, they break quickly, and often severely. It seems that we have many features like this in SQL Server that are useful and handy, but receive very little attention as versions are released.
Adding Custom Reports to SQL Server Management Studio
In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio.
SQL Saturday #320 - Raleigh, NC
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. The Triangle SQL Server user group (http://www.tripass.org) of Raleigh, NC is hosting this event on September 6, 2014. Register while space is available.
Data is Not Always Enough
More data is better, but Steve Jones notes that even that isn't always enough to make decisions count for your organization.
Verify SQL Backup Integrity
Perform automated database restores and check the integrity of your backup files
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