RANDom traps for the unwary
The Books Online description of the RAND() function is only true from certain perspectives.
The Information Schema and Cross-RDBMS Working
A look at the ODBC standard and how valuable it has been, unlike the Information Schema implementations.
Big Data Architecture
The next few years will be critical for the information technology staff, as they attempt to integrate and manage multiple, diverse hardware and software platforms. In this article, Lockwood Lyon addresses how to meet this need, as users demand greater ability to analyze ever-growing mountains of data, and IT attempts to keep costs down.
Unique Indexes Are Code; Non-Unique Indexes Are Data
Unique indexes are the database developer's responsibility. Non-unique indexes can be more easily maintained directly on the production database by an automated process.
Work to Live
It's important that you remember to live and enjoy your life as it passes by. Today Steve Jones reminds us that we want to work to live, but also plan to live and plan for the future.
SQL Server Reporting Services CountDistinct and Previous Functions
Scott Murray takes a look at what count function variations and related functions are available in SQL Server Reporting Services (SSRS).
Promoting Engineers
It seems that often we promote the best technical people into managerial positions, but is that a good idea? Steve Jones notes that a few people think this is a bad idea and there ought to be a technical career path for IT workers.
ASP.NET Core: A More Realistic Starter Kit
ASP.NET Core is a fascinating platform with many good ideas, but in its present form (RC1)there is a culture shock for experienced ASP.NET developers to experience the effort involved in porting a realistic application. There is an obvious advantage on being able to host an application on any web server, but is this enough to compensate for losing the convenience of an integrated pipeline?
Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining
In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
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...
Forums
BCA KCP Mal Taman Anggrek Telpon/WA:08218168291
BCA KCP Mal Taman Anggrek Telpon/WA:08218168291.Jl. Letjen S. Parman No.Kav. 21 Lower Ground Lot....
BCA KCP Pondok Bambu,Telp/Wa 08213111159
Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blok A/5-6, RT.2/RW.2, Wil, Kec. Duren Sawit,...
BCA KCP Percetakan Negara. Tlp:085373737845
Jl. Percetakan Negara No.223 C, Rawasari, Kec. Cemp. Putih, Kota Jakarta Pusat, Daerah Khusus...
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