Need to troubleshoot SQL Server 2005 memory settings? Not sure where to look to measure SQL 2000 memory pressure? Kevin lays out your options in today's podcast. You can view this video in higher quality or your favorite portable formats at: http://sqlserverpedia.com/blog/sql-se... Video published December 24, 2008. … [Read more...]
Video: SQL Server Memory Troubleshooting
Filed Under: Challenges, Opinion, Performance, Professional Development, SQLServerPedia Syndication, Strategies, Video Tagged With: DBA, DMV, Internals, Performance, SQL Server 2000, SQL Server 2005, Video
Plays Well With Others – Dealing with Micromanagement
Imagine you’re working on a new project. It’s an important project and its success will be a big win for the organization. You were chosen for the job because of your competency, skill, and effectiveness. You get things like this done all the time and have a track record for pulling it off. Now that the project is underway, you’re finding that trust and support you need from management is absent. Instead, you’ve got a micromanaging boss, who’s put so many additional requirements on your for reporting, meetings, and whatever their favorite nit-picking happens to be that management is … [Read more...]
Filed Under: Opinion, Professional Development, SQLMag, SQLServerPedia Syndication Tagged With: Career, Management, Plays Well With Others, Professional Development, SQLMag
Plays Well With Others – More Thoughts on the Job Search
While searching for a job, the interview is your opportunity to showcase your talents and the strengths that you bring to an organization. But I have a few more random thoughts about conducting your job search that I thought were worth mentioning. The Personal Touch The first thought is a quick one. In our high-speed technology driven world, a personal touch still makes a difference. So be sure to send a thank you e-mail after concluding an interview, assuming you liked the company and the opportunity. There was a time when a hand-written thank you note was the appropriate response. … [Read more...]
Filed Under: Opinion, Professional Development, SQLServerPedia Syndication Tagged With: Career, Professional Development
DBTA: What’s the Fuss about Data Deduplication?
Listen to a group of database professionals talk for awhile and someone will eventually bring up the topic of data deduplication. Data deduplication is a means to eliminate redundant data, either through hardware or software technologies. To illustrate, imagine you've drafted a new project plan and sent it to five teammates asking for input. That single file has now been reproduced, in identical bits and bytes, on a total of six computers. If everyone's email inbox is backed up every night, that's another six copies backed up on the email backup server. Through data deduplication … [Read more...]
Filed Under: Administration, BigData, Challenges, DBTA, Hardware, IO, Opinion, SQLServerPedia Syndication, Trends Tagged With: DBA, DBTA, High Availability, Internals, Performance, SQL Server 2008 R2
Plays Well With Others – Influence versus Authority
You’ve probably found that the prefix “lead” is a fairly common occurrence in the technology world. We have “lead developers”, “lead DBAs”, “lead architects”, and “lead consultants”. Yet, we don’t have “lead managers”, “lead directors”, or “lead VPs”. Why is that? Well, there are probably a number of different reasons for having “lead” technologist titles depending on who you ask. For example, the HR department might say that adding “lead” to a technologist’s title justifies the better salary that the company had to pay to acquire that specific talent. The IT department chiefs might … [Read more...]
Filed Under: Opinion, Professional Development, SQLServerPedia Syndication Tagged With: Career, Management, Plays Well With Others, Professional Development
DBTA: Security as an Afterthought
If you've read the IT press at all these days, you know that SQL Injection (SI) attacks are very common and can be devastatingly effective. In fact, SI attacks-equally easy to execute against Oracle, MySQL, IBM DB2, or Microsoft SQL Server-are among the most common hacks on the Internet today. If a web application runs a relational database on the backend, it can be subject to an SI attack, which ironically, is among the easiest web hacks to prevent. [READ MORE] … [Read more...]
Filed Under: Administration, DBTA, Opinion, SQL Server, SQLServerPedia Syndication, Trends Tagged With: DBA, DBTA, Security
Plays Well With Others – Metrics to the Max!
November 2009 would have been the 100th birthday of famed management guru, Peter Drucker, were he alive today. Now for those of you who don’t know the name, Peter Drucker was no mere guru or simple pundit. He was in fact the father of management and universally acclaimed as the world’s greatest management thinker. Anyone who’s taken a business class, studied for an MBA, or had to deal with an IT project to build a management dashboard has been touched by Peter Drucker. If you have a spare moment, add Drucker’s Concept of the Corporation to your library. Drucker came upon the scene at a … [Read more...]
Filed Under: Challenges, Governance, On-Line Resources, Opinion, Professional Development, SQLServerPedia Syndication, Strategies Tagged With: Best Practices, Career, Management, Professional Development
Pirates of PASS: Curse of the Elections Process
Cross posted from Jorge Segarra's blog The last few weeks we’ve watched the drama unfold in regards to the PASS BOD elections. We’ve seen people attack criticize the NomCom, the board, PASS itself, the process and the decision of feeding of Gremlins after midnight. Thankfully the fireworks have died down and we can take a look at everything that has happened and make strides to move forward in a positive (and more importantly) constructive manner. Given that, I’ve been asked by my good friend Kevin Kline (Blog | Twitter) to respond to the following: Many in the community seem to think … [Read more...]
Filed Under: Ethics, Governance, Opinion, PASS Tagged With: Guest Post, Professional Development, SQLPASS
Carol McGury Speaks Out on Not-For-Profit Governance
I'd asked my friend and a form ED of PASS to add her thoughts about the governance process for not-for-profit organizations. Carol is one of the industry's top professionals, serving as the chief operating officer for many years at some of the largest IT and non-IT professional associations. I always look forward to her insight. She writes... As an Executive Director for another user group community, I can offer up a few thoughts as it relates to Nominating Committee best practices. I’ve been working with technology and various vendors for over 20 years, and I’ve seen the community … [Read more...]
Filed Under: Governance, Opinion, PASS, Professional Development, SQLServerPedia Syndication Tagged With: Professional Development, SQLPASS
DBTA: The Big Keep Getting Bigger
In this season of recession and financial meltdowns, a common question seems to be, "How big is ‘too big to fail'?" Titans of the financial industry made big bets with lots of risk and, when they didn't pan out, American society overall has to pay the price. But, that aside, the very scale of our financial system, by just about every metric, has reached amazing heights, be that number of financial transactions per second, number of traders, number of funds traded, amount of money changing hands—you name it. [READ MORE] … [Read more...]
Filed Under: BigData, Challenges, Databases, DBTA, Hardware, IO, Opinion, SQL Server, SQLServerPedia Syndication, Strategies, Trends Tagged With: Best Practices, DBA, DBTA, Developer, Internals, Monitoring, news analysis, SQL Server 2008 R2
