The Road to Better Data Handling
As data becomes more valuable and regulations require safer processing, it is important we become more careful in our daily work.
What’s the Difference Between PERCENT_RANK and CUME_DIST?
Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.
How can we close the tech skills gap?
One of the most profound challenges faced by technology companies today is talent. According to the latest Harvey Nash survey, 65% of CIOs believe that a shortage of tech skills is affecting their ability to respond to change.
Improving Tech with Compassionate Code
There is quite a bit of suffering within tech and caused by tech, from poorly commented code to shaming someone who asks a question on a forum. In this article, Samuel Nitsche explains why compassionate coding is a better way to go.
Collect SQL Server Index Usage Information for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
Data breach notifications don’t need to be scary
Ever since the GDPR was introduced, the subject of data breach notifications has worried a lot of people. How do you write one? What do you need to include? What will the ramifications be? Will it make your customers run for the hills? Will it get you fired?
All flash vs adaptive flash storage - which is right for my organisation?
Many data professionals might not worry about hardware, but someone needs to watch for changes and improvements in technology. Learn about how flash storage technology has changed and how this might be useful if you still need to build a fast database server.
Spread the Word about Basic Security
This week we have a few back to the basics security comments from Steve.
Displaying the Object Explorer Details Pane in SQL Server Management Studio
You are probably familiar with the Object Explorer pane in SQL Server Management Studio (SSMS), and how to bring it up. But, are you familiar with the Object Explorer Details pane and how to display it? If not, then read on...
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
BCA KCP Sunter Bisma No. Telp:083831617937
Whatsapp.083831617937 Komp. Nirwana Sunter Blok A/31-32, Jl. Bisma Raya AsriJakarta Utara, DKI Jakarta, Indonesia...
BCA KCP Sunter Danau No. Telp:083831617937
Whatsapp.083831617937 Jl. Danau Agung 2 Blok E2 No. 1A, Sunter Podomoro Jakarta Utara, DKI...
BCA KCP Sunter Podomoro No. Telp: 083831617937
Whatsapp.083831617937 Jl. Agung Utara Raya Blok A 36 D No.50-51, RT.11/RW.9, Sunter Agung, Tj....
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers