Determine which version of SQL Server is running...
Since the early versions of SQL Server, from version 6.5 we can know and
determine the latest version that we...
2010-03-20
1,073 reads
Blog Posts
Random Thoughts on Aliasing
Here are many different thoughts/facts/preferences on aliasing. Most of this applies to column aliasing. Regardless of whether or not you...
2010-03-20
1,353 reads
Be Wary
We make mistakes when we publish things. It happens, and I am as guilty as some people of mistakenly putting...
2010-03-19
918 reads
Being Involved in the Community
Regular readers know that I enjoy being involved in the SQL Server community. Over the last two and a half...
2010-03-19
342 reads
Licensing SQL Server Reporting Services
I have my license here somewhere, officer.
Licensing models can sometimes make database modeling seem trivial. Per processor or per seat?...
2010-03-19
1,100 reads
Losing Two Days
I’m off tomorrow to the UK for a week of work at the Red Gate offices, and then a couple...
2010-03-19
655 reads
Security Audit
Of late I have seen a lot of questions on how to audit the logins and users on each SQL...
2010-03-19
1,781 reads
SQL Log Shipping – by Abi Chapagai
SQL Server 2008 High Availability Solution: Log Shipping
In SQL Server, transaction log provides an ability to recover a database...
2010-03-19
1,711 reads
SSRS - Formatting Mutiple Columns
Often when designing reports you are required to apply the same formatting to multiple columns in one table or matrix....
2010-03-19
1,575 reads
Tally Table CTE
Now that I have several posts on what you can do with a Tally table, I figured I'd share my...
2010-03-19
5,152 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BCA KCU BENGKULU TLP/WA 08218154374
Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...
ALAMAT BCA KCU BUKITTINGGI TLP/WA 08218154374
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
ALAMAT KANTOR BCA KCU PADANG TLP/WA 08218154374
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
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