Knee-Jerk Wait Statistics : CXPACKET
With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.
2015-07-13
3,180 reads
Articles
FORMAT() is nice and all, but…
Aaron Bertrand compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.
2015-07-10
5,834 reads
How to Unlock Your Team's Creative Power with SQL Prompt and a VCS
Extend SQL Prompt's functionality by connecting your snippets to version control
2015-07-09
1,998 reads
In-Memory OLTP – Common Workload Patterns and Migration Considerations
In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures.
2015-07-09
3,186 reads
2015-07-08
456 reads
The Poster of the Plethora of PowerShell Pitfalls
One of the downsides of learning a new computer language is that transfer of training doesn't always work to your advantage. In fact, the habits you picked up in the past may now cause confusion. In this poster or wall-chart for long walls, Michael Sorens selects the thirty-six most common causes of confusion for anyone getting to grips with PowerShell.
2015-07-08
4,984 reads
Translating reports with Analysis Services and MS-Excel
Translating reports with Analysis Services 2012 and MS-Excel 2013 in a multilingual environment
2015-07-07
4,593 reads
Temporarily Change SQL Server Log Shipping Database to Read Only
I want to temporarily use a Log Shipped secondary database for Read Only operations, but Log Shipping was not configured for read only operations. I don't want to reconfigure Log Shipping, so is there a way to do this without redoing Log Shipping.
2015-07-07
3,197 reads
Monitoring Availability Groups with Redgate SQL Monitor
Anthony Nocentino, experienced Enterprise Architect and Friend of Redgate, explains the challenges presented by monitoring Availability Groups and shows you a technique for monitoring AG replication latency with Redgate SQL Monitor and its Custom Metric functionality.
2015-07-07
2,913 reads
2015-07-06
4,646 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