| A community of more than 1,600,000 database professionals and growing |
| | | Practice Until You Don't Get It Wrong I wrote recently about a bad first day for an intern. He/she was fired, without cause in my opinion, when a production database was damaged while following a document for developer setup. The situation felt like a mistake, and one that wasn't necessarily the fault of the individual. To me, this was extremely poor handling of the situation from a CTO. In the discussion for the piece, someone pointed out that it might not just be a new employee that makes a mistake that causes downtime. Certainly an unexperienced employee could have caused the issue, but I know there are people with lots of time in a position that make similar mistakes. It could be that someone that has been there a long time followed a poorly documented procedure, or applied the procedure to the wrong situation. In sports and the performance arts, I've heard a saying that says: amateurs practice until they get it right, but professionals practice until they don't get it wrong. It's the difference between just gaining a skill that you complete and continuing your learning to ensure that the execution of that skill is ingrained into your being. You internally build the muscle memory and skill to complete a task correctly over and over with practice. In the database world, this might be the difference between someone that has restored a database (the amateur) and someone that regularly practices restores of not only full database backups, but differentials and logs, tail log backups, filegroup restores, and more (the professional). The former has a skill, but the latter is confident and likely to complete the skill in a variety of situations without error. Practice won't prevent mistakes, especially under pressure, but lots of practice does help us learn how to perform better. We learn what options are available, what issues might arise, and which choices we should be making. Just as professional athletes and musicians can make mistakes, we can as well. However, those mistakes should be rare. We should get most things right as the product of numerous hours of working deeply in, and understanding, our craft. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 2.9MB) 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. |
|
|
|
| | ADVERTISEMENT | | | | Register now for SQL in the City Streamed Redgate’s popular SQL in the City Streamed virtual event takes place again this December. Wherever you are, tune in on Wednesday December 13 to watch some of the best-known speakers from the database world present the latest technologies and tools from Redgate. Register free now |
| | | | Extending DevOps practices to SQL Server databases In this demo-heavy session you’ll see how Redgate’s SQL Toolbelt allows you to take a local development database, source control it, set up automated builds and automate deployments to an Azure SQL database in less than an hour using VSTS. Register now |
|
|
|
| | | | | Ron Smith from SQLServerCentral.com A major priority in our industry today is protecting and tracking sensitive data. See how you can utilize SQL Server Extended Properties to do just that. More » |
| | Managing a couple of SQL Servers is a whole different ball game compared to managing 10’s or 100’s of servers. With so much available data to take in, this webinar will guide you through what’s important and what’s noise. More » |
| | Additional Articles Tom wants to check a simple query: How many times has a particular topic been presented and from how many different presenters. More » |
| | Rob Sewell from SQLServerCentral Blogs On the plane home from PAS Summit I was sat next to someone who had also attended and when he... More » |
| | Roland Alexander STL from SQLServerCentral Blogs I came across this in a code review not long ago: Three things pop into my head when I see this... More » |
|
|
| | | Today's Question (by Steve Jones): When turning on automatic plan correction in SQL Server 2017, what options are available? |
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: Administration. 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 | | T-SQL Querying (Developer Reference) Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Junior Galvão - MVP): SQL Server will consider parallel execution plans for queries, index data definition language (DDL) operations, and static and keyset-driven cursor population. You can override the max degree of parallelism value in queries by specifying the MAXDOP query hint in the query statement. You disable parallel execution plans for these statements using which trace flag? Answer: 2528 Explanation: Answer: You can disable parallel execution plans for these statements by using trace flag 2528. References: 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. Intellisense SSDT2017 SSAS - I have recently upgraded to VS/SSDT2017 and I am missing intellisense/colors for the script view of calculated measures. Any ideas? Is... How to trace Invalid query error - Hell experts, A developer is seeing an error like the following, and can't seem to pinpoint the errors in order to... Slow query - client or server issue - If seeing a client make a regular query that uses the same plan but completes in radically different times on... pass table param - How do you pass a table like this? ;WITH TestTbl AS ( SELECT * FROM myTable ) CREATE FUNCTION Ex( TestTbl TableType READONLY) RETURNS VARCHAR(MAX) AS BEGIN DECLARE... Unusually Expensive Deletes - Hi all, I have a scenario on a few of our servers that I can't quite explain that I'm hoping someone... monitor data changes - How do you return all the data changes made to a table (inserts, updates, deletes) the past 2 weeks including... Help with code to Grouping the text in multiple lines - Hello everyone I am a newcomer to the world of TSQL and was wondering if someone can help me with the... Speed up query execution. Can we add an index or rewrite the query - I've been working on this query handed to me by a developer who wanted to reduce the query execution time... Search with Date Range - Hello, I have create table #test_table ( datetime, nvarchar(255), float, nvarchar(255), float, float, URL nvarchar(255) ) INSERT INTO... Table Design - Dear Experts , Please share if there are any standard guidelines for designing the table objects , apart from Normalization , and Column... |
|
| 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
