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

The Voice of the DBA

How are you recharging this year?

This is the end of the first half of the year. I'm hoping it's been a good half year for you, as it has for me. I've traveled less, done a few more things outside of work, but had a good time at work as well. I've had to work on some projects and content that are engaging and fun. I'm looking forward to the next half of the year.

No matter how much we enjoy our career, we all need to get away from work at some point. It's important. We would love the perfect work-life balance, though I don't know what that means or if it's possible. You can make your job a little better taking some time to get away from work and getting refreshed and recharged. Today, I wanted to ask about your plans this year.

How are you recharging?

I just got back from a vacation with my wife. I had to travel for work and she came with me, putting up with a couple days of my work commitments before we took a few days to tour and enjoy the west coast of Ireland together. We are trying to do that more as my kids get older and more independent. We've taken a few trips over the last couple years and have another one planned later, when she'll travel with me to Norway.

It's not just work trips. We also have a long family vacation planned in July, with two weeks of camping as we drive up to Glacier National Park and try to keep everyone mostly unwired. We'll see how it goes, and certainly my middle son will need some connectivity as he's in the middle of Linear Algebra and C++ programming classes, but hopefully the time will be minimal. Maybe I'll get to watch him code some C++ and remember how glad I am that I don't have to do that anymore.

Let me know today if you have any plans for this year (or if you've already competed them). It's always neat to hear the ways in which people look to spend their spare time. If you haven't made any plans, I'd suggest you stop for a few minutes and think about how you might recharge away from work and try to get some plans in place.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.3MB) podcast or subscribe to the feed at iTunes and Libsyn.

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

What’s the top challenge faced by SQL Server professionals in 2018?

Learn how 626 SQL Server professionals monitor their estates in our new report on the State of SQL Server Monitoring. Discover the challenges currently facing the industry, and what is coming next. Download your free copy of the report

Become a more efficient SQL developer with SQL Prompt

Learn how to write SQL faster and more efficiently with these exclusive short videos from Data Platform MVPs and SQL Server experts. With SQL Prompt you can strip out the repetition of coding and write SQL 50% faster. Check out the tips

Featured Contents

Foreign Key Indexes and Binding

Steve Hood from SQLServerCentral.com

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes. More »

Data Governance, DevOps, and Delivery

Additional Articles from SimpleTalk

Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to all aspects of continuous delivery. More »

Introducing Microsoft BI Reporting and Analysis Tools

Additional Articles from Microsoft MSDN

Choose the right BI tool by learning about the different strengths of the Microsoft analysis and reporting tools. Microsoft provides a variety of BI tools that can address key workloads, such as Power BI and Excel. The article discusses the workloads and the tools that best support each workload. More »

From the SQLServerCentral Blogs - DevOps Debugs the Demo

Steve Jones from SQLServerCentral Blogs

I had my 24 Hours of Pass session today, Database DevOps to Ensure Compliance, and my demo broke. At least,... More »

From the SQLServerCentral Blogs - Respectfully Responding

SQLEspresso from SQLServerCentral Blogs

I typically don’t write opinion posts, but given recent events I thought it was important to follow up on one of my tweets.... More »

Question of the Day

Today's Question (by Steve Jones):

What are the defaults for the automatic tuning feature in Azure? (choose 3)

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: Azure SQL database.

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

Exam Ref 70-765 Provisioning SQL Databases

Prepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have a Windows host running SQL Server 2017. I want to log ship my Sales database to another instance for HA and DR purposes. What are my options for the second instance? Choose 3.

Answer:

SQL Server 2017 on Windows
SQL Server 2017 on Ubuntu
SQL Server 2017 on Docker

Explanation:

If I want to enable log shipping for SQL Server 2017, I can do this for any other SQL Server 2017 version, on Windows, Linux, or Docker. I cannot log ship to Azure.

Ref: Get started with Log Shipping on Linux - click here

About Log Shipping - 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

SQL Server express 2017 Limitaions - Hi, What are the limitations of SQL Server express 2017 Limitations. How to enable Sql Server Agent in

SQL Server 2017 : SQL Server 2017 - Development

Need to display a column with deleted overlapping dates - I want to get rid of the following overlapping records from the table and display the below output. Also, I...

SQL Server 2014 : Administration - SQL Server 2014

DB in Recovery Pending - Hi Guys/Gals I thought I'd just come straight to the experts. I have a important DB in a Recovery Pending state,...

SQL Server 2014 : Development - SQL Server 2014

db_owner - do i need to be database owner to change table definition from SSMS? I am not able to do that...

Understanding Deadlock - Dear Experts, Myself created a deadlock situation to better understand it. The process created a deadlock involving multiple process but I...

SQL Server 2012 : SQL 2012 - General

Migrating data from one server to another - Hi Is there any way other than export and import where we can migrate data from one server to another. Thanks

Rollup/Aggregate tables and maintenance - Hello, We have numerous customers, each with their own database and in those databases we have a table called jobs. This...

SQL Server 2012 : SQL Server 2012 - T-SQL

Automating activity logging - Hi: So I found this great script here on SQL Server Central that allows me to query my database to see ...

Please help - complete missing data with latest recorded - Hi there, I have been stuck on this for days and I need submitting this report in the next two days. This...

SQL Server 2008 : T-SQL (SS2K8)

Find Receipt entry against invoice - Hello experts I need some help regarding SQL query, I have a table to save invoices and receipts against invoices. need a query...

Any better way of querying multiple tables based on a column value? - Hi all,I often have situations where I have a table which stores, in two separate columns, a value and a...

How to read list of files in folder using T-SQL? - Does anyone know how to read files from spesific folder/path using T-SQL? Regards, Eko Indriyawan

SQL Server 2008 : Security (SS2K8)

Grant Execute on an SP - Hi All, I've two databases on a server , DB1 and DB2. There is User1 who has Read\Write on DB1 and no...

Reporting Services : Reporting Services

Highlighting of changeable data using a "colour table" - I am a lone, and originally accidental, DBA, so would very much appreciate feedback on a solution I have come...

Programming : General

Odd results from WHERE in SQL - So I have a bit of VBA put together to manage the output of data based on selections made from...

Programming : SSDT

SSDT install fails in VS 2017 enterprise edition - Hi , I am unable to install SSDT for integration services for Visual Studio 2017 . I downloaded Analysis Services and reporting...

Data Warehousing : Integration Services

Granting SSIS access to developers - I'm trying to give access to our developers to SQL 2012 Integration Services without granting server admin, following the procedure...

SQL Server 2005 : Backups

Issues while backing up to the network - I am having some issues dealing with some of the back jobs that run on a SQL Server 2005 machine....

SQL Server 7,2000 : T-SQL

Sort column without ORDER BY - Is there any method to sort a column(numeric) without using ORDER BY clause.

Career : Certification

Exam 70-461 - Hi, Ive just ordered the book: Querying SQL Server 2012 Training Kit. I am planning to take the exam 70-461 within...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.

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.