-
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
Month: April 2026
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
