Data Warehousing Tip #7 – How I build a time dimension
In this article I’m going to show you how I build my time dimensions. There are lots of different ways...
2019-02-26 (first published: 2019-02-04)
3,933 reads
Classify your Azure SQL Database
Here I am talking about SQL Data Discovery & Classification feature that is built into Azure SQL Database. With this feature you...
2019-02-04
219 reads
Weekly reading #1
Damian. My name is Damian. Maybe you already know me from the previous blog which I had to leave. I...
2019-02-04
58 reads
Tidier PowerShell Scripts with Default Parameter Values
I was recently working on a PowerShell script to set up some new databases for my users and found myself writing the same things over and over again.
1 2...
2019-02-04
35 reads
#Python101 with Dominika
Take a look into first article about Python prepared by Dominika. You can find it here.
2019-02-03
70 reads
Last Week Reading (2019-02-03)
Press Webinar Follow-Up: Top 4 Data Technology Trends for DBAs in 2019 Very interesting discussion panel led by Kevin Kline...
2019-02-03
186 reads
SQLServerCentral SSAS Tabular Series: 5th Article Cleaning Up Dimensions
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the beginning article before reading this one in order to...
2019-02-03
56 reads
SQLServerCentral SSAS Tabular Series: 5th Article Cleaning Up Dimensions
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the...
2019-02-03
200 reads
Generating Insert Statements
G’day,
I been asked a few times lately the best way to generate INSERT statements.
I’d always replied to use SSMS.
I know...
2019-02-25 (first published: 2019-02-02)
2,610 reads
SQL Server Monitoring: What queries should you monitor?
I previously wrote about measuring wait statistics. This matters a lot, because you can track historically what wait statistics are...
2019-02-02
393 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers