-
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…
-
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…
-
How to renew “MCSE:Business Intelligence” credentials
The other day a colleague of mine asked if I am preparing for a recertification exam for my “MCSE: Business Intelligence” certificate. His certificate was close to the expiration date and he wanted to see what resources I will be using.That caught me b…
-
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…
-
Capturing user activity in the database using SQL Server Auditing functionality
SQL Server comes with a build in audit functionality that saves a lot of development effort when one of the business requirements states is to keep a record of user activity in the database. For each query executed in the database, SQL Server Audit captures the names of the affected tables, SQL statement used for…
-
Vertical and horizontal lines or strips on Line Chart in SSRS
How do you show a vertical or horizontal line on a line chart in SSRS? After hours or research it seems that approach involving StripLines works the best. Horizontal or vertical likes can be used on the chart to indicate baselines or highlight particular sections as on the sample below: So, how do you build…
-
Scripting table data
Every now and then I need to create a SQL script to move table data between environments or to simply load table during database deployment process. For a number of years I am using the stored procedure created by Narayana Vyas Kondreddi (http://vyaskn.tripod.com). This is a great tool for scripting data without any problems! Attached…
-
Small cell value suppression in SSAS cube output
I am currently working on project building information system for one of the provincial health registries. Patient data protection and privacy is one of the main requirements that touched all parts of the information system including standard reports and SSAS cubes. One of the requirements I’ve encountered while working with SSAS cubes was that measure…
Toronto, Ontario, Canada
Eastern Time Zone
info@maximconsulting.ca
Articles
Archive
Categorise
- aggregation
- audit
- average
- backup
- baseline
- cell value overwrite
- certification
- compliance
- cube
- data driven subscriptions
- data export
- datetime
- de-normalize
- graph
- hierarchy
- local time
- MCSE
- MDX
- Microsoft
- parent-child
- recovery
- restore
- rounding
- script table data
- Small cell value suppression
- ssas
- ssrs
- statistical functions
- stipline
- UTC
