I've been very pleased with the direction of SSMS the last few years. As it's been separated from SQL Server releases and gets updated more often, I think the changes from v17 though v20 have been improvements. There are still issues, but it's been better. Now we finally have SSMS moving to a modern shell […]
This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.
We have all heard the saying I based this week's editorial on. It has been credited to Benjamin Franklin and goes like this, “You can do anything you set your mind to”. This is such a powerful way of thinking when you are starting a task. “I can do it, no matter what anyone says.” […]
If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series.
This tip explores leveraging existing SQL Server stored procedures within the Microsoft GraphQL API.
This isn't really a first look, per se. I've seen Erin Stellato present on this a few times in MVP sessions and at the PASS Data Community Summit. However, this is a look on my machine, where I'm in control. The new version preview was announced recently, and this looks at the new process to […]
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
WhatsApp 082225313145 Jl. Sam Ratulangi No.86, Bitung Tim., Kec. Maesa, Kota Bitung, Sulawesi Utara...
WhatsApp 082225313145 Jl. Kolongan Jl. Raya Tomohon No.10 d/a, Kolongan, Kec. Tomohon Tengah, Kota...
Comments posted to this topic are about the item How Can SQL Server Detect...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers