SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

In Memory of Robert

I was returning from a trip yesterday when I got an email from a friend that Robert Davis (@sqlsoldier) had passed away. Unfortunately, this happens more and more to me as I age. Family and friends are getting older and some will leave us sooner than we'd like. A Memorial and Grief fund has been set up, if you’d like to contribute.

There are various tributes from Kendra Little, Thomas LaRock, Jen McCown, and likely a few others. Robert was a friend, and I’m again saddened by his passing. If you knew of Robert, either from reading his blog, following him on Twitter, or attending one of his talks in person, you know he was a very intelligent, humorous, and as Tom says, quite generous soul. I was honored he syndicated his blog at SQLServerCentral, but it wasn't because of me or the site. Robert was overly giving of his knowledge, always looking to help others with their problems. He probed and questioned the questioners, trying to ensure that he could provide the best advice and solutions to others.

It wasn't easy, physically, for Robert to always get around, but he made the effort to attend many events in person, and help others even though it was a challenge. I was always pleased to see him in person, shake his hand, and marvel at the lengths he was willing to go in order to help others and share his wisdom and experience. Others have noted his sharp mind and amazing recall. I'll point to the 92,800 tweets he left behind, many of which were in service to others.

Kendra noted his New Year's Resolutions for 2018 included more time for Robert and less work. Those are important mantras for us all.

I encourage people to work on their brand, or their career, or improve their skills. I really want all of you to do those things. Become better craftsman and craftswomen and improve the state of our industry. I want you to work at being better. When I present this live, or even write, I do want you to always keep this in mind.

We work to live; we don't live to work.

Find a balance in life, find time for family, faith, hobbies, and friends. In the last decade, I've lost a number of family and friends, far too many in their 40s or 50s. I'm at the age where I likely have less life ahead than behind me. Each of us never knows how many days we have left.

Find a balance and ensure you enjoy your life along the way.

