Midlands PASS July Meeting – July 10
The Midlands PASS Chapter will hold its next meeting on July 10. We meet at MicroStaff IT in Cayce, SC....
2014-07-03
464 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
PASS Summit Session Selection
Let’s make it democratic. Let’s ensure we get solid sessions from key people. And let’s save a ton of work...
2014-06-27
1,281 reads
What is an “operational” DBA?
On Facebook last night, I posted the following:
An operational DBA isn’t just a manager of a traditional RDBMS, transactional system....
2014-06-27
5,287 reads
“A good DBA is a lazy DBA”
I’m borrowing from Andy Leonard (blog | twitter) who says all the time, “Good engineers are lazy.”
If you’re thinking, “Why would I want (to...
2014-06-25
1,958 reads
Service Packs coming for SQL Server 2008/2008 R2
I’m not prophetic, I promise. However, some good news on the service pack front with regards to SQL Server 2008...
2014-06-02 (first published: 2014-05-30)
3,057 reads
Do you apply SQL Server Cumulative Updates?
I think Steve Jones makes a great point here with respect to cumulative updates:
“This is one reason I’ve been hesitant...
2014-05-30 (first published: 2014-05-28)
6,876 reads
Minimize permissions for file locations
When we talk about security, we often point to the Point of Least Privilege. I write a lot about applying...
2014-05-23 (first published: 2014-05-16)
1,743 reads
The Scary DBA Comes to Columbia, SC
*sound of glass crashing* *cue theme music*
(in a wrestling announcer’s shocked voice) “It can’t be! He’s not supposed to be...
2014-05-09
698 reads
Understanding the Three A’s of Security for SQL Server
Do you know what the “Three A’s of Security” are and how they apply to Microsoft SQL Server? Let’s look...
2014-05-01 (first published: 2014-04-22)
7,367 reads
Encrypt usernames and passwords stored in files
I was looking at a product recently and came across a rather unpleasant surprise: the install instructions specified that I...
2014-04-02
3,379 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