Live versus Stored Data
Is it always important to have the most current data? Steve notes that you might need to make a decision here.
2021-01-26
28 reads
Editorials
Are You Empowered?
Many people don't feel like they can make changes in their work environment. Today Steve notes this is common in many organizations.
2021-01-25
62 reads
Data Privacy Grows in California
Changes in data privacy law in California are demanded by consumers.
2021-01-23
35 reads
A Beginning Project
Learning to be a better database developer can be hard. Today Steve asks how you might suggest someone learn.
2021-01-22
150 reads
Representative Data Challenges
We need data that represents the problem we want to solve, or we might not achieve our aims.
2021-01-21
63 reads
How to Grow In Your Career
Today Steve Jones gives you ideas on how to keep learning and growing your career.
2021-01-20 (first published: 2018-01-19)
232 reads
2021-01-19 (first published: 2018-01-23)
188 reads
Default Credentials
Using default credentials is a poor practice, but people still continue to forget to change them.
2021-01-18
86 reads
Who is my customer?
My final job in my previous career was at a hospital. I worked there for five years in the 90s before getting my first position as a developer. While I didn’t love the career I was leaving, I did appreciate what I learned from that last job. Part of the onboarding included a short class […]
2021-01-16
90 reads
Improving Availability Groups
Availability Groups are a good way to use High Availability in SQL Server, Today Steve wonders if you have any improvements you would make to the technology.
2021-01-15
97 reads
Blogs
Daily Coping 26 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Rowcount estimates when there are no Statistics
When you don't have statistics, what does SQL use to calculate the estimated number...
Synapse Analytics and .NET for Apache Spark Example 4 - JOINS
By Ed Elliott
This is a bit of a longer one, a look at how to do...
Forums
Balance is not calculating correctly,when date get change in transection.
Below is data in which two different date are coming,01/19/2021 and 01/18/2021 , Date...
Accessing a RESTORING database for test refresh
I have a requirement whereby testers on ServerA need a copy of the production...
How to get value portion key to every rn from 1 to 3 row on one row?
I need to get value portion key to every 3 row on one row...
Ask SSC