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

The Voice of the DBA

The Traveling Data Professional

It's summertime in the Northern hemispheres, and a time when much of the world takes their holiday time away from work. Most kids are out of school for at least part of the June/July/August time period. With many of us workers trying to spend time with our families, this is the part of the year that we schedule trips and events.

Taking time away to be with family is important, but just getting away from work is healthy for all of us. Whether it's a planned trip to some new location, visiting relatives in another city, or even just taking time to enjoy a leisure activity, we all need a break. Some of us will try to do too much during our break, arriving back at work physically worn out. Even in these situations, it's still nice to get your mind away from the environment you face most days. I think any break is good, and especially in the era of smartphones and nearly ubiquitous connectivity, time away is good for your health.

This week, I'm wondering if any of you have plans for an adventure that you're excited about. Are you going somewhere new or engaging in some activity you look forward to? Perhaps you don't have big plans this year, but something you're working towards in the future? Make us jealous and let us know what holiday break might be coming your way.

I've been more of a winter person for most of my life, looking to take time off from work when there's snow on the ground, but I've had my share of summer trips. Usually my family will camp and take a few trips. With my children getting older, I expect to take even more trips when it's just my wife and me. Since I can work from anywhere, I can follow along on some of her horse adventures.

This year we had planned on a long trip to Glacier National Park, but with older kids, scheduling looks to be a bit of an issue, so we'll likely stick to camping in Colorado. However, I am honored to have been chosen to speak at the Data Platform Summit in Bangalore, India, so we'll all have a bit of a vacation in August as we travel to a new country.

Enjoy the weekend and let me know what your plans are this year.

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 ( 3.4MB) 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.

Could your SQL coding be more efficient?

Data Platform MVPs and SQL Server experts share their tips on how to standardize formatting whilst stripping out the repetition of coding with SQL Prompt. Over these 20 short videos we will help you write better, shareable SQL faster. Check out the tips

How to track every change to your SQL Server database

See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more

Featured Contents

Microsoft SQL Server Utilities and Tools

Konstantin Taranov from SQLServerCentral.com

Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 213 Utilities More »

Getting Started with Azure SQL Data Warehouse - Part 5

Additional Articles from Database Journal

In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali looks at performance optimization. More »

Where's the Ops in DevOps? Part 1

Additional Articles from Redgate

In the first of a three-part series, guest bloggers from DevOpsGuys look at the real role of Ops in DevOps. Where it changes, how it changes, and why Ops has an important part to play in the brave new world of DevOps. More »

From the SQLServerCentral Blogs - Data Science Virtual Machine

The Data Science Virtual Machine (DSVM) is a customized VM image on Microsoft’s Azure cloud built specifically for doing data... More »

From the SQLServerCentral Blogs - T-SQL Tuesday #091 – Round-Up

Grant Fritchey from SQLServerCentral Blogs

Thank you to everyone who participated in T-SQL Tuesday #091 which was on databases and DevOps. As I anticipated, this... More »

Question of the Day

Today's Question (by Steve Jones):

What are the options for protecting the encryption key used by a native encrypted backup? In other words, what is my encryptor for the backup key.

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: Backup.

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

Securing SQL Server: DBAs Defending the Database

Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

With ALTER SERVER CONFIGURATION in SQL Server 2016, what options can be set for the diagnostic log? (Choose 5)

Answer:

ON
OFF
PATH (for log files)
MAX_SIZE
MAX_FILES

Explanation:

The options that can be set are: ON, OFF, PATH, MAX_SIZE, MAX_FILES. That's it.

Ref: ALTER SERVER CONFIGURATION - 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 2016 : SQL Server 2016 - Administration

Re-installing a SQL Server Instance - Hi, I have a need to completely uninstall and re-install SQL Server from several servers but I'd like to preserve as...

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

Extract String - FilePath Structure: \\Servername\Temp\Foldername\ABCabcprices-20170621122040.txt From the given filepath need to extract "ABC" from "ABCabcprices-20170621122040.txt". Conditions : Severname and foldername can be any length and filename...

SUBSTRING and CHARINDEX query.... please help. - Hi, I have this table, column, and string: Table = audit_log Column named = request_u Example column value = http://stable-test.test.net/api/files/fs.testcollection/TP-0000000.pdf/download/ What I need to do is return the...

Merging row records where the end date of previous record is equal to start date of next record. - Hi guys, I'm writing a script on SQL and my aim is to merge row records which have the same location...

Copy Table Data - I have a large table that I need to copy. (insert into , select, from ) It brakes with the following...

How to get the monday of every week - example: today (6/20) tuesday Monday =6/19/2017 last week monday : 6/12/2017 Previous last week monday : 6/05/2017 I need to get all the monday's for...

Missing months group by - My data is like below currently- 7 columns below in first table. Date Country P1 P2 C1 C2 R1 2017-03-01 IN 0...

SQL Server 2014 : Administration - SQL Server 2014

Database engine tuning advisor - Hello Using the database engine tuning advisor, is the any way to show how much each individual recommendation will improve your...

find out who / what casued my database to increase in size? - So one of my production databases just grew 100 gb in 10 minutes during the lunch break... its been stable...

Report queque - Does SSRS keep track of reporting running queues? If it does, where I can find it? Thanks

SQL Server 2014 : Development - SQL Server 2014

If statement in T-SQL - Hi guys, I am trying to display item_name with a new category, which says the following term ( i have pasted my...

Where to use ISNULL to convert NULL in PIVOT result set - Hi, I can't figure out where to use ISNULL (or COALESCE) to convert NULL values in the pivot result set to...

SQL Server 2012 : SQL 2012 - General

Alternative to Group by and Having - Hi, I am trying to find customers and their who had made orders more than 10 times from transaction data. Eg: My Query; With...

Permission denied error on object - Executing the query "PROC_ACTION_INSERT ?,?" failed with the following error: "Cannot find the object 'PROC_ACTION_INSERT ', because it does not exist or...

Availability Group Listener not routing ApplicationIntent=Readonly to secondary replica - I'm in the process of setting up a test environment for using availability groups. Our goal is to have our...

SQL Server 2008 : SQL Server 2008 - General

get full path from sys.xp_dirtree - hello all. I have this script: IF OBJECT_ID('tempdb..#DirectoryTree') IS NOT NULL DROP TABLE #DirectoryTree; CREATE TABLE #DirectoryTree ( id int IDENTITY(1,1) ,subdirectory nvarchar(512) ,depth int ...

SQL Server 2008 : T-SQL (SS2K8)

Tsql Query help - Hi guys, I am working on a process where the query to be written seems little tricky to me. I have...

Programming : XML

Inserting data using OPENXML - Hi, I received am xml file from the customer (Around 2 gb data). The xml looks complex. I have to...

Data Warehousing : Integration Services

Expression needed for Midnight of previous day - How to get expression for yesterday and day before so that the time stamp resets *exactly to midnight*? I have Yesterday gives...

Career : Presentations and Speaking

Potential presentation idea: SQL Server for absolute beginners - So, I took today off from work to prepare and travel to SQL Saturday #517, and something occurred to me...

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.