Normalizing Performance
Determining the best performance value you can get for your effort is not as straightforward as you might think.
2014-11-03
210 reads
Editorials
The Geek Costume
This Friday Steve Jones has another fun poll. A question on the geek costume that might excite you the most.
2014-10-31
175 reads
Stuck in a Rut
What do people do when their job doesn't require a lot of technical skills? Steve Jones has a few thoughts.
2014-10-29
168 reads
Triple Digits
Salaries for data professionals have risen quite a bit, according to the latest salary survey. That's good for those of us working with SQL Server.
2014-10-28
235 reads
Managers: who needs them?
Managers, look away now. Patrick Index wants to get something off his chest...
2014-10-27
326 reads
When is 8000 too small?
Over the years the page size in SQL Server has changed, growing larger to fit larger data sets. However not all functions have been modified to work with larger page sizes. Or even exceed them. Steve Jones wonders if it's time to increase the page size.
2014-10-23 (first published: 2010-02-11)
394 reads
Why Would You Move?
Most people prefer to work with the platforms that they are familiar with, but there is always pressure to try new, exciting technologies when others have success. Steve Jones explores the idea of switching platforms.
2014-10-20
165 reads
It's about Perception
What's the most important thing about your application? The code? The accuracy of its calculations? The layout of the reports? Steve Jones has another opinion.
2014-10-17 (first published: 2009-12-09)
204 reads
Who Watches the Watchers?
Who checks on those who manage our systems? Is there auditing in place for those accidental DBAs?
2014-10-16 (first published: 2009-12-03)
325 reads
Document, then Install
Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.
2014-10-13
121 reads
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers