| The Complete Weekly Roundup of SQL Server News | Hand-picked content to sharpen your professional edge |
| Bad Managers I’m constantly hearing stories about terrible managers, and, of course, I’ve experienced quite a few myself. In fact, I can’t come up with many nice things to say about most managers when I look back over my career. (Luckily, my manager at Redgate is wonderful!) Early in my tech career, I was working at a small startup with just four employees. The owner of the company avoided talking to me in person for several months, making excuse after excuse about why he was too busy when our scheduled one-on-ones were due or we both happened to be in the office at the same time. Another consulting firm had been trying to recruit me for about a year, and I decided to take the offer. When I handed my boss the resignation letter, he finally told me that he hadn’t talked to me in months because he was afraid that I was going to ask for a raise. If he had just given me a few minutes of his time once in a while, I probably would not have left. I should have gotten used to managers who would cancel appointments at the last minute or just not show up because I continued to see that at other organizations. Maybe, in some cases, the managers had too many responsibilities, but it came across as having no value for my time. Many readers will have other examples of bad manager behavior such as not paying attention at all to what the team is working on, being a bottleneck to progress of projects, not being able to handle disputes among co-workers, not being able to discipline them when needed, not listening to their team members' opinions and ideas, or being unapproachable so that team members are afraid to come to them when things go wrong. Bad managers can demoralize the team and be the reason that talented staff leave for other jobs. Not only can this be the cause of project delays as new people must be hired and trained, high turnover is expensive for companies and can directly impact the bottom line. I began to wonder why managers are more likely to thwart progress instead of leading, inspiring and empowering their charges, and there are dozens of articles talking about it. In many organizations, there is not a good path for promoting great tech workers. How do you promote the best database administrator or developer? If the only path is team leader or department manager, many people who have great tech skills will end up in positions where they are not suited because tech skills and managing people are very different. Other reasons might be that managers are not given training to be managers, and also often the wrong things are measured which leads to managers doing things that reach certain metrics that don't really lead to success. Of course, having a manager who understands what you do is nice, but managers must have communication and leadership skills. They must be able to empower their employees to succeed and grow. Employees should feel like they and their manager are working towards the same goals and share enthusiasm about the success of projects. While a manager cannot say yes to every idea or request, they should at least listen and think about what the team member has to say. At the end of the day, when their team looks good, the manager will look good, too. Kathi Kellenberger Join the debate, and respond to the editorial on the forums |
The Weekly News | All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. |
Vendors/3rd Party Products |
Alexander Diab explains how a team of developers c... |
The SQL Prompt Public preview extension for Azure Data Studio is out and you can add this easily. This is a quick post showing a few ways to install... The... |
Vanilla Features are new. Features are sexy. Features do things for you automatically. But they often come with a lot of baggage. They may not work at all with other features They may... |
Tempdb is a critical resource in SQL Server. It is used internally by the database engine for many operations, and it might consume a lot of disk space. |
Question: I'd like to find all SQL Server Agent Jobs with a certain string within the Command section . There's been a change in reference to a database table, therefore I need to review all SQL Server Agent Jobs and check they are not referencing this database table. |
You know those tweets that you see once but can never find again? I remember seeing one a while ago where someone tweeted to #sqlhelp asking if the internal inserted and deleted tables had statistics or if they were like table variables, which didn’t. |
SQL Server 2005 introduced Dynamic Management View... |
While you’re stuck inside wondering if you’ll ever be able to attend a user group meeting again, I’m giving you free access to training materials that your boss probably... |
Analysis Services / BI on the MS Stack |
This article is part of our back-to-basics blog series called what is…?, where we’ll break down some common topics and questions posed to us. |
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a fairly simple task, but recently... The... |
Simple Restores Finally we’re going to start using Restore-DbaDatabase after talking about it for a couple of days. Given all the options that Restore-DbaDatabase offers, we’ll start off simple... |
This series of posts is essentially my presentation from the recent Data Weekender popup virtual conference – in blog form with some bonus additional content. This post focuses on... |
Computing in the Cloud (Azure, Google, AWS) |
The other day I had a random thought. I wonder if there is a version of Azure Portal for Android. ... Continue reading The post Running Azure from my android... |
Conferences, Classes, Events, and Webinars |
How has the state of database monitoring changed in the last 12 months? We exclusively reveal the top 5 challenges revealed by our annual survey, and dive into what they mean for the industry |
The latest version of SQL Clone showcases new integrations with our DevOps tooling. Join Microsoft MVP, Kendra Little, to learn more about how cloning technology can enhance your Database DevOps process. |
I was recently given the task of identifying the state of an Azure VM so that an automation script using the az vm run-command invoke would not fail if... |
PowerShell scripts are the tool of choice for many admins, but how do you make them easy for others to use? In this article, Greg Moore shows how to... |
Data Privacy, Compliance, and GDPR |
The California Consumer Privacy Act is a lesson in missed opportunities. It was passed in haste, to stop a ballot initiative that would have been even more restrictive: In... |
Database Design, Theory and Development |
There's a question that I hear all the time in SQL Server forums: Why didn't the transaction roll back when a primary key violation occurred? Take a look... |
Last time we looked at the internals of how dates and times are stored in SQL Server. This week we’re going to look at how numbers are stored. This... |
DevOps and Continuous Delivery (CI/CD) |
Alexander Diab demonstrates how a team of developers can work on and test features in different branches of a SQL Server database development project, while their local development database... |
The latest version of SQL Clone showcases new integrations with our DevOps tooling. Join Microsoft MVP, Kendra Little, to learn more about how cloning technology can enhance your Database DevOps process. |
HA/DR/Always On/Clustering |
I’ve now run across a few different instances where the monitoring for quorum was done via this DMV. On the surface, it seems like nothing would be wrong with using the “number_of_quorum_votes” column to check on the members of the cluster and see their voting status. However, this isn’t quite the case… |
(Be sure to checkout the FREE SQLpassion Performan... |
There was a very subtle but important change made in the April 2020 release of Power BI Desktop that you may have missed. Take a look in the format... |
Performance Tuning SQL Server |
Over some time, SQL Server Management Studio has expanded memory grant information. Memory grant provides memory grant estimate as well as actual runtime memory grant information. In this blog post, I will explain each element of ‘Memory Grant Info’, |
This month (May 2020), I will post several blog posts, all about the same theme: row counts in execution plans, their representation as arrow width; how to use it,... |
One of the most frequent questions you’ll hear online is how to determine if a particular index is in use. There is no perfect answer to this question. You... |
PowerPivot/PowerQuery/PowerBI |
Having a lot of visuals in your Power BI Report ca... |
It can sometimes be frustrating to work with slow ... |
The Power BI image-rendering visualizations, such as Table or Card, expect image links to public servers hosting the images with anonymous permissions. This has obvious shortcomings. |
Power BI Bookmarks, the secret behind many sleek reports, It revolutionised the entire PBI Report design approach. Initially, Bookmarks were portrayed more as some saved views, which can be used for storytelling than for navigation. |
Right now it seems like time is accelerating while data is trailing behind. If you are like me, then you have been voraciously reading the news and latching on... |
Did you know you could copy queries, in Power Quer... |
A lot of folks have taken advantage of more time at home recently to pick up new skills and hobbies. In my case, I have started learning more about... |
Thanks to the support of Redgate, I’ve launched a new course which teaches you the basics of TSQL. The course is totally free, no logins required — we don’t... |
This month’s T-SQL Tuesday is hosted by my frien... |
It’s T-SQL Tuesday time, and this one is interes... |
In the third article of this series, Sanil Mhatre demonstrates how to perform a sentiment analysis using R including generating a word cloud, word associations, sentiment scores, and emotion... |
A good friend of mine (Randolph West (blog|twitter... |
Itzik Ben-Gan continues his series on table expressions in SQL Server, explaining several use cases, pitfalls, and syntax wishlist items. The post Fundamentals of table expressions, Part 2 – Derived... |
Images, charts help to visualize the data in an informative way. It is an easy way to understand the data and perform analysis on it. An image is worth thousands of words. Suppose you have an employee data set and your management wants to view a high-level summary of it. |
Virtualization and Containers/Kubernetes |
Hyper-V is a Microsoft feature to create a virtual... |
This email has been sent to {email}. 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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. |
|
|