Countdown to PASS Summit 2012 – 9 to Go – My First Summit
We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to...
2012-10-28
589 reads
DataOnWheels
Using Word 2013 to Create Blog Entries
Over the past few years, I have used Windows Live Writer to create my blog entries on WordPress. Given the...
2012-10-26
2,788 reads
X-XMLA: vii. Partition Management with XMLA
In the 7th article of this series, I will discuss how to manage your partitions with XMLA. We will be...
2012-10-10
641 reads
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012...
2012-09-26
900 reads
X-XMLA: vi. Processing and Out-of-Line Bindings in XMLA
In this post, I will progressively go through processing a partition from full process, to incremental process, and finally to...
2012-09-19
801 reads
SQL Saturday #149 and CodeMastery–Minnesota Events
We are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference...
2012-09-18
525 reads
Windows 8 and Hyper-V: It’s that easy!
First, I need to set the record straight – I am not a systems guy. When I need work done to...
2012-08-30
1,363 reads
#meme15: Reasons I Like My Job
When Jason ( B | T ) posted this assignment, I thought it would be a fun topic to write on. Before I...
2012-08-15
508 reads
Upcoming BI and Data Events with Magenic in Fall 2012
As I started looking over my event calendar, I was amazed at how many events Magenic is sponsoring, hosting or...
2012-08-14
561 reads
O, There’s the Data: Using OData in SSIS
The Open Data Protocol (OData) is an open specification created Microsoft to enable exposing data in a standard way from...
2012-07-23
1,283 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers