SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

The Challenge of Failure and of Being Unwired

Today is my last day at work for a couple weeks. Actually, I'm not done yet. I travel to Louisville today forthe SQL Saturday tomorrow and then I return home Sunday. I'll be traveling away on Monday, so this is really my last day in the office. I hope. It's possible I'll realize over the weekend I've forgotten something and need to tackle it remotely, but I'm hoping that won't be the case.

While I won't be completely unable to do anything, I am hoping that I'll remain unwired for the two weeks. We are traveling to remote locations for some of the time, and there might not be cell service, and certainly not wi-fi. There will be some access on some days, as my son is taking an online class this summer and he has work to do, but I'm going to try and stay off email and Twitter, using my phone to just read and take/post pictures.

Getting away from work is a challenge for many of us in technology. Earlier in my career, and for many years running this site, I struggled to take time off. I'd regularly check on the site, even writing editorials at times while on holiday. I can still remember using a public terminal at a hotel years ago to connect with work. In the last few years, I've gotten better, and taking time off for a 6 week sabbatical really helped. I even take all my vacation most years.

That's something that plenty of us still need to learn. I saw a post from someone recently that was on vacation and checking email. There were issues, though a backup person was supposed to handle them. I get the compulsion to check on anything for which you have responsibility. I get the habit of looking at email. I get the desire to just fix things. Those are feelings that I think many of us experience.

What I've learned over time is that most of the work we do isn't that critical. Certainly our employer's systems can affect operations, profitability, and more, but they're not our systems. They're the responsibility of the organization to run, which includes ensuring there are backup resources, human and otherwise, that can manage systems. For those of us that are on top of our jobs, that are the go-to person, that don't just maintain, but actively improve systems, we need to let others make decisions, even poor ones, and bear that same burden. Ultimately that's how others learn and get better.

I experience this as a parent, and I'm sure many of you do as well. We want our children to do better, to avoid the mistakes we've made in the past. We often try to actively manage how our kids live, or prevent them from making a poor decision. Across three kids and many years, I've learned to step back more and allow my kids to fail. It's hard, one of the harder things in my life to not act or say something, but allow them to make a mistake. Even at work I've started to step back at times and hold my tongue if I'm not positive I need to say something. Instead, I try to listen more and accept that things will be less than perfect.

That's OK. We strive to become better, to improve our systems, to increase efficiency, but it's possible to do too much. To overspend resources on tuning, or indeed, not make things better but worse. We can overcomplicate things to the point where others can't understand them, or  perhaps worse, we encourage mistakes from the complexity we've introduced.

Life requires some balance, as do our careers. Work hard, improve things where you can, meet your obligations and take responsibility for your mistakes. Accept that others will make mistakes, and that you are not irreplacible while you enjoy your time away. I'm hoping I will during the next two weeks.

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.9MB) 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
GDPR

How to make your SQL Server development GDPR ready

Redgate’s SQL Data Privacy Suite helps you to build a data catalog of your SQL Server estate, and put in processes to protect and monitor personal information. Find out more about how our tools help with GDPR compliance

SQL Provision

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

Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial

Featured Contents

 

SQL Server Migration

Geoff Ruble from SQLServerCentral.com

Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration. More »


 

SQL Code Analysis from a PowerShell Deployment Script

Database code analysis becomes more important as the team doing the database development gets bigger and more diverse in skills. In this article Phil Factor discusses SQL Code Analysis from a PowerShell Deployment Script More »


 

Why SQL Developers Keep Making The Same Mistakes

Additional Articles from Brent Ozar Unlimited Blog

They learned by reading your old code. More »


 

From the SQLServerCentral Blogs - T-SQL Tuesday #104: Just Can’t Cut That Cord

Jason Brimhall from SQLServerCentral Blogs

We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. Some... More »


 

From the SQLServerCentral Blogs - Finding Inconsistent Key Values–#SQLNewBlogger

Steve Jones from SQLServerCentral Blogs

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as... More »

Question of the Day

Today's Question (by Steve Jones):

I need a new table that contains an XML column. I run this DDL:

 CREATE TABLE dbo.PurchaseOrder ( PurchaseOrderKey INT IDENTITY(1, 1) NOT NULL CONSTRAINT PurchaseOrderPK PRIMARY KEY , PONumber VARCHAR(100) , CustomerName VARCHAR(100) , PODate DATETIME , PODetails XML ); GO 

I now want to index the XML column. I run this:

 CREATE XML INDEX PurchaseOrderXML ON dbo.PurchaseOrder (PODetails); GO 

