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

Featured Script

Prevent accidental DB drop\delete

The Voice of the DBA

The Short Summit

This week is the 2018 PASS Summit, the largest conference devoted to SQL Server and the Microsoft Data Platform. This is the 20th Summit, and I'm sure there are a few people that have been to all of them. I think I've missed 3, though I was at the first one and I'll be there later this week for a short trip.

The annual Summit used to be an event that I looked forward to most of the year, a time when I'd see friends from all over the world that I only saw in person once a year. I might email, tweet, etc. with them many times, but the PASS Summit was one of the few times we'd be able to shake hands and really talk with each other.

The world has changed a bit, with many more SQL events from SQL Bits, SQL Saturdays, Data Relay, and more that take place all over the world, and at every time of the year. If you want to talk data platform with colleagues, get inspired, learn something, or just share a beverage, you have many different opportunities each year. I get to more than my share, and I see many of my friends multiple times a year. I love that, but I also miss the excitement of there being just one event.

That isn't going to change and we'll continue to have multiple events. I do think the PASS Summit is still the best place in the US to get excited about the data platform, talk with Microsoft developers, and share information with your peers. There are lots of social events, and if you get the chance to attend, it's an action packed week. You should plan on being busy, being tired, and talking to lots of people. Attend parties, for the networking if for no other reason, and engage with others.

Unfortunately I won't do much of that this week. The timing this week is worse for me, personally, and I'm a little worn out from other events and travel this year. I'll arrive Thursday and leave Friday, making this the shortest trip ever for me to a PASS Summit. I know I'll be tired, but it's always great to see friends and meet new people. Please, don't hesitate to say hi, shake hands, or take a picture with me if you're there.

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

Redgate University

Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers.
Start Learning

NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps

With SQL Provisions virtual cloning technology, databases can be created in seconds using just 1MB of storage, and sensitive data can be anonymized or replaced with realistic data to ensure it is protected as it moves between environments. Download your free trial

Featured Contents

Import flat files to SQL Server on Linux using Azure Data Studio

Carlos Robles from SQLServerCentral.com

Have you ever wonder how to import flat files to SQL Server on Linux? In this article, I will share my experience loading data to a Linux SQL Server instance using the new Azure Data Studio data import extension from macOS. More »

Azure and Windows PowerShell: Using VM Extensions

Additional Articles from SimpleTalk

In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during the provisioning process. More »

SQL Prompt as a Layout Tool: A Survival Guide

Phil Factor's guide to taming SQL Prompt layout options, and getting it to format code just the way you like it. More »

From the SQLServerCentral Blogs - Better Keyboard Extensions in Azure Data Studio

Steve Jones from SQLServerCentral Blogs

I used to use ALT+X to execute queries in SSMS. I spent years with this shortcut, but as I started... More »

From the SQLServerCentral Blogs - Identifying delays between SQL calls using SQL profiler

david.fowler 42596 from SQLServerCentral Blogs

One of the common goto methods for query specific slowness which can be replicated via an application can be to... More »

Question of the Day

Today's Question (by Steve Jones):

When I create a schema, I can optionally specify an owner. What are valid owners for the schema?

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

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

Expert T-SQL Window Functions in SQL Server

Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

Which of these are valid values for the second parameter of QUOTENAME()

Answer: brackets, parenthesis, braces, backtick, angle brackets, double quotes, or single quotes

Explanation:

You can use any of these characters:

"
'
{}
[]
`
<>
()

Ref: QUOTENAME - click here

» Discuss this question and answer on the forums

Featured Script

Prevent accidental DB drop\delete

Subhash Chandra from SQLServerCentral.com

Script removed as this is a plagiarism violation.

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 - Development

DT_BYTE to DT_DBDATE - I've got an SSIS project pulling data from a MySQL database into SQL Server. One of the date values in the...

SQL Server 2016 : SQL Server 2016 - Administration

synonyms vs views when using a linked server - Forum, In our current environment where we have 2 domains 1-PROD 2-DEV we usually restore previous night 6pm backup daily to...

Full Backup Files - Fastest Way to Copy Over WAN - Hi, I am trying to Robocopy large .bak files over the WAN and it's going terribly slow. The full backup files...

How To Truncate Log with Transaction Replication - I am running a transactional replication and seeing the transaction log growing in the publisher database; it is a little...

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

OPENROWSET - issue with spaces in the file name - Using SQL Server 2016. I am trying to read an Excel file using OPENROWSET. This works perfectly: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0...

SQL Server 2014 : Development - SQL Server 2014

TSQL query suddenly taking hours to run - Hi, I have a query that has suddenly started taking hours to run instead of a few minutes. I have tried...

Date Field Calculation Logic - Can somebody please help with this issue... /* Here’s the problem: Let's say we had a table of all US Presidents, with...

SQL Server 2012 : SQL 2012 - General

????????????NYU??Q/?457202606?????????????????????????????New York University - ????????????NYU??Q/?457202606?????????????????????????????New York University QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2.

???????????RU??Q/?457202606????????????????????????????? Rutgers University - ???????????RU??Q/?457202606????????????????????????????? Rutgers University QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??

????????????????UMN??Q/?457202606????????????????????????????? University of Minnesota Twin Cities - ????????????????UMN??Q/?457202606????????????????????????????? University of Minnesota Twin Cities QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1.

?????????????MSU??Q/?457202606????????????????????????????? Michigan State University - ?????????????MSU??Q/?457202606????????????????????????????? Michigan State University QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ????????????

???????????UMich??Q/?457202606?????????????????????????????University of Michigan, Ann Arbor - ???????????UMich??Q/?457202606?????????????????????????????University of Michigan, Ann Arbor QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ?????

??????????NEU??Q/?457202606????????????????????????????? Northeastern University - ??????????NEU??Q/?457202606????????????????????????????? Northeastern University QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ????????????

?????????????KSU??Q/?457202606????????????????????????????? Kansas State University - ?????????????KSU??Q/?457202606????????????????????????????? Kansas State University QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ????????????

???????????KU??Q/?457202606?????????????????????????????University of Kansas - ???????????KU??Q/?457202606?????????????????????????????University of Kansas QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ?

?????????????????UIC??Q/?457202606?????????????????????????????University of Illinois at Chicago - ?????????????????UIC??Q/?457202606?????????????????????????????University of Illinois at Chicago QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ?

What can be the benefits of copy_only backup - Dear Folks, I want to understand what could be the benefits of copy_only backup except independent with the existing log chain

Concatenate Strings in a COLUMN using comma delimiter, I need some nice code. - Please run my code and you will see what I mean. So I like to concatenate values in a column and...

SQL Server 2008 : SQL Server 2008 - General

Flag record change - Hi All, create table #pick ( Member_id INT, ApplicationID VARCHAR(30), Product varchar(5), EffDate Date, TermDate Date, AppRecDate Date ) insert into #pick select '200394', '2-16461538', 'A100', '1/1/2017', '7/31/2018', '12/18/2016' union...

SQL Server 2008 : SQL Server Newbies

Calculate Month Over Month - Hi , I want to calculate month over month change for below data Date platform Value 09/04/2018 X 2345 09/05/2018 X 2678 09/06/2018 X 2673 10/05/2018 ...

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.