Data Mining: Part 11 XMLA and the automation
In this lesson we will learn the basis about XMLA and we will execute the command line to create DM objects.
Data Mining: Part 11 XMLA and the automation
In this lesson we will learn the basis about XMLA and we will execute the command line to create DM objects.
Infect Your Colleagues with the Learning Bug
Many of you are interested in learning more about SQL Server and improving your career. However can you extend that to your colleagues? Can you convince them to become better IT professionals? Andy Warren has some thoughts.
SQL Monitor Metric: Memory used by ad hoc queries running once
This metric measures the amount of memory used by the total number of ad hoc queries in the plan cache that have only run one time. This value is only accurate for the instant the query is run, and the value can change radically from one capture time to the next.
SQL Server Analysis Server (SSAS) KeyColumn vs NameColumn vs ValueColumn
What is the difference between the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute in SQL Server Analysis Services? When should you use each one for a dimension attribute? Check out this tip to learn more.
Mudita: Joy in the success of others
It is only when you start to take genuine pleasure in other people's successes that you experience the true rewards of being in a leadership position.
Single Quotation Marks in SQL
One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.
Do You Really Need to Tune Big Data Applications?
Big data applications are here to stay. The promise of this technology is the ability to quickly and easily analyze large amounts of data and derive from that analysis changes to customer-facing systems, hopefully at a reasonable cost. So, do these applications really need tuning?
Instant File Initialization
This article describes a way to speed up various file operations performed by SQL Server.
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 Finance Samarinda,Telp/Wa 0821.3111.159
Jl. Jend. Sudirman KCU BCA Sudirman No.30 Lantai 4, Ps. Pagi, Kec. Samarinda Kota,...
BCA Finance Tegal Layanan Mobil,Telp/Wa 0821.3111.159
Jl. Sultan Agung No.29, Kejambon, Kec. Tegal Tim., Kota Tegal, Jawa Tengah 52124
BCAFinance (sepeda motor),Telp/Wa 0821.3111.159
Jl. Kapten Piere Tendean No.13, Sekayu, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50132
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