Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Mastery – Repetition, Variations, and Depth

Today we have a guest editorial from Andy Warren as Steve is at SQL in the City Brisbane. This piece was originally published on Mar 25, 2015.

I was thinking about repetition today as I worked through setting up Windows authentication for Reporting Services. Have you done that? Get the systems team to install it, set up the service account, fix the SPN’s, change the config file to allow impersonation, and so on. It’s not a terribly hard task, but it’s one I do rarely, so I have to look up the information and puzzle through to get it done. Said more directly, I know the big pieces, but I couldn’t do it blindfolded.

A lot of what we do is like that. We’re given a problem and we work through solving it. Sometimes we learn it so deeply we can do it blindfolded (or at least without Books Online), but sometimes it’s one and done, perhaps never to be done again. Depending on the maturity and growth rate of your employer/client there are tasks you might only do every three to five years.  Is that enough to master the technique?

What does it take to master a technique? It takes repetition and variations, and an understanding a bit beyond just the syntax. We need to do it more than once to embed the rhythm of the solution in our brain and we need to learn how to tinker with at least the major options because the next client may want to use stored credentials instead of Windows authentication for their Reporting Services install.

Solving problems once has value, we can at least talk about what we did and why even if don’t have all the details memorized, but it feels slightly wasteful to exert that kind of effort knowing that if it comes up again later we’ll have to figure some of it out all over again. Some tasks may be worth contriving scenarios to drive more learning (something like AG groups or log shipping maybe), and others may not be (perhaps setting up merge replication or a Service Broker queue), but clearly we can’t expect to master all tasks (unless we have a very small list!).

I think there is value in understanding that. In being deliberate about what we choose to study more and what we assess as not worth more time we move away from guilt and the sense of wasted learning to a more practical view point. It’s not perfect, but it’s realistic.

I’ll add one more idea you might add to your toolbox. When you do something new or solve an interesting problem, write it down. Blog if you have one, but if not just write the steps in Word or Evernote or whatever it is you use. Bullet points, links, comments, whatever you have, and whatever you can write in 5 minutes or so. I think you’ll be surprised by how that reinforces what you learned and by how useful it will be if you ever need to look at the document again.

Andy Warren

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

 
Redgate SQL Provision
  Featured Contents

Create SSRS Data Driven Subscriptions on Standard Edition

bernard.beckett from SQLServerCentral.com

This will allow you to create "Data-Driven" subscriptions on your Standard SQL Server version.

SQL Server String Manipulation using Substring Function in T-SQL, R and Python

Additional Articles from MSSQLTips.com

In this tip we look at how to use substring functions or similar using T-SQL, R and Python when working with SQL Server.

Set your team up for valued software delivery with Unit Testing

Additional Articles from Redgate

There is a constant pressure in software delivery to release at speed and often. However, there is no sense in delivering fast if what you deliver contains errors or is of no value to the customer. Our latest blog explains how database unit testing can set your team up for valued software delivery.

From the SQL Server Central Blogs - Moving to Serverless for Azure SQL DB

Steve Jones - SSC Editor from SQLServerCentral

After the announcement of Serveless Azure SQL Datbase at //build/, I decided to give it a try. I have some Basic databases, so what would Serverless mean for me?...

From the SQL Server Central Blogs - Puzzles and Daily Trivia

SQLRNNR from SQLServerCentral

One of my favorite database automations is to send trivia style questions daily. This helps me to mentor and assess other dba talent within an organization without being too...

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Service Broker Queues

How is a queue represented in SQL Server?

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

 

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Adding Messages

On my SQL Server 2017 server, I want to add a new user-defined error message to the instance. What command should I use that is not deprecated?

Answer: sp_addmessage

