Most of us have managers that are picked from the ranks of our technical staff. Often the most talented technical person, or most willing technical staff member, is promoted to manager, given a few hours of training on the various tools that he or she will use to deal with the administrative paperwork a manager fills out, and then cut loose to "manage" a group of people.
And they stink at it.
Most of them are bad. Not only are they bad managers, they are often bad leaders, and many find their technical skills suffer as they split their time with managerial tasks. That certainly puts them in a bad mood and creates worry about their future. It's not even just in the technology industry, as we find that many managers are bad, yet still languish on for years. This despite the fact that research shows they are costing their companies profit.
Personally I think we are still evolving from the factory-like mentalities where managers needed to oversee workers and give them little leeway or choice in how they perform their jobs. Even in "knowledge work" or creative endeavors, managers too often feel the need to "do something" when they could often do less and get more accomplished. A big part of this is managers want to be paid more because they are responsible for people doing work. However they often don't accomplish more than their subordinates.
I doubt much will change, but I'd like to see managers for technical people (and directors even) paid less than their technical people, with less responsibility over workers' efforts. Help them get delays, issues, and problems not related to their tasks out of the way and let them get work done.
Learning DAX is easy once you install the PowerPivot for Excel 2010 add-in and get practical exposure to using functions, operators and values in DAX formulas. Bill Pearson, business intelligence architect and author, kicks off another Stairway series designed to get you using DAX and PowerPivot quickly to provide actionable business intelligence in your own environment. More »
In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. More »
Quick thoughts about the work required to make all day meetings run smoothly:
Suitable space with enough seating (and reasonable chairs!)Turn... More »
Question of the Day
Today's Question (by Steve Jones):
How do you remove a memory-optimized table filegroup from your database in SQL Server 2014?
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: Administration.
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
Securing SQL Server - Written by Denny Cherry, a Microsoft MVP for the SQL Server product, a Microsoft Certified Master for SQL Server 2008, and one of the biggest names in SQL Server today, Securing SQL Server, Second Edition explores the potential attack vectors someone can use to break into your SQL Server database as well as how to protect your database from these attacks. In this book, you will learn how to properly secure your database from both internal and external threats using best practices and specific tricks the author uses in his role as an independent consultant while working on some of the largest and most complex SQL Server installations in the world. This edition includes new chapters on Analysis Services, Reporting Services, and Storage Area Network Security.
Pop quiz hot shot - say you're on a bus going 50 miles per hour when the driver asks you for the ranges of the exact number data types in SQL Server. Your eyes glaze, who can remember that stuff? He says, ok hotshot, how about this - tell me the smallest exact number integer data type that can't support a negative number and I'll stop the bus and buy you breakfast.
Can you answer the question, stop the bus, and have a nice omelette?
Note - don't worry about the spelling/abbreviation used for the data types in the answers.
I wasn't able to find a reference for why that is, just guesses that it was because Ascii is 0 to 255. Integers can be signed or unsigned (see more here http://en.wikipedia.org/wiki/Integer_(computer_science)). In practice tinyint is often used for lookup tables where the range of values will be very small - often much less than the 256 possible.
Querying XML from SSMS
I have an xml document that (for this example) I've simplified to look like this:
<s:ElementType name='row' content='eltOnly' rs:updatable='true'>
SSRS -- Error while subscribing for new role
- Hi all,
I'm getting below error while subscribing for new role in SSRS.
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report...
SSIS caching error
- I am running a pretty straight forward dataflow that is:
Source -> Lookup -> Destination
I am in the process of trying...
Failed to notify ''operator name'' via email?
- Following command sends email fine:
EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@body=N'test
However, SQL Job with a notification to above operator doesn't work.
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.