Data Mining Part 30: System Views
Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.
Data Mining Part 30: System Views
Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.
How to Unlock Your Team's Creative Power with SQL Prompt and a VCS
Extend SQL Prompt's functionality by connecting your snippets to version control
Is the Golden Age of Information Technology Almost Over?
Andy Warren wonders if our industry is moving to a new era today.
In-Memory OLTP – Common Workload Patterns and Migration Considerations
In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures.
The Poster of the Plethora of PowerShell Pitfalls
One of the downsides of learning a new computer language is that transfer of training doesn't always work to your advantage. In fact, the habits you picked up in the past may now cause confusion. In this poster or wall-chart for long walls, Michael Sorens selects the thirty-six most common causes of confusion for anyone getting to grips with PowerShell.
Translating reports with Analysis Services and MS-Excel
Translating reports with Analysis Services 2012 and MS-Excel 2013 in a multilingual environment
Why Can't We Code?
Today Steve Jones talks about the ways in which we interview new developers. Are they working or do we need a new way? Should we be considering those people that have actually accomplished something?
Temporarily Change SQL Server Log Shipping Database to Read Only
I want to temporarily use a Log Shipped secondary database for Read Only operations, but Log Shipping was not configured for read only operations. I don't want to reconfigure Log Shipping, so is there a way to do this without redoing Log Shipping.
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 Kepa Duri,Telp/Wa 0821.3111.159
Jl. Mangga Raya No.20, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus...
BCA Finance WTC Mangga Dua Tlpn/wa:085373737551
Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL, Jl....
BCA KCP Kebon Jeruk,Telp/Wa 0821.3111.159
Komp, Jl. Taman Kb. Jeruk Jl. Meruya Ilir Raya No.Blok B 6, RT.1/RW.9, Srengseng,...
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