-
Script to de-normalize Parent – Child Hierarchy
Parent Child data hierarchies are great for storing hierarchical data, however it becomes a major pain when you need to convert hierarchy structure into a flat view (e.g. to be used in reporting or SSAS cubes). While SSAS provide a build…
-
Use sp_replrestart to fix “The process could not execute ‘sp_repldone/sp_replcounters’” error
This error is generally raised by the log reader agent while running transactional replications. The error indicates that distributor and subscribe databases has data that may be more recent than data in the publisher database (the agent compares lates…
-
Converting UTC to local time
ProblemValues in the database are stored as UTC date and time in a simple datetime format. You want to see data time values in the local time.SolutionUse the following code to convert UTC date/time to local:CREATE TABLE #table (date_UTC datetime)/* Pop…
-
Data-Driven Subscriptions in SQL Server
I recently had a project that used data-driven subscriptions for bulk processing of SSRS reports. Subscriptions is a very powerful tool, but it lacks centralized monitoring tools, so I had to dig deep into the content database where SSRS service mainta…
Toronto, Ontario, Canada
Eastern Time Zone
info@maximconsulting.ca
Articles
Archive
Categorise
- aggregation
- audit
- average
- backup
- baseline
- cell value overwrite
- compliance
- cube
- data driven subscriptions
- data export
- datetime
- de-normalize
- graph
- hierarchy
- local time
- MDX
- parent-child
- recovery
- restore
- rounding
- script table data
- Small cell value suppression
- ssas
- ssrs
- statistical functions
- stipline
- Uncategorized
- UTC
