Tag: sql server

64GB RAM, no partitioning, no AlwaysOn Availability Groups, no encryption – what’s a DBA to do? Brent Ozar gives you a few easy workarounds around SQL Server Standard Edition limits.

SQL Server database is great for a lot of uses, but not every application design pattern shows off SQL Server’s best side. Learn about the pitfalls of linked servers, replication, queues in the database, and more.

Are you still rebuilding all of your SQL Server indexes every week, but you’re still having performance problems. Odds are, you’re not actually making things better: you’re making them worse! Learn about the 3 kinds of fragmentation, the 2 worst things you can do about it, and the 1 way …

It’s incredibly easy to make big mistakes with indexes in SQL Server. This video presents the three most common mistakes people make with their indexing. You’ll learn how these mistakes can have disastrous impacts and practical steps you can take right away to identify if these problems exist in your …

If you want the most out of your SQL Servers, then it’s essential you’re monitoring them constantly. SQL Server performance is affected because of high memory and CPU usage. Many times, this leads to bottlenecks in your SQL environment bringing your applications to a complete halt. Ensure other aspects such …

The session focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. In this session you will learn the details and capabilities of T-SQL: Ranking Functions, Joins and Set Operations; Aggregating and Pivoting Data; TOP and APPLY; Data Type Related Problems; Programmable Objects; Graphs, …