Less Than a Week - PASS 2009 Summit
A last push for the 2009 PASS Summit before registration goes up.
Managing Free Space
A new article from Paul Els looks at managing free space on your database servers by finding detached databases and old backup files.
Date Expression Compilation in SSIS
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
PASS Connector Editorial for Sep 9, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
Understanding Scans And Seeks
Whether a query uses Scan or Seek can have a big impact on the cost of excuting that query. This article examines when each is used and which is optimal.
Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries
In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).
Finding Passwords
There was a vulnerability announced in the SQL Server password system last week, but Steve Jones doesn't see this as much of an issue. Read his thoughts and see if you agree.
Returning full error details from SQL Server Agent jobs
Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!
EVA Partition Alignment
Partition alignment is a well documented best practice, but does it have any benefit on an HP EVA?
Finding Passwords
There was a vulnerability announced in the SQL Server password system last week, but Steve Jones doesn't see this as much of an issue. Read his thoughts and see if you agree.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers