Complex Searching
More complex searching is likely to be a requirement in the future, but for many of us, this won't require us to learn much.
2021-10-22
59 reads
Editorials
Going Cloud Native
Lots of organizations are moving to the cloud, but having different levels of success. This change can be powerful and create tremendous opportunity, but it can also be a disappointment.
2021-10-20
98 reads
Growing and Keeping Up
Trying to keep up with technology is a losing game. Better to continue to grow and learn, balanced with the rest of your life.
2021-10-18
180 reads
Learning Is Challenging, So, Forgive Yourself
In addition to trying to get better at SQL Server, Redgate Software, and all the various aspects of my job, I'm also trying to get better at this whole human interaction thing AND I'm working on trying to learn PostgreSQL much more deeply. Whew! Yeah, may not seem like a whole lot, but I assure […]
2021-10-16
90 reads
To-do list: good, bad or indifferent?
Using a list to keep track of what you should work on is only as good as the plan or goal behind it.
2021-10-15 (first published: 2017-08-07)
179 reads
The Digital Twin
GE is using lots of data, and machine learning to predict when specific systems will fail by nurturing digital twins.
2021-10-13 (first published: 2017-07-19)
121 reads
2021-10-11 (first published: 2017-07-27)
138 reads
PASS Data Community Summit Pre-cons
This year PASS Data Community Summit is a free virtual event, and I encourage you to register even if you are interested in just a handful of sessions. One of the Learning Pathways might be just what you are looking for, from Query Basics to Power BI to DevOps. What I’m most excited about this […]
2021-10-09
62 reads
The Last SQL Server Service Pack
SQL Server 2016 SP3, the last service pack ever is out. Steve comments on how the world of software patches has changed.
2021-10-08
153 reads
Choosing State Over Migrations
Steve notes that there are differences between state based development and migration based development, but neither is necessarily better.
2021-10-06
120 reads
Blogs
A New Form of Address: Mx
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
Group By Starting Characters
By Kevin3NF
I was chatting with Jeff (b|t) on my team yesterday and the context escapes...
Daily Coping 22 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Finding all logins that can alter DDL
Hello experts, Is there a ready-made query out there that I could run on...
Insert records with a where
I want to insert record job allocations only for selected jobs I know the...
Insert records with a where
I want to insert record job allocations only for selected jobs I know the...
Ask SSC