Victims of Success
I took part in the PASS Summit 2014 selection committee this year because I was really curious about seeing how...
2014-07-21
666 reads
Blog Posts
Clustered Columnstore Indexes – part 34 (“Deleted Segments Elimination”)
Continuation from the previous 33 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Segment Elimination for Deleted Row Groups
After some very interesting and inspiring conversations...
2014-07-20
552 reads
Extraordinary #2
This is another situation that happened on a database migration at a client site. The database migration was done by using SSIS...
2014-07-19
107 reads
Things You Can Find in the Plan Cache at SQLBits
On Saturday, I had the pleasure to present my session, “Things You Can Find in the Plan Cache”, at SQLBits!
Thanks to...
2014-07-19
443 reads
Database jokes
Sometimes when work is tough you just need to take your eyes and mind away from your working console. Jokes are...
2014-07-18
6,215 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one...
2014-07-18
1,303 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one matter that you can take a look on and smile...
2014-07-18
6 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one matter that you can take a look on and smile...
2014-07-18
230 reads
Display All SQL DateTime Conversions
If you want a quick way to determine which format, or style, to specify when converting a datetime value in...
2014-07-18
668 reads
Display All SQL DateTime Conversions
If you want a quick way to determine which format, or style, to specify when converting a datetime value in SQL to a character data type, you can use...
2014-07-18
24 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
URL Safe or Not?
Comments posted to this topic are about the item URL Safe or Not?
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers