An Impressive SQL Server
This Friday Steve Jones has a poll about which SQL Servers might impress you. Is there a company or installation that you think would really showcase the power and scalability of SQL Server?
SQL Server on Linux
A secret project is underway up in Redmond, according to sources not so high up in the development team. A port is partially working for various reasons. Read this exclusive scoop!
Oracle Error When Importing An Interval Partitioned Table
Oracle 12.1.0.2 can throw an ORA-01438 when importing an interval partitioned table. In this post, David Fitzjarrell suggests a work-around until Oracle patches the bug.
Correct Old Mistakes
We all make mistakes, but it's important that we revise our code to correct them over time.
Data Mining Part 34: Preparing for a certification exam
In this article we will talk about the Microsoft certifications related to Data Mining.
SQL Server Data Tools (SSDT) and Database References
SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexity to deployments, it can increase the probability that deployments will succeed without errors due to broken references or binding errors. Ed Elliot investigates.
The Boardgame of Office Politics
Sometimes the stress of interdepartmental friction withing organisations, can get on top of you, especially between the business and IT when the going gets tough. Simple-Talk's answer is a board game to put it all into perspective. Instead of getting carried away, play the board game instead and reach catharsis.
Advanced Mathematical Formulas using the M Language
The Power BI desktop designer contains a rich set of advanced mathematical functions. In this article, John Miner shows how you can combine these functions together in a computed column to solve numerical business problems.
Hacking Data
A new series of attacks were proven recently using music files to attach embedded systems in cars. Could this be another attack vector that we need to worry about?
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Cilandak KKO ITelepon 083110611866
WhatsApp 083110611866Jl. Raya Cilandak KKO No.9, Ragunan, Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus...
BCA KCP Rungkut Mapan telp:cs.083188951403
Whatsapp:083188951403 Raya Rungkut Mapan / Yakaya, Jl. Rungkut Mapan Utara No.09 Blok BA 08,...
BCA KCP Cikarang No.Telp:087757645171
Whatsapp:087757645171 Ruko Cikarang Plaza, Jl. Yos Sudarso No.5 Blok B, RW.6, Cikarang, Kec. Cikarang...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers