How to Write a Better T-SQL Code
Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...
2018-11-17
21 reads
Blog Posts
Adding SQL Search to Azure Data Studio
There are a limited number of extensions available for Azure Data Studio (ADS), but one that came out early is...
2018-11-16 (first published: 2018-11-02)
1,892 reads
ASF 016 video invitation
“Power BI is just growing and growing and getting better and better at an amazing rate.” Who said that? Watch...
2018-11-16
198 reads
Load SQL error log to a table
AdvertisementsSQL server error log load to a table
There are cases, we need a SQL server error log load to a table...
2018-11-16
366 reads
Premium blob storage
As a follow-up to my blog Azure Archive Blob Storage, Microsoft has released another storage tier called Azure Premium Blob Storage...
2018-11-16 (first published: 2018-11-06)
2,536 reads
Subscribe to our RSS Feed
Be sure to subscript to our RSS feed to keep up with the latest SQL Server news and tips!
http://vitamindba.com/feed/
The post...
2018-11-16
297 reads
Learning New Skills
This post is a response to this month’s T-SQL Tuesday #108 prompt by Malathi Mahadevan. T-SQL Tuesday is a way...
2018-11-15 (first published: 2018-11-06)
2,660 reads
Microsoft Professional Program vs Microsoft Certification
When learning new technologies many people will go towards training courses (in person or online) but many also go for...
2018-11-15
261 reads
Monitor Database Offline Events
Hopefully, a database being taken offline is a known event and not a surprise. Occasionally there are gremlins, in the form of users with too many permissions, that tend...
2018-11-15
124 reads
T-SQL Tuesday – Non-SQL Server Technologies
So, this month’s T-SQL Tuesday topic is to think about a non-SQL Server technology that we want to learn.
For me,...
2018-11-15 (first published: 2018-11-06)
2,156 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers