| A community of more than 1,600,000 database professionals and growing |
| | Thinking Time I've been fortunate in my career to meet a lot of different people with a variety of views on the world, career, technology, and more. I've learned a lot about various things by focusing on conversations with these people and getting alone time with them, just talking. This is one reason I make it a point to get a couple quiet, focused conversations with a few person at events, and I'll usually bail out of dinners with more than 6 people. They're just too chaotic and less attractive to me when I'd rather have an engaging chat. I was reminded of a few pieces of advice I've received in life while watching Jes Borland's keynote at the Chicago Code Camp. It's a nice talk, and worth a bit of your time to help you reset your view of the world and remember to choose the things that matter to you. Certainly Jes' advice to learn to say "no" is some of the best advice I've ever learned in my life. I'm still trying to get better at this, but I am learning to let some opportunities go by and not agonize. Time is far and away the most valuable resource I have in life, and I value it more each day as I age. One of the best pieces of advice, though, came from @sqlandy. Years ago, as we were both working full time jobs and keeping SQLServerCentral going at night, he let me know that we were treading water, just doing the same things we'd been doing and thinking about driving our enterprise forward. He'd noticed the same problem at work, with so many people letting themselves get caught up in day to day tasks and not looking ahead. We end up worrying about getting a query done, or checking a server, or writing an email, updating our resume, getting dinner cooked, and we are not coming up with ways to improve their job, career, life, server monitoring, development habits, and more. We're not actively moving in a direction that matters to each of us. Jes reminded me of the need for thinking time in her keynote. We all need some time that isn't devoted or focused on a task, or a particular endeavor. We need time that let's us just think about anything, or everything related to a topic. Unstructured time that lets our mind wander over possibilities, opportunities, or even evaluating some course of action. Time away from a keyboard, time to think about how you might change your world. I often find running or swimming is good time for me. Taking a known route, not worried about speed or pace, just plodding along and letting my mind wander. Sometimes I'll even end up walking, or sitting by the side of the pool, just thinking because my body won't move on automatic when I get deep in thought. I have sometimes tried to just sit and think, staring out the window, letting my thoughts take me where they will. Life is busy, and it's easy to get caught up in all the demands on our time. It's even easy to get caught up in trying to relax and focus on a task (cooking, playing games, etc.). Taking some time to think about a topic in an unstructured way, without any goal or outcome is important to help us evaluate and review where we are, and where we might want to go in some part of our life. 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 ( 5.5MB) 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 | | New SQL Monitor Reporting Module SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial. |
| | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more. |
|
|
|
| | | Daniel Calbimonte from SQLServerCentral.com In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse. More » |
| Additional Articles from SimpleTalk Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it eliminates the need to deal with the Storage Account. It is now easier to add new disks to a virtual machine, either in PowerShell or via the portal. The Storage Spaces feature in Windows Server can be used to aggregate disks together and obtain higher levels of performance. Joshua Feierman explains how to do it all. More » |
| Additional Articles from Redgate Have trouble keeping track of your SQLServer estate? Redgate Foundry are currently researching the area - here's what they've been up to, and how you might be able to help. More » |
| CYates from SQLServerCentral Blogs “One of the advantages of being disorderly is that one is constantly making exciting discoveries.” While this quote is true... More » |
| Ed Elliott from SQLServerCentral Blogs A teams maturity shows in its choice of tools. I have seen quite a few different development teams in wildly different... More » |
|
|
| | Today's Question (by Robert Eder): Waht is the result data type for the query below? SELECT CAST(3.1415927 AS decimal(38,10)) / CAST(10000 AS decimal(38,10)) Result; |
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. 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 | 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): I want to clear the Query Store in my Sales database in SQL Server 2016. What command should I use? Answer: ALTER DATABASE Sales SET QUERY_STORE CLEAR Explanation: The ALTER DATABASE command is used with the SET QUERY_STORE CLEAR option. Ref: Monitoring Performance Using the Query Store - 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. owner of db file - Hi, I just checked and the owner of db file of a critical db server is blank, when I set it... Log Shipping - Exclusive access could not be obtained because the database is in use - Hi, We have been facing an issue with Log Shipping. Few databases struck in Restoring status. If we check the properties... SQL Server 2016 RTM (13.00.1708.0) Database Mail Not working - Hi Does anyone have database mail working with SQL 2016 (Standard Edition) and the Critical update 3164398? I've configured DB mail on... Slow Full Text Search on New Server - Got a new SQL Server, running SQL 2016 on Windows Server 2016. This VMWare at our hosting site. Server properties show... Why does this amended JOIN cause a syntax error. - I wish to change this SQL: SELECT CONVERT(varchar(2), Data.WeekNumber) AS WeekNumber, CONVERT(DECIMAL(18,2),SUM(Purchases)) AS Purchases, CONVERT(DECIMAL(18,2), SUM(Data.PurchasesMinusWarrantyParts)) AS PurchasesMinusWarrantyParts, &nb Casting data from old table to a new one and changing its type - I'm using SQL Server Management Studio. There is a table called Agreement in my database containing dates which are stored... Client Upgrde - I need to upgrade SQL 2008 client to SQL 2016. How to do it?? do I need to uninstall SQL 2008? Deadlock with two update statements - Hi Guys, I am getting a deadlocks recently on one of my instance of SQL Server. Below are the two statements... Oh double hop, you're so fun ... Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. - I've fought this issue so many times over the years and perhaps I'm old and rusty, but I'm having a... How can I see a DEPENDENCY TREE for objects used inside SP1 Stored Proc, and for each object referenced further inside each object, etc.? - ------------------------------------------------------------------------- -- NESTED DEPENDENCIES: -- the SQL below does not show all objects -- (for example, if table is from other DB, it is... Querying Postcodes gracefully - Recently I've been getting an influx of requests asking me if I can find clients on our system that have... Getting error 18456, need help in figuring out what's wrong - We've got a test user we're using to test how our new app will work. I can't connect, while logged... Query for status - Hi guys, I am working on a requirement where I am not finding any efficient way to get the desired... Cluster resource failover is not happening after upgrade of service pack3 and GDR security patch . - I have Upgraded SQL server 2008 r2 service pack 3 in the passive node of the cluster server PROD-01 . After... Procedure Doing Only Select - I have a complex procedure having multiple case statements which only select data from multiple table. But when i ran... Deleting .bak files - Greetings. I am using SQL Server 2008 R2 Express. I want to delete some old backup files, but I am... Connecting to two different databases from the same report on different server paths - Hi everyone! Does anyone know if it's possible to deploy a report to two different server paths on the same reporting server each... No PKs on fact tables - I just inherited a data warehouse where none of the fact tables have a primary key (all fact tables are... There is insufficient system memory to run this query. - SQL 2005 Ent. Edition - 64 Bit (9.00.4035) Running on Win 2008 R2 - 64 Bit 64 GB of Ram SQL Configuration: 58000 MB (Max) When... Calculating age - hi friends i have Date of Birth column in my database , i dont have age column i want to calculate accurate... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|