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.
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.
Handle together SQL Server spatial data features and Reporting Service design tools to build a map-based interactive report.
We must learn to deal with the reality of our situation, along with the limitations.
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.
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.
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?
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.
One important skill is for the DBA or developer of the future is being sure they can present data to clients in a way they can use it.
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Ruko Citra Garden II, EXT Blok BE 01 A / 01 & 02, RT.2/RW.8,...
Pantai Kita, Soho Blok B.030, Unit SEB-030, Type Ebony 2 Jl. Pantai Indah Kapuk...
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Gedung, Wisma Barito Pacific, Jl. Letjen S. Parman No.Kav. 62-63, Slipi, Kec. Palmerah, Kota...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers