Denali – Day 27: System Center Advisor (aka ‘Atlanta’)
Denali – Day 27: System Center Advisor (aka ‘Atlanta’) As Microsoft is working more on Cloud base system, on that basis...
2012-05-27
1,009 reads
Vinay Thakur
Denali – Day 26: Tool: Power View- Reporting Power View (Aka Crescent)
Denali – Day 26: Tool: Power View -Reporting Power View (Aka Crescent) If you are good with: Xls Pivot table Power...
2012-05-26
1,078 reads
Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
MDS and Best Practice Analyzer new features were introduced in sql...
2012-05-25
704 reads
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Earlier sql server was having diagnoses tool.
Default trace.
SQLDiag
And other tools but could not...
2012-05-24
1,439 reads
Denali – Day 23: Data Quality Services (DQS)
Denali – Day 23: Data Quality Services(DQS)
Data intelligence vs. human intelligence: Sql server RDBMS is a database system which has data...
2012-05-23
1,471 reads
Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
As stated earlier on blog on “LocalDB” discussion, developers are involved...
2012-05-22
906 reads
Denali – Day 21: Security
Denali – Day 21: Security
Security wise Microsoft sql server is going great and on compare with other RDBMS in the market...
2012-05-21
781 reads
Denali – Day 20: More Programmability Feature
Denali – Day 20: More Programmability Feature
Native XML Web Services (SOAP/HTTP endpoints) is Removed:
Earlier version of sql server support Web services...
2012-05-20
933 reads
Denali – Day 19: Programmability Feature -T-Sql
Denali – Day 19: Programmability Feature -T-Sql
ORDER BY .. OFFSET and FETCH :mysql LIMIT (srno ):
OFFSET is a location of the rows...
2012-05-19
1,026 reads
Denali – Day 18: Engine: Express LocalDB–Command line
Denali – Day 18: Engine: Express LocalDB–Command line
Express LocalDB is an express edition with minimum files required to start sql server...
2012-05-18
1,965 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