| A community of more than 1,600,000 database professionals and growing |
| | | Managerial Moneyball This editorial was originally published on Dec 10, 2014. It is being republished as Steve is on holiday. I really enjoyed reading Moneyball. Its a book about baseball and data and how information should be used to choose baseball players for the Oakland As. It's an interesting approach, one that has rarely been used in the sport in the past, though it is gaining traction. It does seem that this approach has helped the As to high level of success given the constraint of their limited payroll. There's even a great movie if you don't want to read the book, but the book is really much better and goes into more detail on data points and how they are used. The idea of using data to make decisions has been applied to other areas, with "The Moneyball Effect" being talked about in other industries. Recently I also ran across an opinion piece on bad managers that also referenced Moneyball. The piece notes that most people make poor managers. They lack the skills, and more importantly, they really lack those innate qualities that motivate, inspire, and engage employees. Whether you agree with that last part, I think most of you agree that most managers are poorly chosen, trained, and certainly not qualified. The idea of using data to identify people that would make good managers, and perhaps even move people out of managerial roles. The premise of the piece is really the bad managers make their teams perform worse, so if you've got one of the seven-out-of-ten people ill suited to the work, you should move them out of that position. Then identify, promote, train, and support the others to manage your employees and help them to perform at their best. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | Benchmark your Database DevOps maturity level Get a better understanding of how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers. Complete the Database DevOps Maturity Assessment |
| | | | What’s the top challenge faced by SQL Server professionals in 2018? Learn how 626 SQL Server professionals monitor their estates in our new report on the State of SQL Server Monitoring. Discover the challenges currently facing the industry, and what is coming next. Download your free copy of the report |
|
|
|
| | | | | Adam Aspin from SQLServerCentral.com DO you know how to display median values from a Dataset? In this short article you will use windowing functions to do this More » |
| | Additional Articles from SimpleTalk Azure Cosmos DB is Microsoft’s NoSQL database platform running in the cloud. In this article, Suhas Pande explains many of the core concepts in Cosmos DB. Additionally, he goes over how to set up a local Cosmos DB emulator to create collections and documents. Using a local emulator is free and allows development with Cosmos DB without being connected to Azure. More » |
| | Additional Articles from MSSQLTips.com In this tip we look at the missing index recommendations that SQL Server automatically provides and why you should pay close attention to what is recommended and how you actually implement the new index. More » |
| | Jason Brimhall from SQLServerCentral Blogs It is not unusual to find a server where some random user created a bunch of jobs to be run... More » |
|
|
| | | Today's Question (by Steve Jones): I have this code to create a table and add an index. CREATE TABLE dbo.PurchaseOrder ( PurchaseOrderKey INT IDENTITY(1, 1) NOT NULL CONSTRAINT PurchaseOrderPK PRIMARY KEY , PONumber VARCHAR(100) , CustomerName VARCHAR(100) ); CREATE INDEX PurchaseOrderNDX_CustomerName ON dbo.PurchaseOrder (CustomerName); GO I now run this: ALTER TABLE dbo.PurchaseOrder DROP COLUMN CustomerName 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: Alter table. 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 | Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and IBM DB2 Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business application that integrates with a data warehouse and an online Web store across a heterogeneous system. This volume describes proven methods to support common ETL needs, such as databases communicating directly with each other, using files to exchange data, or performing database operations using Web services. Pick up your copy of this great book today at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have this data in the file sscdownload.py: from urllib.request import urlopen def GetAndPrintTextFile(url): with urlopen(url) as events: for line in events: print(line.decode('utf-8')) print("Loaded") At a command REPL for Python, I type this: import sscdownload However, I realize that I made a mistake and I edit the file. In the same REPL, I now do this: import sscdownload What happens?
Answer: Nothing happens Explanation: When a module is imported in the REPL, any executable code inside is run once. This is intended to be setup code. The second time the module is imported, code is not run. Note: The function is also not re-imported. The reload() function is used to do this. Ref: Modules - 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. Automate daily table backup - Hi, i have task is assigned to take the table backup daily wise. below is the format tablename_yymmdd please suggest Sql query row value if exists - Dear All, i would like to create the virtual column result with if exist condition. Example : If column1 value is equal to... Assistance with DATETIME calculation when comparing to VARCHAR column (Test code included) - Hello, so I'm trying to get the difference in MINUTES between two columns. One column is a DATETIME column while the... Get 2 decimals in my query - SELECT 'Per Category' AS Category, , , , , , , , FROM (SELECT CategoryID, AVG(UnitPrice) as UnitPrice FROM Products GROUP BY... 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... Visual studio 2017 data tool SSIS with Oracle OLEDB data source - We recent upgraded our server from 2014 to SQL 2017. And we use visual studio 2017 data tools for SSIS,... dm_db_index_physical_stats - LIMITED or DETAILED - I'm interested to hear what most DBAs do to evaluate fragmentation using dm_db_index_physical_stats. Using this web site as a reference: dm_db_index_physical_stats I have t AG over different subnets and using linked servers - We have a typical AG set up, there are 2 nodes in one data on same subnet and 1 node... A SQL 2017 Licensing Question - Hi, We have three VM (V1, V2, V3) running on 3 separate host (H1, H2, H3). H1 has16 cores, H2 has... A Stairway series on Performance Tuning would be amazing! - Hi all I didn't know where to post this so just posting this here. I know it's a big topic with... Can I pull DISTINCT customers with SQL based on most recent row record only? - So, I have a table where data is being saved. My table (CustomerSourceDE) looks something like this: --------------------------------------- Id (text) NULLABLE Email (Email) NULLABLE Customer_FirstName... 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... How to roll up quantities > 1? - Hello everyone, I have not worked with rolling up quantities before and I am looking for some help. I need (or would... Table Redesign Question - Hey there! We have a series of tables that I'm trying to make more efficient. Currently there are over 90 "request"... How to find if a column of a resultset has a content? - There is a report I print, which includes a list of people, e.g. students, with their relevant content, e.g. their... Display select items in horizontal way - Select * from table will display items in vertical way in studio. How to make the statement to list items in horizontal... SSIS Dataflow is not throwing any error when there is invalid column in the source flatfile with same datatype - Please help me asap. SSIS Dataflow is not throwing any error when there is invalid column in the source flatfile... table design help - Hi All, Need some table design advice. I our environment, there is functionality call rules and actiontypes. We create rules... script to set all user database to simple recovery model - get me a script to set all user database to simple recovery model i tried the below......... it is changing for... How to execute Index? - I have gone through this example for index in one site. create table employee1( ID int, name nvarchar (20), salary int, ... |
|
| 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
