Error: Microsoft .NET framework 3.5 service pack 1 is Required
How can you fix a .NET Framework 3.5 error while installing SQL Server 2014?
Declarative SQL: Using References
There are several ingenious ways of using SQL References to enforce integrity declaratively. Declarative Referential Integrity (DRI) is more effective than using procedural code in triggers, procedures or application layers because it uses the SQL paradigm, thereby making optimisation easier and providing clearer expression of the rules underlying the data. Joe Celko explains.
Top 10 MySQL Reporting Tools
Both management and various departments rely on data reports to help guide their business decisions. Rob Gravelle presents ten open source and commercial report generation tools for MySQL and other relational databases.
New DAX functions in SQL Server 2016
SQL Server 2016 comes with several new features including new DAX functions to enrich the functionality, Daniel Calbimonte takes a look.
JSON support in SQL Server 2016
At last, SQL Server has caught up with other RDBMSs by providing a useful measure of JSON-support. It is a useful start, even though it is nothing like as comprehensive as the existing XML support. For many applications, what is provided will be sufficient. Robert Sheldon describes what is there and what isn't.
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 Ahmad Yani II,Telp/Wa 0821.3111.159
Jl. A. Yani No.280, Kacapiring, Kec. Batununggal, Kota Bandung, Jawa Barat 40271
BCA KCU ASEMKA Tlpn/Wa:6285188120691
Jl. Asemka No.27-30, Pinangsia, Kec. Taman Sari, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta...
BCA KCP Hasyim Ashari Telpon/WA:08218168291
BCA KCP Hasyim Ashari Telpon/WA:08218168291.Jl. KH. Hasyim Ashari No.5 AA, Petojo Utara, Kecamatan Gambir,...
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