A community of more than 1,600,000 database professionals and growing

The Voice of the DBA

After Six Months On The Job What Challenges Remain?

Today we have a guest editorial from Andy Warren as Steve is traveling.

The first days and weeks of a new job can be frustrating as you try to learn what is where and who is who, and then you get to the fun part – figuring out all the stuff that needs to be fixed and then fixing it.

Did I say fun?

Think about how many times you’ve walked into an environment that has incomplete or missing jobs for standard maintenance tasks. No backup to tape. Jobs that fail randomly. Slow queries, duplicate indexes, duplicate stats, orphaned users and dead logins. Business processes that are clunky. Probably some processes that are out of date or just plain missing documentation. We typically come up with a good sized to-do list in those first few weeks.

That list might be daunting, might make us groan at some of the things we find, but it’s a chance to do work that makes a difference and puts our own stamp on the environment. The first few months of a new hire also tend to be the time when the business is most open to changing things. It takes time to do some of the work. Some of the changes will have to be approved and discussed and scheduled, but eventually you’ll get the list done. Or as done as possible.

That’s fun isn’t it? You’ve fixed the problems and learned the systems, crossed off the things on your to-do list. Now what? Do you sit back and enjoy the order you’ve brought to chaos? Or do you make another sweep and try to drive the quality of the environment higher still? A little bit of both?

At some point you’ll have fixed the easy stuff and a lot of the harder stuff until you get to diminishing returns. Is that what you aspire to, or is that the point at which you get restless and start looking around for new challenges and even a new job? I don’t think there is a right answer, but understanding your answer might go a long way in helping you pick the right jobs and enjoy the jobs you pick.

Andy Warren from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

Database migrations inside Visual Studio

Feeling the pain of managing and deploying database changes manually? Redgate ReadyRoll creates SQL migration scripts you can use to version control, build and release, and automate deployments. Try it free

SQL in the City Streamed – Compliant DevOps: June 20 2018

Join Redgate’s livestream on June 20 and learn from Microsoft Data Platform MVPs, Steve Jones, Grant Fritchey and Kathi Kellenberger. The schedule will include sessions to help you learn how to demonstrate compliance with regulations such as the GDPR, HIPAA and SOX. Find out more and register for free

Featured Contents

SQL Server Database Corruption Detect

Pauline Xiong from SQLServerCentral.com

How to detect DB corruption ASAP... More »

Reducing risk with Smart Recommendations in SQL Census

Redgate are reducing risk with Smart Recommendations in SQL Census More »

Databases with MAXSIZE Set

Additional Articles from Database Journal

Every DBA needs to appropriately manage database growth. No DBA wants an application to fail because the database is out of space. A database can run out of space a number of different ways. One of those ways is to set the MAXSIZE of a database. When the database grows to the MAXSIZE the database will not grow anymore and if someone tries to add more rows they will get an error saying the database is full. More »

From the SQLServerCentral Blogs - Plan Metrics Without the Plan: Trace Flag 7412

Grant Fritchey from SQLServerCentral Blogs

I place a lot of emphasis on capturing actual execution plans because of the runtime metrics, but with Trace Flag... More »

From the SQLServerCentral Blogs - Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?

Solomon Rutzky from SQLServerCentral Blogs

Demystifying What “sqlservr -q” Actually Does (last updated on 2018-06-13) For various reasons, people sometimes find themselves in the unfortunate (and unenviable)... More »

Question of the Day

Today's Question (by Steve Jones):

My SQL Server 2017 instance is a busy system with a high workload. I have 64GB of RAM on the host. What should I set SQL Server to use for min and max server memory? SQL Server is the only server application running on this host.

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Memory.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload.

Pick up your copy of this great book today at Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Raghavender Chavva):

In SSMS v1.7, how many types of authentication for a SQL Server are allowed?

Answer: 5

Explanation:

In SSMS v17.7, there are 3 new types of authentication types in addition to Windows and SQL Authentications. There are:

Windows Authentication
SQL Server Authentication
Active Directory - Universal with MFA Support
Active Directory - Password
Active Directory - Integrated

Source: Connect to Server - click here

» Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2017 : SQL Server 2017 - Administration

Need VM for practice - Hi, A question for DBA's. If I cannot find Sand Boxes in our environment for some reason, is there a...

SQL Server 2017 : SQL Server 2017 - Development

Count of values in column - Hi Friends, I'm a newbie. But I was wondering if i had an employee table joined with a department table with a...

SQL Server 2016 : SQL Server 2016 - Administration

Diagscan Tool - Hello Where to get the Diagscan Tool? This is another useful tool like Nexus. Kindly advise how to get it

SSRS 2016 - HTML5 rendering issues - Hello, We migrate reports from a SSRS2012 Instance with Sharepoint integration to a SSRS2016 Instance in native mode and we encounter...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

query performance - Hi, I have this execution plan and a query which run more than 10 h.Please help me with some performance tuning recommendations. UPDATE h

DelimitedSplit8k and Performance - I am working on taking data out of an ERP system and into a data warehouse. One of the unfortunate...

SQL Server 2014 : Administration - SQL Server 2014

Excessive Paging Continues... - We've been experiencing "excessive paging" for a while (per perfmon review). Application is sluggish. Added memory to the server (virtual machine), there's...

The transaction log for database 'database_name' is full due to 'XTP_CHECKPOINT' - Hi Gurus, I'm new to SQL Server. We got an issue on our Production Server at this moment and i'm having...

SQL Server 2014 : Development - SQL Server 2014

Joining a large table to itself....better ideas? - Hello all, I'm creating a view to use for future queries to make things easier. Essentially this view needs to join...

SSRS Grouping Problem - I have a report that has a dataset problem that I'm not sure I can fix. The query for it...

SQL Server 2012 : SQL 2012 - General

Auditing copy/paste from a spreadsheet - I have been asked to audit users who are pasting data into a table by right-clicking it, and choosing "Edit...

High CPU during specific timings - Hi All One of our critical database servers is facing high CPU utilization during a particular time every weekend . I try...

SQL Server 2012 : SQL Server 2012 - T-SQL

Help needed on TSQL query: update using a self join - Hi Experts, Need help on an update query. I want to take all status = 'IN' records qty values and update those...

Return last amount larger than 0 - Hi guys, I have a table of accounts by month. I need to return the last amount larger than 0 e.g Unique_ID DATE CLOSING_CREDITS CLOSING_DEBITS 00522467364634 2017-03-01 0 ...

carving out bussiness hours. - so i'm newish to SQL and SSRS but i'm working on a report that allows me to calculate average times...

SQL Server 2008 : SQL Server 2008 - General

The transient database snapshot for database 'DB1' (database ID 5) has been marked suspect due to an IO operation failure. - I have looked all over google regarding 'snapshots' in SQL 2008 and I have been reading up on their function...

SQL Server 2008 : SQL Server 2008 High Availability

SQL server 2008 R2 frequent transaction log full and my database is a mirrored one. - I have 1 pair of identical server with SQL server 2008 R2 is installed.I have 2 databases in it which...

Reporting Services : SSRS 2016

Using a Temporary Table in SSRS - Hello, I have created a temporary table in SQL Server Management Studio.. I want to use in in SSRS so...

SQL Server 2005 : Backups

Taking backup with option "Disk = nul" - hi , can anybody tell me what exactly below backup query does ? and where it keep the backup file after taking...

SQL Server 2005 : SQL Server 2005 Integration Services

SSIS Package Error - VS_ISBroken - Hi, I'm using the following : SQLServer 2005 SSIS Version 9.00.4035.00 I have a data flow task within an existing SSIS pkg....

This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected].

This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.