Explanation: The way to add user-defined error messages in SQL Server 2017 is still wiht the sp_addmessage stored procedure. Ref: sp_addmessage - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addmessage-transact-sql?view=sql-server-2017

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 - Administration
SQL Server Instance Failure - Monitoring - Hi We've had an issue this morning (and still ongoing) that our main SQL Server has failed. However, we at the beginning there was no indication that the failure was in SQL. Eventually when digging deeper, we noticed that our two instances on our main VM for SQL, both SQL instances were in a stopped […]
prod and stage comparison - Hi all, I can see that identical request is executing much longer on stage comparing to prod. How do I check if it is CPU, memory or hard disk bound? Please advise.
SQL Server 2017 - Development
SQL lookup tables - Hello, I am very new to SQL and would really appreciate some help.   I am using Microsoft SQL Server 2017 to design a database for matching product features to products.   To do this I have created the following 3 tables   Products Spec Lookup The lookup table joins the ID's from the product […]
SQL Server 2016 - Administration
SQL Agent. Run T-SQL in scheduled job against a DB in a different SQL instance. - Well, that's what I'd like to do! This is so I can keep the scheduling config and T-SQL on one admin SQL Server, whilst the databases reside on different servers. This'd mean I can email using SQL Mail from my admin instance too. I'm seeing a few things that might be of interest, in Linked […]
SQL Server Transactional Replication - We are uplifting one of our servers to SQL Server 2016. We are going a side by side install.  The machine we are doing the uplift is the Publisher. The distribution and subscriber server are not being touched. this is a push not a pull. So I'm thinking I will have to reinitialize the snapshot. […]
Linked server error 18456 - Hello Team, Iam getting the below error while creating the Linked server with windows authentication. Msg 18456, Level 14, State 1, Line 88 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.    
SQL Server 2016 - Development and T-SQL
PDF stored in table as varbinary max, how to convert and display it SSRS report - Hi , I have a table where  10000+ pdf stored in table as varbinary(max) How to convert them with T SQL  to display in SSRS Report as images? Thank you      
Indexing VARCHAR. Does Length Matter ? - We have some TXT file imports into SQL tables. As a default, the columns are set to varchar(500) to match the incoming definition. However, the data will never be 500. Is there a penalty to indexing a VARCHAR(500) column, if the max length will be 50, compared to defining a VARCHAR(50) column and migrating the […]
SQL 2012 - General
Table type - I just want to validate my use of a custom type. I'm doing a query on that I need to pass an unknown number of string values to. I created a custom table type, with a script that looks like, What length should I make the field, for it to be of use to others? […]
How to save collapse sections of the query window and save it like that - Hi, My manager would like it that when he collapses certain parts of the query and saves it, it will open that way; and not have it all expanded. Is there a way to do this? Thank you
How to list counts hour by hour - Hi, Below I have a sample of the output, and below that is a sample of how the data is stored in the database. I am trying to figure out how the queried this to get the calls per hour, I looked online but could not find anything exactly like this maybe ai am sating […]
SQL Server 2012 - T-SQL
sql server 2012 data column used for 7 different languages - In a sql server 2012 database, I want to store some messages in the database for the following languages: Karen, Arabic, Nepali, Burmese, and Kiswahili. This would be in a column called stringtemplate that is currently defined as varchar(max). **note: this column currently stores messages in English and Spanish. Can you tell me if I […]
SQL Azure - Administration
Azure data sync - Hi, I've automated the schema change propagation to the member database using this approach: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-update-sync-schema The schema changes go through fine. I've run : alter table mytable add blah varchar(20) go update mytable  set blah = 'blah' go I could see the column 'blah' on the member database, but the update did not go through. […]
SQLServerCentral.com Website Issues
What happened to marking as answer? - Hadn't noticed this before, as I don't I hadn't posted any topics that are asking a question, but I noticed that the mark as answer button has gone. Guessing that it wasn't used often and so removed, but just checking in case I was going crazy.
Job Postings
DBA vacancy at Sheet Music Direct - Milwaukee, WI - SheetMusicDirect.com, a division of Hal Leonard, is the world’s premier destination for digital sheet music. Offering musicians around the world access to instantly downloadable sheet music and all-access streaming sheet music via its popular subscription, PASS, SheetMusicDirect.com is looking for a talented and motivated SQL Server DBA to join us in revolutionizing the digital sheet […]
 

 

RSS FeedTwitter

This email has been sent to {email}. 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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -