Career Advice for DBAs
Looking to advance your career? Trying to get started as a DBA? Some advice from a DBA with ten years working with SQL Server
2001-07-06
9,106 reads
Looking to advance your career? Trying to get started as a DBA? Some advice from a DBA with ten years working with SQL Server
2001-07-06
9,106 reads
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
2001-07-04
8,832 reads
Steve Jones's review of this classic and reference. A must-have for every SQL Server DBA.
2001-07-04
5,402 reads
2001-07-02
4,054 reads
Ever needed to find the first occurrance of some data. This article looks at T-SQL querying for data in natural order.
2001-06-29
12,638 reads
2001-06-25
7,058 reads
Answers to the SQL quiz that Steve Jones used to give to prospective employees.
2001-06-22
11,607 reads
This article examines the hiring practices of Steve Jones and provides some ideas for how to choose between candidates.
2001-06-22
13,435 reads
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
2001-06-21
10,872 reads
2001-06-20
3,636 reads
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers