Data Modeling Webcast Rescheduled
Unfortunately, due to a last minute scheduling conflict on my side, we’ve had to reschedule the data modeling webcast with...
2019-01-16
142 reads
Blog Posts
Data Warehousing Tip #3 – Build thin slice
My third data warehousing tip is to build thin slice. Deliver subsets of valuable functionality. Get feedback and buy in,...
2019-01-16 (first published: 2019-01-07)
2,847 reads
Database modelling in a post-SSMS world: dbForge Studio
A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams...
2019-01-16
235 reads
Inspector V1.3 hotfix
Unfortunately we discovered a small bug in 1.3, the Database ownership module default warning level was not showing a yellow...
2019-01-16
178 reads
Short Circuiting Your Session
It isn’t very often that one would consider a short circuit to be a desired outcome. In SQL Server we...
2019-01-16 (first published: 2019-01-05)
2,069 reads
Watch all my free PASS Summit recordings– and more videos at Pass.org
A magical thing happened this week in the SQL Community Slack (it’s free to join, by the way, sign up here). In the midst of a discussion about the...
2019-01-16
56 reads
Approximate COUNT DISTINCT
We all have written queries that use COUNT DISTINCT to get the unique number of non-NULL values from a table....
2019-01-15 (first published: 2019-01-03)
2,480 reads
Creating my own Map Shapefiles for Power BI
(2019-Jan-06) In the past, I used to always rely on shapefiles crafted by others to create my map visualizations in...
2019-01-15 (first published: 2019-01-06)
6,793 reads
Inspector V1.3 now available
Inspector V1.3 is now available on GitHub.
We have updated the sample report for you to play with which includes the...
2019-01-15
156 reads
Moving off SQL Server 2008 / R2 – What can Azure offer?
You will very likely know that SQL Server 2008 / R2 end of support is on July 9th 2019. Not that...
2019-01-15
256 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers