Words vs Data
Are you clear in your reporting. Steve notes that sometimes we might leave too much up to interpretation by the end user.
2025-02-03
66 reads
Are you clear in your reporting. Steve notes that sometimes we might leave too much up to interpretation by the end user.
2025-02-03
66 reads
2019-11-26
359 reads
You’ve decided that you need to offload reports to a different SQL Server, and you’re willing to pay the costs. Here are the most common ways to move the data from production to a reporting server, arranged roughly from easiest-to-implement to hardest.
2019-07-12
Populate a calendar table with user set interval start and end datetime values.
2014-03-11 (first published: 2014-02-21)
1,731 reads
Populate a calendar table with user set interval start and end datetime values.
2014-09-16 (first published: 2014-02-21)
2,064 reads
Populate a calendar table with user set interval start and end datetime values.
2014-09-15 (first published: 2014-02-21)
1,984 reads
The other day I came across an interesting repo on github, KubeDiagrams. What this...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
SQL Server migrations are a headache, ask anyone who’s been through the pain of...
Hi we know (or believe) ssas saas gets stood up separately when a company...
Good Afternoon. I have been manually running an SSIS package on an adhoc basis,...
I have an always on availability group of 3 servers (1 primary and 1...
I have this code:
SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x FROM ProductSales;What is a good name for the column alias? See possible answers