The Com.PASS Feeds
A new set of RSS feeds, hosted by PASS, bring you a large quantity of SQL Server content from various sites, including SQLServerCentral.
2010-05-04
1,099 reads
pass
PASS Virtual Chapters Late April Presentations
To finish up the month of April we’ve got sessions from AppDev and DBA and I’m even including one from PASS on ‘Intro to Speaking At PASS’.
2010-04-26
460 reads
PASS Virtualization Presents: SQL Meets Virtual CPUs, Memory, and Storage
Upcoming webcasts in February on the 9th and 10th of the month.
2010-02-08 (first published: 2010-02-04)
1,961 reads
PASS AppDev Presents: SQL Server Indexing
While indexing traditionally has been the concern of the DBA, it's important for developers to understand both the usefulness and the impact of indexes in your relational database. With the right indexes your application will perform like a Formula One racer, without them performance will better resemble a Model T. This presentation will explain how indexes work, what options are available to you in SQL Server 2008, and how to tune your application and your database for the best performance.By Allen White, 2/9/2010, 1:00EST
2010-02-02
584 reads
SQL Server Consolidation : how to decide on the right approach
The PASS DBA VC hosts this session today that will focus on helping to choose between using a virtualization, instance, or database consolidation option. We will highlight a few of the key areas to consider as well as some of the important differentiators to keep in mind. We will provide a decision tree to help guide administrators through the process of selecting a consolidation option.
2010-01-27
1,127 reads
Best Practices for Exception Handling and Defensive Programming in Microsoft SQL Server
This is a deep dive developer session that explores error handling in SQL Server. The session focuses on core error handling areas such as understandign the anatomy of errors, detecting errors in TSQL and best practices for error handling and defensive programming in Microsoft SQL Server. tuesday, 1/26, 8:00am EST
2010-01-26 (first published: 2010-01-21)
10,699 reads
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.
2009-10-22
531 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers