| A community of more than 1,600,000 database professionals and growing |
| | Using Tools That Fit Today we have a guest editorial as Steve is traveling. As IT professionals and knowledge workers, we don’t need much in the way of personal equipment. A carpenter or plumber might have as many as 100 tools along with assorted items to support their daily work. What do we need? A computer, monitor, keyboard, mouse (or trackball or trackpad), a place to sit or stand, and probably a chair. Given that you have all of those items, which matters most, or at all beyond having it? Not a question with a one size fits all answer, but still interesting. At work I use a name brand $20 wireless keyboard. It works. I can’t say I’m less productive because of it. Same for the mouse. Dual 23” or 24” monitors, an OK, at best, chair, and a nice standing desk. Better than some places for sure. At home I use three 27” monitors, a standing desk, a USB dock, a chair I like, a mechanical keyboard I like, and now that I think about it, an OK mouse. The monitor arm I use at home is on the list to be replaced - functional, but just not what I want long term. Three 27” monitors is perhaps right on the edge of too much. They are close to 6 feet from side to side even when mounted on an arc. Maybe I’ll change that, too! Thinking about all of that, I ordered myself a mechanical keyboard for work, knowing that I might not like it and that it might bother colleagues. This new one has Cherry red switches while the one at home uses brown. Just unboxing it evoked some interest and soon others joined as we discussed who used what, and why. Then someone brought out a key switch sampler that we all spent a couple minutes clicking. I watched someone who uses one of those flat Apple keyboards break into a smile when they tried the green switches, hearing (and feeling) the crisp click. My point isn’t to say you have to have a lot of equipment, or the best equipment. Plenty of people do great work on a laptop with no accessories. I can’t tell you that you would be more productive if you spend more more money on a keyboard, or switch to using two, or three, or six monitors. No, it’s to remind you, even challenge you, to revisit your tool set once in awhile and think, does this work for me well enough, or is it time to make a change? Humans are adaptable, sometimes too much so; we’ll keep using that keyboard with the key that sticks long beyond the point of common sense. For me, a little change here and there is good. I think my next big experiment will be trying a 32” or 34” monitor because scrolling to look at query plans isn’t fun. Zooming in and out isn’t fun either. Drop me a note in the forums, I’d love to hear what you use and like (or don’t like) about the tools you use. Andy Warren from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | | Redgate University Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers. Start Learning |
|
|
|
| | | Danilo Dominici from SQLServerCentral.com In this next level, we learn how to install SQL Server on Linux and verify that everything is working. More » |
| Press Release from Redgate Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. More » |
| Additional Articles from MSSQLTips.com In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs. More » |
| Kenneth Fisher from SQLServerCentral Blogs I was asked an interesting question the other day. Is it possible to get a different random number of rows... More » |
| SQLEspresso from SQLServerCentral Blogs We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party... More » |
|
|
| | Today's Question (by Steve Jones): I am creating a tuple in Python that for now contains a single item, a 7. I plan to add to this later, but how do I define this tuple, t? |
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: Python. 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 have this table: CREATE TABLE UserConfig ( UserConfigKey INT IDENTITY(1,1) NOT NULL CONSTRAINT UserConfigPK PRIMARY KEY , UserID INT , IsActive BIT SPARSE , IsSubscriber BIT SPARSE , DefaultQuantity INT SPARSE , Options XML COLUMN_SET FOR ALL_SPARSE_COLUMNS ) GO I want to insert a new row and use this statement: INSERT dbo.UserConfig ( UserID , Options ) VALUES (8, '<IsActive>3</IsActive><IsSubscriber>0</IsSubscriber><DefaultQuantity>99</DefaultQuantity>') GO What happens? Answer: The row is inserted Explanation: The row is inserted and the value of 3 is implicitly converted to a 1. Ref: Use Column Sets - click here Implicit Conversions - 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. Two constraints under column definition? - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-2017 EBCDIC file is getting loaded with all special characters in my table - Hi, I have an EBCDIC file and I am trying to load it using SSIS. I created a flat file connection manager,... Compare of variables and handling nulls - Hi, I wanted to compare 3 variables and set a flag if any of the three differ .. i.e. including handling of... How to build an app with GUI that works with SQL Server? - I have to create a project which should have a GUI because people who gonna use it don't know TSQL.... Audit Trial help - The new Trigger Table should hold new values and old values in the following way.   Use CTE/WITH to concatenate TWICE. - I have a table with 'words', each row contains a word, a position, a linenumber and a textnumber. I want to... What are some really dumb things you could write in a SQL Query - We all know there are plenty of recommendations as far as what to avoid when writing T-SQL. For example, it's... Automatically avoid error inserting into identity field - When I run the script below I get the error message below because it's trying to insert records in to... Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an... Campare the 2 highest transaction - Taking all transactions in the last 12 months and compare the top two highest single transaction. If the highest single... Casting one datetime as date converts other datetime fields - I have a table with two DateTime fields. When I select them and cast one of them as date, it... looping through all databases to find dependencies (cursor) - I want to have a go-to query that finds all dependencies of an object, across all databases (without requiring any permanent object like a... How to flip tables in sql server 2014 - Hello, I have a requirement wherein there are 2 tables (Staging & Target) in the same database. Everytime data is first loaded in... Multiple disparate UPDATE statements in a SP - Does anyone see any reason multiple UPDATE statements like below cannot work in a single SP? Does the keyword END... General audit / monitor question - Just an FYI: I don't need code. I just need thoughts. This is me spit-balling. I need to come up with... SQL server Audit Trigger for INSERT , UPDATE , DELETE - Hi SQL Central Colleagues, I was as asked to create DDL trigger to capture only what changed in a table and... HOW TO GET FIRST DATE - Dear all, I have data like: NAME SPONSOR_NAME DATE_OF_CALL A FI Unable to start the trace - I have this piece of code which I executed but the trace isn't starting. Any idea? Read Length of first Row and Header Row Delimiter through SSIS Script Task - Hi Guys, I have two questions. I am automating the process through SSIS to load the .txt file into SQL... DateAdd() - how to add 5 hours and 25 minutes to a date? - Hi there, This is actually a question re how to do this in SSRS's Report Designer 1.0, please forgive me if... |
|
| 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 |
|
|