SSRS #75 – Use RunningValue() Function and VB Script to capture discrete dates
Drill-down report is a common design
In SSRS, it’s a common design to allow users to drill down to more granular...
2014-11-14 (first published: 2014-11-11)
9,159 reads
MDX #44–How to find all the calculated measures
Calculated measures are visually identifiable
If you have access to a cube, it’s quite easy to find all the calculated measures.
The...
2014-11-13
1,453 reads
MDX #43–Find a MDX Calculation Script
Finding out MDX calculation scripts is a common task
A co-worker recently asked me what the calculation for a calculated measure...
2014-11-12
1,335 reads
Book Review: Why You Should Read Expert Cube Development With SSAS 2012 Cover to Cover
Expert Cube Development with SSAS 2012 Multidimensional Models was published earlier this year by Packt Publishing. It’s the second edition...
2014-06-15
824 reads
MDX #41–Remove employees with less than $100,000 sales
Table of contents
Need to remove employees who have zero sales amountCreate a calculated measure with the IIF() function The NON...
2014-05-30
1,476 reads
SQL #54–Casting numbers with white spaces as Integer will fail
Table of contents
IsNumeric() funciton is too forgivenUse Pattern Matching with LIKE keywordLIKE keyword in T-SQL doesn’t support regular expressionReplace white...
2014-05-30
1,528 reads
DAX #2 – Installing AdventureWorks DW Tabular Model SQL Server 2012
OK, first thing first. We all know the famous Adventure Works multidimensional sample project. To learn the tubular mode/DAX, we...
2014-05-09 (first published: 2014-04-30)
14,298 reads
SSRS #74 – 2008 Cascading bug when you have a middle parameter
Some SSRS reports have a large number of parameters
I recently had a chance to help a co-worker to modify...
2014-05-09
1,756 reads
SQL #53 – Keyboard shortcut Alt + F1 works now in SSMS 2012
Keyboard shortcut Alt + F1 works now
SSMS has a rich set of keyboard shortcuts that works by default. But in SSMS...
2014-04-30
6,225 reads
DAX #1 – Learning DAX
I recently attended a virtual training of Tabular and Power Pivot for Developers taught by Kathy Vick at Pragmatic Works....
2014-04-25
1,887 reads
Blogs
T-SQL Tuesday #189–AI and your Career
By Steve Jones
I’m late to the party this month. Taiob Ali has a great invite for...
TSQL Tuesday #189: How is AI changing our careers
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and...
Using SQL Compare to Revert a Stored Procedure
By Steve Jones
Imagine this situation, someone edits a stored procedure on a production server to “fix”...
Forums
Building a Database Dashboard with SSRS
Comments posted to this topic are about the item Building a Database Dashboard with...
CDC job running for 17 days?
Good morning, I've noticed my CDC job running for 17 days. I've noticed it...
Database growth events for unidentified databases
We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly...
Question of the Day
Determining the Updated Columns
I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:
CREATE TABLE CustomerLarge ( CustomerID INT NOT NULL IDENTITY(1,1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) , creditlimit INT , discount numeric(4,2) , lastorderdate DATETIME , lastorderamount NUMERIC(10,2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT) GOIf I want to detect that the creditlimit was updated, what IF statements should I use? See possible answers