Kevin Kline will offer insight into best practices for SQL Server 2005 set up, configuration and queries. He will also discuss tuning for both the server and hardware to help an application perform better after it is deployed. This presentation will offer a better understanding of several SQL Server performance related areas including: * Hardware design * SQL Server configuration settings * Database configuration settings * Application design * SQL Tuning Posted December 20, 2006. … [Read more...]
Video: Ensure Optimal Performance When Deploying SQL Server 2005
Filed Under: Databases, IO, On-Line Resources, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, SQL Server 2005, Tools & Scripts
DBTA: The NoSQL Movement- Hype or Hope?
If you spend any time at all reading IT trade journals and websites, you've no doubt heard about the NoSQL movement. In a nutshell, NoSQL databases (also called post-relational databases) are a variety of loosely grouped means of storing data without requiring the SQL language. Of course, we've had non-relational databases far longer than we've had actual relational databases. Anyone who's used products like IBM's Lotus Notes can point to a popular non-relational database. However, part and parcel of the NoSQL movement is the idea that the data repositories can horizontally scale with … [Read more...]
Filed Under: Challenges, Cloud, Databases, DBTA, NoSQL, Opinion, SQLServerPedia Syndication, TCD blog post, Trends Tagged With: Azure, cloud computing, DBA, DBTA, Developer, FutureWatch, news analysis, Web Development
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
DBTA: Forecasting SQL Server in 2010
After the misery that was 2009, most of the SQL Server users I talk to are happy that 2010 started in languid fashion. Not that there isn't a lot of work to do; on the contrary, there's more work than ever. However, the long hours and multiple projects of 2009, compounded by freezes in all levels of spending, raised the general stress level to unhealthy heights. With the new year, stress levels dropped significantly, and many IT leaders see signs of improving prospects. What does that bode for 2010? I have a couple of predictions, though I doubt they'll surprise many people. [READ … [Read more...]
Filed Under: Challenges, Cloud, Databases, DBTA, Opinion, SQLServerPedia Syndication, TCD blog post, Trends Tagged With: Azure, DBA, DBTA, Developer, news analysis, SQL Server 2008 R2
Microsoft SQL Server High-Availability Videos and Q&A Log
You Want Videos? We Got Videos! I always enjoy getting the chance to catch up with author, consultant, and Microsoft Clustering MVP Allan Hirt. Allan and I recently presented two sessions covering an overview of high availability in Microsoft SQL Server and, the following week, a demo of how to implement several different kinds of high availability techniques including database mirroring, transactional replication, and Windows clustering services. You can see videos of these presentations at the Quest Software Pain of the Week webcast site. Archives of other videos are here. We're … [Read more...]
Filed Under: Challenges, Databases, On-Line Resources, Performance, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Best Practices, Database Mirroring, DBA, High Availability, SQL Server 2008 R2, Tools & Scripts, Video, Windows Clustering
DBTA: The Shape of Database Licensing Costs to Come
One fall semester many years ago, I was a university freshman. Actually, I was anything but "fresh." I was dumb enough to think that 8 a.m. was a wonderful time to attend Economics 101. After staying up until the wee hours most every night, the "dismal science" took on more than one meaning as I set my clock just early enough to get to class on time. Along with 30 other very naïve classmates, I staggered into class and did my bleary-eyed best to focus on the lessons at hand. There were lots of Greek compound words and lots of graphs. I learned, for example, that the word economics … [Read more...]
Filed Under: Databases, DBTA, Opinion, SQLServerPedia Syndication, Trends Tagged With: DBA, DBTA, Licensing, Management, news analysis, Society
DBTA: Microsoft’s Trajectory for SQL Server Becomes Clear with PowerPivot
I was once asked what I thought Microsoft's overall product trajectory for SQL Server was, in light of Oracle's rather obvious trajectory of acquiring multiple application vendors who will, in turn, deploy more and more of their applications to the Oracle database platform. To be honest, I had a little difficulty perceiving a clear and concise strategy statement for the sort of work going on in Redmond. I could see a lot of great features being developed. And I knew the SQL Server development team had developed a lot of new "plumbing" with each new release - features like Service Broker and … [Read more...]
Filed Under: Databases, DBTA, Opinion, SQLServerPedia Syndication, TCD blog post, Trends Tagged With: Business Intelligence, Data Visualization, Data Warehousing, DBA, DBTA, Developer, FutureWatch, Microsoft News, news analysis, SQL Server 2008 R2
Video: Worth the Wait Why SQL Server 2008 is Great
Join Kevin Kline, SQL Server MVP and SQL Server Technology Strategist for Quest Software and Brent Ozar, SQL Server Domain Expert for Quest Software as they introduce the top ten features and capabilities in SQL Server 2008 that they find to be the most exciting and valuable. Originally Posted on YoutTube November 12, 2008. Follow me on Twitter! … [Read more...]
Filed Under: Administration, Databases, Presentations, SQL Server, SQLServerPedia Syndication, Video Tagged With: DBA, Developer, Quest Software, SQL Server 2008
TN Summit 2010 – Surviving the Data Avalanche
Here's the link to my revamped presentation on Surviving the Data Avalanche The Abstract for this presentation is here. The slides for this presentation are here. … [Read more...]
Filed Under: BigData, Challenges, Databases, IO, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Strategies, Trends, Video Tagged With: Best Practices, DBA, Internals, Performance, SQL Server 2008 R2, Video
Video: SQL Performance Optimization
Gain insight into best practices for SQL Server optimization and ways to alleviate many root causes that can impact performance of your SQL Server database. Kevin also will discuss how to manage for planned and unplanned changes, speed time to implementation of your applications and ensure that your databases are running as they should. You will learn how to: * Identify the root cause of bottlenecks that hinder performance of your SQL Server environment * Diagnose and fix T-SQL errors in development before code goes into production * Learn new best practices for project planning and … [Read more...]
Filed Under: Challenges, Databases, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Quest Software, Tools & Scripts, Video
