PASS Summit 2018 brain dump
Much like your paycheck, this post is two weeks after the fact. But also like your paycheck, it’s got a good deal of personal importance. I’ve taken a couple...
2018-11-25
12 reads
Blog Posts
Live Query Stats of Running Queries
Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives...
2018-11-24
246 reads
ASF 016: Chris Webb interview
Introduction Chris Webb is independent consultant specialising in Analysis Services, MDX, Power Pivot, DAX, Power Query and Power BI in...
2018-11-23
236 reads
Parameterized dynamic SQL is parameterized.
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic...
2018-11-23 (first published: 2018-11-15)
2,536 reads
Power BI Monthly Digest – November 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-11-23 (first published: 2018-11-14)
2,402 reads
Where to Store Index DDL
Recently I was asked my opinion, via Twitter, on where to store the index DDL for a single database that had multiple clients with varied usage patterns. You can...
2018-11-23
10 reads
Where to Store Index DDL
Recently I was asked my opinion, via Twitter, on where to store the index DDL for a single database that...
2018-11-23
222 reads
Counting blessings – from Summit V2.0 and beyond
I have been a regular attendee at PASS Summit for 15 years now. This year (2018) marked my 15th year...
2018-11-22
202 reads
Learning Better Presentation Skills (T-SQL Tuesday #108)
This month’s T-SQL Tuesday is hosted by Malathi Mahadevan (@SqlMal). The topic is to pick one thing I would like to...
2018-11-22 (first published: 2018-11-13)
2,104 reads
Setting Memory–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-11-22 (first published: 2018-11-05)
2,259 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
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...
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