Robert, you are missed, and I hope Chrissy finds solace and strength in your memories. Please consider contributing to the Memorial and Grief fund.

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 ( 5.1MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

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

ADVERTISEMENT
SQL Monitor

Don’t just fix SQL Server problems, prevent them from happening

SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial

SQL Prompt

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

 

Scripting Tables and Procedures from SSMS

Steve Jones from SQLServerCentral.com

Learn how you can script specific objects from SSMS and store or update them in a git repository. More »


 

Analyze entity data flow in Power BI Desktop using Sankey charts

Additional Articles from MSSQLTips.com

Siddharth Mehta looks at how and why to use Sankey charts and how this can be done in Power BI Desktop. More »


 

From the SQLServerCentral Blogs - Creating Bar Graph In SQL Server 2017 Using R

MarlonRibunal from SQLServerCentral Blogs

Creating a bar graph with R in SQL Server 2017 is relatively easy. It’s just a matter of finding the correct... More »


 

From the SQLServerCentral Blogs - Changing the port for SQL Server in Azure Container Services

Andrew Pruski from SQLServerCentral Blogs

I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure... More »

Question of the Day

Today's Question (by Steve Jones):

I run this query from inside a case sensitive version of AdventureWorks.

 SELECT * FROM AdventureWorks2012CS.Person.Person WHERE rowguid LIKE N'%abc%'

I get zero rows returned. However, if I change context to master and run this, I get these results.

Why?

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 3 points in this category: Case sensitive.

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

ADVERTISEMENT

SQL Server Query Store In Action

The Query Store changes the way you monitor performance on your databases and the way you tune the performance of those same databases. This book represents a deep dive into a large number of topics in and around the Query Store. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I read a bunch of data into a data frame and it looks like this:

 > ncaa.2018 V1 V2 V3 V4 V5 1 20180315 Oklahoma URI 78 53 2 20180315 WrightState Tennessee 47 73 3 20180315 NC-Greensboro Gonzaga 64 68 

I want to set the correct names for columns. How can I do this?

Answer: names(ncaa.2018) <- c("GameDate", "Visitor", "Home", "VisitorScore", "HomeScore")

Explanation:

The names() function is used here. This will assign the combined string vector to the column names of the parameter.

Ref: names() - click here


» Discuss this question and answer on the forums

Featured Script

DB Blocking Automated E-mail Alerting with Blocker SP ID & query's

Subhash Chandra from SQLServerCentral.com

 

step 1.  To enable the blocking alert, you have to create the one monitoring DB with any name, replace the name accordingly in script

 

step 2. create the table DBA_Block_SP_ID

 

step 3. Create the Procedure DBA_spWho2CaptureAlert_Blocking with required change like email ID

 

step 4. Create the procedure DBA_spSendMail with required mail profile update

 

step 5. Create Job (Blocked SP_ID Alerts) 

 

Job will be disabled default, please enable it after checking it end to and test it first at testing environments.

 

Final E_mail will be look like this.

More »

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

Transaction log backup in Logshipping - Hi, Can any one help me with an answer pls. I have my normal housekeeping fullbackup and transaction log backup ,running under...


SQL Server 2017 : SQL Server 2017 - Development

Retreving phone numbers based on phone type - i have a table where it has empid, phone type and phone number one employee has multiple phone numbers. is there...

Removing stored procedures to move to cloud - I got an interesting email today about cutting back on the reliance of the applications on databases and plans to...


SQL Server 2016 : SQL Server 2016 - Administration

SQL Server Agent stops running after changing the default listening port - Dear Everyone I changed the default listening port for SQL Server 2016 standard edition on windows 2012 R2 then i...

Database Mail stuck in INACTIVE status and will not change to RECEIVES_OCCURRING. Cannot send email from test or sp_sendb_mail - Hello All, I'm unable to get Database Mail to send email from SQL 2016 EE server.  When I review test emails...


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

Trying to Get Rid of Cursor for Creating Group Number - Here is the basic scenario, I have a table that can have site values 1-12, each site can have seq...

Db name inside the stored proc - All, I am trying to work on a stored proc that would accept DB as a parameter name and then work...

Developing Extensions for SSMS 2016 - I recently released my extension and wanted to share what I have learned so that others can start creating extensions. SSMS...


SQL Server 2014 : Administration - SQL Server 2014

Shrunk Database - I had a developer remove a bunch of data from a database and free up a big amount of space. ...

Application Name from Profiler - Hi Experts, Trace result is giving application name in hexdecimal values like below. How to find the exact application name. These...

Database too big than .bak - Good day, I have a DB which is 850 GB in size and when i take a full backup the backup...

Moving Database Objects - Hi Experts, We are moving objects of a particular schema to a new database. What all things need to check while...


SQL Server 2014 : Development - SQL Server 2014

I need to divide my total by the QTY, but QTY lives on every row - I hope i explain this correctly I am dealing with BoMs . . . If there are 50 rows of parts, for example, on...


SQL Server 2012 : SQL Server 2012 - T-SQL

Send email alert when SQL Server Agent stops/fails - PowerShell command not working? - I'm testing a PowerShell Script to send me an email anytime SQL Server Agent stops/fails to start. I'm using the...

Preparation of entry list according to subject - Hi, According to the purpose of the output, the output of the last entry on the output date as LIFO IF...


SQL Server 2008 : SQL Server 2008 - General

Updating null fields wehn changing field to not null. - Hi, we have a flat table in SQL server that has no PK field and no constraints. The table is...

Database corrupt - Msg 8966, Level 16, State 2, Line 1 - Server : SQL Server 2008R2 Microsoft Windows server 2008 R2 Msg 8921, Level 16, State 1, Line 1 Check terminated. A failure was detected...

SQL Server Agent Job question - I'm new to SQL Server Agent.  What I want to do is execute a small script to run a stored...


Data Warehousing : Strategies and Ideas

Multiple Calendars Using Kimball Outrigger Technique - Has anyone successfully used Kimball's outrigger technique for multiple corporate calendars in SSAS?  If so, can you share the technical...


SQLServerCentral.com : SQLServerCentral.com Test Forum

imsage test - mage

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.
This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com