Stairway to MDX - Level 12: : MDX Time/Date Series Functions: OpeningPeriod() and ClosingPeriod() Functions
BI Architect Bill Pearson continues with the second of a set of articles surrounding a group of MDX functions specialized to support the analysis of data within the context of time / date. In this article, we will explore the OpeningPeriod() and ClosingPeriod() functions, and get hands-on practice with each in meeting sample business requirements.
Azure Event Hubs
If you need to receive and process a large volume of of packets of data, such as telemetry, or event-log items, it may be worth considering Azure Event hubs. They aren't like traditional messaging but represent more of a stripped down one-way event processing system for large volumes of data. It could represent a good solution to an ever-present problem, but is it ready for production use? Rob Sheldon investigates.
Reporting Services: Drawing a Buffer on a Map
Handle together SQL Server spatial data features and Reporting Service design tools to build a map-based interactive report.
There Are Always Constraints
We must learn to deal with the reality of our situation, along with the limitations.
Analyzing I/O Performance for SQL Server
Inadequate storage is one of the most common bottlenecks seen in subsystem performance. There are a number of reasons for poor storage performance, but measuring it and understanding what needs to be measured and monitored is always a useful exercise.
SQL Monitor Custom Metric: Table size (MB)
This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes.
Are DacPacs ready for prime-time?
DacPacs have been around for a while but DBAs have not, in the past, taken them particularly seriously. Is it time to get involved and influence the way the technology develops?
Changing SQL Server Database Logical Names
SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.
Blogs
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers