| A community of more than 1,600,000 database professionals and growing |
| | | Bad Management This editorial was originally published on Oct 19, 2015. It is being re-run as Steve is out of town. Many people know that a good manager can make a huge difference in the productivity of a staff. A bad manager can also lower productivity, but only to an extent. Fear of losing a job, or avoiding punishment can motivate plenty of staff to get work done, even when you have a poor, or even absent, manager. Some companies don't value strong management skills much, some do. I think most of us would prefer to work for a company that does, but we don't always get the choice. That's one reason why I do promote the idea of branding yourself and ensuring you have other options for employment. The more options you have, and the more demand there is for your staff's services, the more likely that your company will make an effort to work with, rather than lord over, their employees. For those of you that are managers, or those that might want to help their manager build some skills, I ran across an interesting story from David Haney on his experiences as a manager at StackOverflow. It's a good set of principles that I tried to keep in mind as I managed people in the past. For those managers that might not know why their staff leaves, there's a good warning that good IT staff are in short supply, and companies should make an effort to retain them in various ways. For many of us in the IT sector, we can provide a strategic advantage for our businesses as we enhance and extend software. Many of us are important insurance that keep systems running, hopefully at a peak level. Bad management can impact the effectiveness of our technology organizations, and it's silly to accept bad managers. This is something that can be fixed with some training and accountability for the manager, with a little effort. Make a few suggestions, or try to show how a better manager (or style) might help you get more done. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps With SQL Provisions virtual cloning technology, databases can be created in seconds using just 1MB of storage, and sensitive data can be anonymized or replaced with realistic data to ensure it is protected as it moves between environments. Download your 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 |
|
|
|
| | | | | Jerod Johnson from SQLServerCentral.com This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS. More » |
| | Additional Articles from SimpleTalk Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later. More » |
| | Additional Articles from Redgate Last year we ran the industry’s first ever state of SQL Server monitoring survey, the results not only gave great insight for the community but helped us shape our product development to ensure we were meeting the needs that you were asking for. So what has changed in a year? Tell us for your chance to win a $250 Amazon voucher. More » |
| | meaganl from SQLServerCentral Blogs Data Factory can be a great tool for cloud and hybrid data integration. But since its inception, it was less... More » |
| | MarlonRibunal from SQLServerCentral Blogs We’re now on Part 5 of our SQL Server Reporting Services Basics Series. In this installment, we’ll learn how to... More » |
|
|
| | | Today's Question (by Junior Galvão - MVP): You start executing the code block declared below: BEGIN TRANSACTION TTBL; DECLARE @Counter TINYINT = 1; SELECT 'BEGIN...'; WHILE @COUNTER < 255 BEGIN UPDATE TabLockTable WITH (TABLOCK) SET Valores = @Contador WHERE Codigo = 10; SELECT Valores FROM TabLockTable WHERE Codigo = 10; SET @COUNTER += 1; END; SELECT 'END...'; GO You then decide to open a new query and execute the following statement: Insert Into TabLockTable Values ('Test TabLock') Go What happens in the new query window? |
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: Table Hint. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have this set comprehension. a = {x%2 for x in range(10) if x % 2 == 0} How many elements are in the final set?
Answer: 1 Explanation: This comprehension returns a series of values and then puts these in a set. The comprehension would return the numbers 0,2,4,6,8 in a list, but a set is unique, so this returns only a set of a single value, 0. Ref: Set Comprehension - click here set - 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 Windows NT - 64 bit" in Task Manager: CPU high - hi, I have setup a new VM (VMware) with latest Windows 2019 Server Standard (as domain), Sharepoint 2019 Enterprise and SQL... SQL Account - Once the SQL Server gets built by someone, later i would like to get notified about new database creations(this would... Cast of Sceientific notation different result on different SQL version - Hi, i got a question today and I just can figure out an answer. When casting a Sceientific notation to Numeric(32,16)... SP with Conditional Where clause where - I need to create a stored procedure with an optional where clause and I'm just not sure how to get... Strange linked Server problem - I have no problem running this via linked Server, and get a good result set EXECUTE .master.dbo.xp_sqlagent_enum_jobs 1,'' But when I try... Mirroring - I have database mirroring configured from Server A(principal) to Server C(mirror). However, i am thinking to do another DB mirroring... sql job taking more time - Hi All, Need some advice on troubleshooting sql jobs. We have a ongoing performance issue on one of our Production server. ... Get the distinct records which having same date with different time stamp. - Hi Team, Need some on the below requirement. I have the table and data like below. create table trend ( keyinstn INT, ratingdate datetime, rating varchar(10)) insert into... Loading Data from Staging Table to Parent and child tables - Hi, I am trying to load data fro mSTaging table (No Primary Key as it's from the csv file) but in... insert to .XLSX fails if len(column) > 255 - Error: ERROR MESSAGE: String orbinary data would be trun Help me with the SQL - ( Issue with excluding nearby visits ) - Good Day Folks! I need a listing of members who had a hospital visit. Please omit any visits that are within 30... Backup Restorations - Quick question. So I know to do a point in time restoration you need to restore the Full, then a differential... Varchar(Max) storage - Dear Experts, Have a confusion regards to the storage capacity of varchar(max). My question is , when 8000 bytes (the whole page)... Split strings by space into individual rows - Hi, String operations are one of my weakest areas in SQL. My requirement is to split strings separated by spaces with... How to return a value if an INNER JOIN isn't satisfied? - Hi, I have Historical T-SQL query as below: SELECT trimming SSNs - I have thousands of social security numbers I need to trim to leave only the last 4 digits... it is... Query produces incorrect results - Hello I am working on a complex problem There is a problem with the query DECLARE @AMTTOMARK DECIMAL(38,2),@CVIDDR VARCHAR(11),@CVIDCR VARCHAR(11),@MCVID VARCHAR(11),@CURRMARKAMT DECIMAL(38,2),@skipdr INT,@skipcr... Delete duplicate rows from ANY table. - Is there is 'fairly' simple query to delete duplicate rows from ANY table ? A script which removes duplicates from a... Netezza Query takes forever and eventually times out, can this be re-written to run quicker? - SELECT SS.ITEM,SS.SHIPMENT, MAX(SS.PROCESS_DATE) PROCESS_DATE FROM SHIPMINTS SS where SS.shipment > 14959039 and SS.QTY_RECEIVED is not null &nbs Evolution of career from perm/consulting to freelancing? - Hi, I am working as DBA for 17+years. permanent -> consultant-> permanent -> consultant ... at some point I start thinking about... |
|
| 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] |
|
|
