I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]
2020-07-11
717 reads
Steve notes that many of us might not completely understand every part of our database, but it's information that can be helpful in cleaning out unnecessary entities.
2019-04-10
550 reads
Using code to help you write code is a time honored tradition in software development.
2023-08-16 (first published: 2019-04-09)
552 reads
Steve reminds some people that there are reasons to continue to improve your skills.
2019-04-08
1,733 reads
Azure Data Explorer is a platform from Microsoft that might be an interesting fit
2019-04-05
362 reads
2019-04-04
654 reads
Today Steve has an announcement about his role in moving Books Online forward.
2019-04-01
531 reads
Last week was the MVP Summit. This year included a bunch of very technical discussions about some of the future of the Microsoft Data Platform (a big thank you goes to Slava Oks, Bob Ward, and all the team for a great job). I can’t share much since it was all under NDA. All I […]
2019-03-30
497 reads
Trunk based development is what many of us do with shared database servers.
2019-03-29
593 reads
There is a need to ensure we decide what ethics a computer system ought to have.
2020-02-10 (first published: 2019-03-27)
229 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers