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.
Is It Time To Clear Out Those Quirky Functions?
Phil Factor ponders a cull of some of SQL Server's worst-behaving functions.
Agile 2014, Florida
Agile Alliance is holding a conference July 28 - August 1 in Orlando, Florida. If you're interested in Agile development, whether your initiative is mature or brand new, enterprise-wide or team-centric, you will find the finest knowledge, resources and people at Agile2014. This conference is for Teams, Developers, Managers and Executives. Register while space is available.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers