Implementing a custom sort
Rob Farley discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.
Share the Interesting Work
Today we have a guest editorial from Andy Warren that looks at how we might divvy up our workload in a company.
How to Start Big Data with Apache Spark
It is worth getting familiar with Apache Spark because it a fast and general engine for large-scale data processing and you can use you existing SQL skills to get going with analysis of the type and volume of semi-structured data that would be awkward for a relational database. With an IDE such as Databricks you can very quickly get hands-on experience with an interesting technology.
How to resolve SSIS access denied error in SQL Server Management Studio
Receiving an access denied error message when trying to connect to a remote instance of SSIS from SSMS? Sadequl Hussain provides the solution.
Held Hostage by the Database
Does your database development process prevent changes in your software? You shouldn't be held hostage by your database.
Stairway to U-SQL Level 11: Stored Procedures
To finish off our look at the core database objects, we inspect how the venerable stored procedure works in U-SQL.
More Power BI to your Elbow
Power BI Desktop continues to evolve. There have been many improvements to the reporting side that together make it easier to get from the data to the visualisation as quickly as possible. You can now create line charts that let users drill down into hierarchical data. There are now ways of adding dynamic reference lines to a visualization that provide users with relevant reference points. Robert Sheldon demonstrates how to combine these features to great effect.
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 Kantor BCA KCU VETERAN Telp:082144477715
WA:0821-4447-7715 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
Alamat Kontak Bank BCA KCU YOGYAKARTA Telp:08218154393
WA:08218154393 Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55223
Alamat Kontak Bank BCA KCU TANGERANG Telp:08218154393
WA:08218154393 Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten 15118
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers