OK, Microsoft Teams is cool
I’ve had a lot of video collaboration tools come across my desk over the last decade. I’ve depended on many of these to communicate with Redgate in the UK...
2019-10-28
53 reads
The Voice of the DBA
Make the most of your PASS Summit Evenings
At this year’s PASS Summit, I’ll only be around for a short time, and really only Monday night. I have two pre-cons to do and then need to get...
2019-10-26
169 reads
Arrays in PowerShell–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This isn’t necessarily an expert post, but more...
2019-10-23
117 reads
Adding a License to GitHub
I’ve rarely thought about licensing my code, but it’s something to be aware of for your work. Most of us freely share code, though I have started to add...
2019-10-21
47 reads
SQL in the City Comes Back to Seattle
This year at the PASS Summit, Redgate is holding our SQL in the City Summit as one of the pre-con events at the conference. You can add this in...
2019-10-17
9 reads
Setting Permissions for a SQL Server backup folder–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. While testing a script recently, I needed to...
2019-10-25 (first published: 2019-10-16)
349 reads
Launching SQL Compare with Context
Years ago Redgate Software started some work to link our tools together. I remember early efforts, about which I had dubious thoughts as to the value. I hadn’t looked...
2019-10-21 (first published: 2019-10-14)
256 reads
SQL in the City Back in London
It’s just a couple weeks until the SQL in the City Summit comes back to London. This is our second Summit this year in London, and I’m honored to...
2019-10-17 (first published: 2019-10-11)
211 reads
Just Getting Specific Files in PoSh–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Just a quick one today, but a tip...
2019-10-18 (first published: 2019-10-09)
227 reads
T-SQL Tuesday #119–Changing My Mind
After missing the last T-SQL Tuesday, I’m back for the latest invitation from Alex Yates. In this one, Alex asks us to write about something in IT where you...
2019-10-08
15 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
We Should Demand Better
Comments posted to this topic are about the item We Should Demand Better
Estimated Rows
Comments posted to this topic are about the item Estimated Rows
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch? See possible answers