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
732 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
81 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
127 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
102 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
398 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
533 reads
Using code to help you write code is a time honored tradition in software development.
2019-04-09
335 reads
Steve reminds some people that there are reasons to continue to improve your skills.
2019-04-08
1,586 reads
Azure Data Explorer is a platform from Microsoft that might be an interesting fit
2019-04-05
358 reads
2019-04-04
649 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...
By James Serra
When using Power BI and pulling data from Azure Synapse, you will use the...
There is a server running SQL Server 2012 32 bit. This is the default...
Hi Everyone, Currently looking at tidying up some SQL servers and i have a...
\hello Guys, Mayyou help wuth the corect index filetred creation using modulo? ...
Ask SSC