Should Salary Information Be Confidential?
Today we have a guest editorial from Andy Warren as Steve is away from the office. Salary is a difficult topic for many, but Andy shares some thoughts.
2019-08-27 (first published: 2015-06-05)
613 reads
Editorial
Architecture for Auditing
The way in which auditing is build into our systems isn't the best way to implement the practice.
2015-06-04
140 reads
Finding Production Drift
The changes made to production can be problematic at times. Steve Jones notes we can't prevent them, but we can look for them.
2015-06-02
81 reads
2015-06-01
197 reads
Who Cares About Your Data?
The observation that people hear what they want to hear is not a new one, and yet the extent to which people will go out of their way to ignore or misinterpret evidence can still surprise.
2015-06-01
105 reads
Statistical Analysis
This week Steve Jones asks the questions about advanced data analysis and statistics you might be using in your applications.
2015-05-29
196 reads
The Hidden Patterns in Data
Looking at statistics and data to draw conclusions can be hard. Steve Jones comments on an interesting way of analyzing data from TED.
2015-05-28
172 reads
2015-05-27
366 reads
Hack Us
A challenge from United intrigues Steve Jones. How many other companies would make a challenge like this?
2015-05-26
185 reads
The Scientific Method: a call to action
Gail Shaw issues a rallying call for the SQL Community to adopt the Scientific Method when investigating and reporting on SQL Server behavior.
2019-09-09 (first published: 2015-05-25)
607 reads
Blogs
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers