Data Scientists
Would you want to be a data scientist? Are you one now? Steve Jones talks about this skill that we might appreciate in our daily work.
2011-01-18
428 reads
Editorials
ETL Security Holes
The growth of ETL processes and secondary systems for reporting, decision support and other analysis creates an issue. Steve Jones points out that we ought to be remembering that security needs to be applied to data, not just systems.
2011-01-17
241 reads
The Spring Semester
SQL University is kicking off their spring semester, and Steve Jones is looking to motivate you to participate.
2011-01-17
80 reads
Scaling Up
Would you want to manage a VLDB? Or write the code for an application that uses one? This Friday Steve Jones asks the question of you.
2011-01-14
145 reads
Operating in Failure
Today we have an editorial from Sept 25, 2005 being republished as Steve is on vacation. This one talks about the need to expect failure in our systems and code for it.
2011-01-13
78 reads
The Importance of My Cloud Data
Steve Jones likes the cloud, but doesn't necessarily trust it. After a recent Hotmail outage, he outlines a potential issue that he sees with cloud computing.
2011-01-12
179 reads
NoSQL Basics
Today Steve Jones talks about NOSQL and why it might be important for SQL Server DBAs to understand more about it and be able to talk about when it is appropriate to use.
2011-01-11
707 reads
RAID 5 and SQL Server
Given that disk storage has come down substantially in price over recent years, will RAID 5 continue to be relevant as a storage configuration for databases?
2011-01-10
817 reads
In Case of Breach
Do you know what to do in case of a data breach? Steve Jones talks about the importance of having a "runbook" for security that covers the same types of things you might need to know for disaster recovery.
2011-01-05
151 reads
Welcome to 2011
After the holidays, Steve Jones welcomes everyone in the SQLServerCentral community to the new year and talks about goals and your career.
2011-01-04
176 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers