Connecting to SSIS 2008 Without Local Admin
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
56 reads
Gavin Draper
SQL Server Development Permissions
After setting up a new SQL Server instance for development I found the following permissions were needed extra permissions were...
2013-03-21
53 reads
Self Hosting WCF Services With Transport Security
When developing and debugging transport security WCF services it’s a real pain if each developer on the team needs to...
2013-03-15
202 reads
Configuring/Authenticating with Identity Server in C#
In my previous post I walked through configuring ADFS and writing a small C# console app to authenticate with it...
2013-02-06
520 reads
AD FS Token Based Authentication In Code
I’m writing this post more as documentation for myself as I know I will be repeating this process quite a...
2013-01-31
423 reads
MVVM Page Navigation Using MVVM Light On WP7
Page navigation can be a pain to achieve in a true MVVM way, I recently ran in to this problem...
2013-01-14
82 reads
SQL Availability Groups VM Sandbox Step By Step
In this post I am going to walk you through creating a virtual environment from the ground up to play...
2012-11-19
53 reads
Automated Disk Space Alerts For Windows Server
PowerShell Style
I recently needed to automate disk alerts for each of our servers, to keep it simple I wrote a...
2012-09-22
113 reads
C# Explicit Interface Implementation
In C# it is possible to write classes that implement an interface but only show the methods of the interface...
2012-06-07
43 reads
SQL Server Service Broker Explained
What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.
What are message queues?
Message queues are a...
2012-06-03
202 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
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...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
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