Microsoft recently announced that you’ll get Azure Data Studio (ADS) when you install SQL Server Management Studio (SSMS) starting with version 18.7.1. Azure Data Studio has been around for a couple of years, and it has some great features that most of us never imagined for SSMS, like the ability to connect to PostgreSQL databases […]
2020-11-07
445 reads
There’s the old saying “Whether you think you can or you think you can’t -- you’re right” from Henry Ford. I’ve thought about this more recently while reading the book The Rise of Superman Decoding the Science of Ultimate Human Performance which talks about how athletes have performed so called impossible feats over the past few […]
2020-10-31
77 reads
The term DevOps gets horribly abused. Don’t get me started on all the weird additions to it like DevSecOps. No, I just mean the term itself gets beaten up quite a lot. It’s to the point where people are starting to shy away from talking about it. I’ve even changed my approach when discussing DevOps […]
2020-10-24
119 reads
Over the years when I changed careers and then advanced in IT, many people helped me learn or provided opportunities. Some of these people gave specific in-person help, like my brothers who taught me programming logic and database normalization before I ever thought about working in technology. Others assisted from a distance when I read […]
2020-09-05
89 reads
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
241 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
517 reads
Using code to help you write code is a time honored tradition in software development.
2019-04-09
332 reads
Steve reminds some people that there are reasons to continue to improve your skills.
2019-04-08
1,577 reads
Azure Data Explorer is a platform from Microsoft that might be an interesting fit
2019-04-05
353 reads
2019-04-04
646 reads
By todd-32417
Improve your team's workflow and productivity with these project tracking blocks.
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...
Comments posted to this topic are about the item Finding the Group
Hi, I am trying to write a backup script, in a way that...
Ask SSC