Understanding INNER join in detail
This objective of the article is to give readers in depth understanding of INNER JOIN with different joining conditions.
Cube Storage: Introduction to Partitions
Join BI Architect Bill Pearson in this introduction to Partitions in Analysis Services 2008. Here we explore partitioning concepts and advantages, and look forward to hands-on practice with partitions in subsequent articles.
SharePoint 2010 And SQL Server 2008 R2
Lots of interesting news and announcements coming out of the SharePoint 2009 Conference that started today in Las Vegas. Microsoft’s...
SQL Server Monitoring Scripts with the DMVs
If you do not have a third party monitoring tool in place, the only way is to constantly monitor SQL Server. To do this without being overly intrusive, we need to rely on the SQL Server DMVs.
The Value of Experience
What type of previous experience makes a good DBA? Is it necessary to have other experience? Steve Jones asks the question in today's Friday poll.
The Value of Experience
What type of previous experience makes a good DBA? Is it necessary to have other experience? Steve Jones asks the question in today's Friday poll.
The Value of Experience
What type of previous experience makes a good DBA? Is it necessary to have other experience? Steve Jones asks the question in today's Friday poll.
Getting started with SQL Azure
The cloud services from Microsoft for SQL Server are known as SQL Azure. MVP Jacob Sebastian brings us a introductory article about how to work with this service.
Top Ten Reasons to Attend the 2009 PASS Community Summit
There are some good reasons to think about attending the 2009 PASS Community Summit.
What Do We Want from PASS?
With the election of the Board of Directors complete for 2009, Steve Jones takes a step back to examine what we might want from a professional organization. If you care about having an organization for SQL Server professionals, read this and let us know if you agree or disagree.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers