Kevin discusses resources online that he uses and considers to be excellent destinations for SQL Server professionals. Kevin will discuss each site he uses in detail - check it out! Posted August 15, 2008. … [Read more...]
Video: Where are good SQL Server resources?
Filed Under: Databases, On-Line Resources, Presentations, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: DBA, Developer, Internals, Monitoring, SQL Server 2005, Tools, Video
Video: Data Modeling in the SQL Server Space
Join SQL Server MVP and President of PASS, Kevin Kline as he: * Identifies the issues that can arise from relying only on modeling tools * Discusses the 10 most common modeling issues you will face when transforming data models from logical (conceptual) to physical * Describes how to correctly identify and resolve serious problems * Provides best practices to resolve issues Posted June 14, 2007. … [Read more...]
Filed Under: Challenges, Databases, Presentations, SQLServerPedia Syndication, Tool Time, Video Tagged With: Data Modeling, Database Architect, Database Design, DBA, Normalization, Tools, Video
Videos: Strategies for Addressing Common SQL Server Challenges
As a busy SQL Server DBA you face an increasing number of daily challenges: Managing fast growing data volumes and database environments Diagnosing and resolving performance issues Effective backup and recovery Monitoring and tracking database changes Balancing current resources against future capacity needs Inefficiencies in any of these areas can lead to performance degradation, unauthorized database changes, and unplanned, extended downtime. Webcast originally presented by renowned SQL Server expert Kevin Kline and learn valuable strategies for addressing these challenges … [Read more...]
Filed Under: Administration, Challenges, Databases, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Strategies, Tips & Tricks, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, Quest Software, SQL Server 2005, Tools, Tools & Scripts, Video
Quest Software announces Cassandra support in Toad for Cloud Databases and a partnership with Riptano.
My employer, Quest Software, Inc. (QSFT 26.15, +0.68, +2.65%) today added Apache Cassandra, an open-source NoSQL database, to its list of supported NoSQL platforms with the second beta release of Toad(R) for Cloud Databases. Toad now supports data access and management for Apache Cassandra, Amazon SimpleDB, Microsoft Azure Table Services, Apache HBase, and any Open Database Connectivity-enabled relational database. Read the entire article here. … [Read more...]
Filed Under: Cloud, Cool Technologies, Databases, NoSQL, SQL Server, SQLServerPedia Syndication, TCD blog post, Tips & Tricks, Tool Time Tagged With: cloud computing, DBA, Monitoring, Quest Software, Toad, Tools, Tools & Scripts
DBTA: Getting Up to Speed on the SQL Server Social Media Scene
If you haven't paid attention to the new social media, you're doing yourself a disservice. Just as email was a game-changer in the 1980s and the internet revolutionized society in the 1990s, social media is making a huge impact on the way people work and interact today. Personally, I was skeptical about social networking until some good friends persuaded me to give it a trial run. It seemed like a great way to dither away some valuable time, but I didn't see the business value in the whole proposition until I tried it. [READ MORE] … [Read more...]
Filed Under: Cloud, DBTA, On-Line Resources, Opinion, PASS, Professional Development, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Trends Tagged With: Career, DBA, Professional Development, SQLPASS, SQLSaturday, Tools, Writing
Free Poster – SQL Server PerfMon Counters
You Needs It! You Wants It! We all know how hard troubleshooting SQL Server can be. There are tools and techniques that can make troubleshooting much easier, such as the Windows System Monitor. The only problem with SysMon, or more commonly "PerfMon", is that it takes a lot of knowledge and experience to know which objects and counters to examine. I've put together a nice poster for you covering all of the important PerfMon counters for SQL Server troubleshooting, with a little help from some of my friends: Brent Ozar, Bob Ward, Christian Bolton, and Raoul Illyes. You Can Has It Fer … [Read more...]
Filed Under: On-Line Resources, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks Tagged With: DBA, SQL Server 2008 R2, Tools, Training, Troubleshooting
New Fast Features Video – Toad for SQL Server
Fast Features for Quest Tools. Someday soon, I promise. I've been trying hard to get more videos out the door about the SQL Server tools from Quest Software (my employer). I'd sent a new one over to the program marketing team a while back, but it's not showing up in the Coffee Break Bytes section like it should. These little videos show a single feature in detail, usually taking no more than 5 minutes to watch in their entirety. In the meanwhile, check out the excellent video series here. And the blogs are really good too, available on the interwebs here. Thinking about cloud … [Read more...]
Filed Under: NoSQL, On-Line Resources, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming Tagged With: DBA, Developer, Quest Software, Toad for SQL Server, Tools
The Data Detective is on the Case (And I Can Hook You Up for Free!)
You may have seen a new super sleuth around Quest.com and Toad World - The Data Detective! The team at Quest Software has created a new comic series where users can learn how Toad for Data Analysts will help you find, understand and report on data. Plus, you can take part in a contest to win a free one-year license of TDA! The first in the comic book series is posted here. And there's one each month. If you contact me directly, I can help you get to the front of the line for the contest! … [Read more...]
Filed Under: SQLServerPedia Syndication, Transact-SQL Programming Tagged With: Data Analysis, DBA, Humor, Quest Software, Tools
The Awesomeness of ROBOCOPY Now at SQLMag
If you're like me, you've used Ctrl+C/Ctrl+V more than a time or two, but you've always felt a little dirty afterwards. Yeah, you can use the command-line COPY or XCOPY utilities. But they're decidedly 20th Century, much like some of the laundry still loitering under my office couch. So I spent a little time over the holidays cleaning up my file system by scripting a backup routine using the very cool and very free ROBOCOPY utility. Now, I've got a regularly scheduled job that, after the first run which captured all my files, only backs up new or changed files (and directories) while … [Read more...]
Filed Under: SQLServerPedia Syndication, Tool Time Tagged With: SQLMag, Tools, Tools & Scripts
New Goodies from Microsoft – Microsoft Answers and Web Spark
Here are a couple of nifty resources that you should bookmark. Microsoft Answers Join the conversation as a community leader through a new, fast-growing Microsoft site called Microsoft Answers. The site currently focuses on Microsoft’s consumer products starting with Windows Vista. Throughout the fall (actually, starting on September 28th), Microsoft began to add forums for Windows XP, Windows 7 and Windows Live Services (in English, with other languages to follow starting back in October). Forums for Office will also be added later, with more consumer products to be added as the Microsoft … [Read more...]
Filed Under: On-Line Resources, SQLServerPedia Syndication Tagged With: Tools, Web Development
