SQL Server 2012 (“Denali”): Installing on a Virtual Machine
With CTP3 for SQL Server 2012 (code name of “Denali”) available, a lot of us want to play with all the new...
2011-09-14
1,653 reads
With CTP3 for SQL Server 2012 (code name of “Denali”) available, a lot of us want to play with all the new...
2011-09-14
1,653 reads
As a SQL Server DBA, usually the largest databases in size and in number of users that I had to manage was an ERP...
2011-09-12
835 reads
I was having a problem getting the display folder to work for a calculation in SSAS. Turns out, it will...
2011-09-09
1,385 reads
Over the years, I have accumulated a set of questions that I usually ask the placement firm about a contract position...
2011-09-07
1,165 reads
Because the relationship between application development and the IT operations teams is critical, Microsoft has released a CTP of a new...
2011-09-06
1,092 reads
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am...
2011-09-02
1,418 reads
A couple of times over the past few months, while in Visual Studio 2008 working on an SSIS package, I went...
2011-08-31
2,166 reads
When doing ETL, you have the choice of using T-SQL or SSIS. What things should you consider when deciding which...
2011-08-29
10,256 reads
Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server...
2011-08-26
3,846 reads
This is a bit off-topic, but I wanted to mention a great tool for beginners to learn how to program. ...
2011-08-24
2,065 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
WA:0821-4447-7715 Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2 No. 1, RT.10/RW.8, Pusaka...
WhatsApp:0821-8154-398 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat 45111
WhatsApp:0821-8154-398 Jl. Inspeksi Kav. PTB Blok A 2 No. 2 C-D, RT.1/RW.4, Pd. Klp.,...
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