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
659 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
124 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
95 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
321 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
525 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,582 reads
Azure Data Explorer is a platform from Microsoft that might be an interesting fit
2019-04-05
356 reads
2019-04-04
648 reads
By kleegeek
Join us on December 8th at 10am Pacific time for an exciting new webinar!...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I have trouble in writing a SQL query. I have a data table with...
Hi all, I am currently having performance issues by populating one of my factless...
Hi Experts, I am getting the following error when i am trying to test...
Ask SSC