What happens?

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: CREATE XML INDEX.

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

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services

Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter. The detailed explanation of the Script Task and Script Component foundations helps you develop your own scripting solutions, but this book also shows a broad arsenal of readymade and well-documented scripting solutions for common problems. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I run this code, how many columns are returned in the SELECT and is there an error? (select 2)

 CREATE TABLE dbo.PurchaseOrder (PO VARCHAR(100)); GO BEGIN TRANSACTION ALTER TABLE dbo.PurchaseOrder ADD CustomerName VARCHAR(100); ROLLBACK TRANSACTION; GO SELECT * FROM dbo.PurchaseOrder AS po; GO

Answer:

  • 1
  • No error is returned

Explanation:

ALTER statements can be included in transactions, so no error is returned. The table ALTER is rolled back and only 1 column is returned.

Ref: ALTER TABLE - 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 2017 : SQL Server 2017 - Administration

SSDT 2017/2015 Installation failure on Windows 10 - Hi guys, I've exhausted my  ideas on this one, and no amount of Googling seems to add the matter. I'm having...


SQL Server 2017 : SQL Server 2017 - Development

Need help with the getting a top 1 record with in a table with same ids - I have  a table which have values like this  id date 1  2018-07-16 2  2018-07-18 3  2018-07-19 2  2018-07-19 3  2018-07- 20 1  2018-07-17 1  2018-07-18 I want to...

float error in t-sql scalar function - Hello Everyone, The below code is giving me error: Msg 3623, Level 16, State 1, Line 27 An invalid floating point operation occurred. [code...

Need Help to convert DATETIME result into DATE on SQL Server - How can I convert the result into a DATE datatype as '0001-01-01' isn't supported with DATETIME? I've tried DATETIME2 but...

List event with date range - I have table where an event has a start date and end date. An event might not have a end...


SQL Server 2016 : SQL Server 2016 - Administration

SSIS Catalog / Connection Managers with Expressions - Hopefully I'll explain this to make sense......... Trying to help an organization with migrating to using SSIS Catalog. In their current packages,...


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

LEFT JOIN with CASE subquery ? - I am joining several tables together to do get pricing (a column) based on a code value (a column) and a...

DEVOPS with EDW - Wanted to kick off a discussion about Devops in the context of the enterprise data warehouse (EDW) One of the challenges...

How can convert hex value to decimal in sql server 2012 - How can convert hex value to decimal in sql server 2012

Loading more than 1 billion records from CSV File - Hi Guys Need help. I need to load a very big csv file into SQL Server 2016. The file contains more...


SQL Server 2014 : Development - SQL Server 2014

Sorting and Grouping problem - Hi, I have a table:

Finding a particular date in all tables - HI all, The famous SearchAllTables proc failed to find date values I know exist in my (DateTime) columns.  A quick Google...


SQL Server 2012 : SQL 2012 - General

Recover free space in multi-terabyte db with minimal downtime - We have a multi-terabyte DB that is part of an HA Group, which, due to a lot of archiving now...


SQL Server 2012 : SQL Server 2012 - T-SQL

Throttling the CPU / Disk IO for SQL Restore Option - Hi, I am not sure if this is possible but I wanted to check. We have a Dev SQL Server....


SQL Server 2008 : SQL Server 2008 - General

Domain Group Login Fails - On a SQL Server 2008 R2 (running on Win2003), we have an issue with logins via domain groups - login access...

Linked server permissions issue - Hello everyone, Hope all is well. I have recently setup a linked server from sql server 2005 to mas90 providex database and...


SQL Server 2008 : T-SQL (SS2K8)

String Segregation - Dear all In my table one column i have records in following formets mat201 mat202 sci12 science203 In this above value i want to segregate two...


Cloud Computing : SQL Azure - Development

Error in C# with connectionString CosmosDB - Hi Guys, I have the following error: System.Data.dll Additional information: Keyword not supported: 'mongodb://mycosmosdb:brVmi46RA7azECQro3m2sirrywJAzLdmpxiq6xKr4MK9iFsJdjFpQnX5UfttiGU1lPZg62AE1zo6Amhg==@mycosmosdb.documents.azure.com:10255/database?ssl'. I see that my var have the full connection string:...


Reporting Services : Reporting Services

Replacing " with nothing - Trying to replace any instances of " with nothing. When I try this expression REPLACE(Fields!Name.Value,""","") I get this error: The Value expression for...


SQL Server 7,2000 : T-SQL

Getting SID from Active Directory - SID transformation problems - Hi all, here is the issue: we had an old xp that gets SID from AD, using a domain user name (i.e....

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