You recently published a script showing how to do pagination (e.g. results 20 - 30 of 100) It's also possible to do it quicker and more elegantly without having to resort to building the sql string dynamically (never a good thing IMHO). You pass in 2 parameters, @PageIndex is the first record you want (so […]
2006-05-31 (first published: 2006-05-24)
1,263 reads
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
By Steve Jones
Today’s coping tip is take your time. Make space to just breathe and be...
Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...
I have two SQL 2019 servers running Master Data Services which are continually prompting...
$msg = Get-Content 'C:\miscjunk\SQL_Servers.txt' | ForEach-Object {New-Object 'Microsoft.SqlServer.Management.Smo.Server' $_} | Select-Object -Expand Databases |...
Ask SSC