Strate SQL
Strate SQL: Category Archive for SQL 2005

December PASSMN Meeting This Week

Posted by Jason Strate at 12/6/2009 5:00 PM | Add Comment

Does Your Stored Procedure Grant Itself Permissions?

Posted by Jason Strate at 12/3/2009 7:00 AM | Add Comment

Deadlocks on exchangeEvent and threadpool

Posted by Jason Strate at 12/2/2009 7:00 AM | Add Comment

December PASSMN Meeting

Posted by Jason Strate at 11/18/2009 1:52 PM | Add Comment

If You Don’t Know Where You’ve Been…

Posted by Jason Strate at 11/18/2009 9:00 AM | Add Comment

Tap, Tap, Tap – SSWUG Conference Starts Today

Posted by Jason Strate at 10/21/2009 5:00 AM | Add Comment

Are You Registered?

Posted by Jason Strate at 10/14/2009 8:00 AM | Add Comment

User Group Study Groups… Anyone?

Posted by Jason Strate at 10/7/2009 10:10 AM | Add Comment

SQL Server Certification Discounts

Posted by Jason Strate at 10/7/2009 6:18 AM | Add Comment | Trackbacks

Checking EXISTS – What’s Your Practice?

Posted by Jason Strate at 10/6/2009 6:00 AM | Add Comment

To Be Or Not To Be In the Memory Buffer

Posted by Jason Strate at 10/5/2009 7:56 AM | Add Comment

Free SQL Server Security Book

Posted by Jason Strate at 10/4/2009 10:00 PM | Add Comment

Don’t miss out! Oct 21 – IT Care - Painting by Numbers, Update Your SQL Skills with New Paintbrushes

Posted by Jason Strate at 10/2/2009 10:29 AM | Add Comment

Check out the Ultimate Virtual Conference from SSWUG

Posted by Jason Strate at 9/29/2009 1:00 PM | Add Comment

September PASSMN Meeting Tonight

Posted by Jason Strate at 9/15/2009 8:00 AM | Add Comment

Checkout PASSMN Meeting Next Week

Posted by Jason Strate at 9/8/2009 8:00 AM | View Comments (1) | Add Comment

PASSMN September Meeting

Posted by Jason Strate at 9/1/2009 4:00 PM | Add Comment

August PASSMN Meeting Tonight

Posted by Jason Strate at 8/18/2009 6:00 AM | Add Comment

This Week Only PASSMN Meeting (August 18)

Posted by Jason Strate at 8/16/2009 6:00 AM | Add Comment

August PASSMN Meeting (August 18)

Posted by Jason Strate at 8/5/2009 6:00 AM | View Comments (2) | Add Comment

Reminder! Oct 21 – IT Care - Painting by Numbers, Update Your SQL Skills with New Paintbrushes

Posted by Jason Strate at 8/3/2009 10:29 AM | Add Comment

Analyzing Report Execution Time

Posted by Jason Strate at 7/31/2009 6:08 AM | Add Comment

Finding Number of Reports Executed By Folder

Posted by Jason Strate at 7/30/2009 7:00 AM | Add Comment | Trackbacks

Gotta Stop Violating Foreign Keys

Posted by Jason Strate at 7/29/2009 6:00 AM | Add Comment

I Had a Dream, too!

Posted by Jason Strate at 7/21/2009 11:00 AM | Add Comment

Are you busy Wednesday, Thursday, and Friday?

Posted by Jason Strate at 7/20/2009 10:00 AM | Add Comment

Analyzing Your Indexes with a Custom Report

Posted by Jason Strate at 7/20/2009 7:00 AM | Add Comment

July PASSMN Meeting Today (July 14)

Posted by Jason Strate at 7/14/2009 8:00 AM | Add Comment

July PASSMN Meeting This Week (July 14)

Posted by Jason Strate at 7/13/2009 8:00 AM | Add Comment

5 Common Mistakes with Tempdb

Posted by Jason Strate at 7/8/2009 11:00 AM | Add Comment

What Happened to My Fabulous Beverage!

Posted by Jason Strate at 7/7/2009 3:30 PM | Add Comment

July PASSMN Meeting Next Week (July 14)

Posted by Jason Strate at 7/6/2009 10:00 AM | Add Comment

When Did That File Get So Big?

Posted by Jason Strate at 6/30/2009 4:00 PM | View Comments (1) | Add Comment | Trackbacks

This Wednesday ITCare Event - Solving Business Pains with SQL Server Integration Services

Posted by Jason Strate at 6/22/2009 7:00 AM | Add Comment

June ITCare Event - Solving Business Pains with SQL Server Integration Services

Posted by Jason Strate at 6/12/2009 7:00 AM | Add Comment

Oct 21 – IT Care - Painting by Numbers, Update Your SQL Skills with New Paintbrushes

Posted by Jason Strate at 6/11/2009 10:24 AM | Add Comment

Really Search Cache for Execution Plans

Posted by Jason Strate at 6/4/2009 12:31 PM | Add Comment

Oops… A Lot Of Trees… Jobs to Update

Posted by Jason Strate at 6/2/2009 7:06 AM | Add Comment

But It Wasn’t My Job To Do The Backups!?

Posted by Jason Strate at 6/1/2009 1:30 PM | View Comments (1) | Add Comment

Does A Job Really Fail If Nobody Knows About It?

Posted by Jason Strate at 6/1/2009 10:00 AM | Add Comment | Trackbacks

DBADiagnostics – My DBA Database

Posted by Jason Strate at 5/29/2009 7:00 AM | View Comments (2) | Add Comment | Trackbacks

Are You Down With The BPA?

Posted by Jason Strate at 5/21/2009 12:04 PM | View Comments (1) | Add Comment

BPA Installs But Doesn’t Work

Posted by Jason Strate at 5/20/2009 8:00 AM | Add Comment

More Parallelism

Posted by Jason Strate at 5/8/2009 8:15 AM | Add Comment

I Didn’t Receive My Subscription

Posted by Jason Strate at 5/7/2009 7:25 AM | Add Comment

Finding Objects In Schema

Posted by Jason Strate at 5/6/2009 11:15 PM | Add Comment

Querying for Parallelism

Posted by Jason Strate at 5/5/2009 11:04 PM | Add Comment | Trackbacks

Snapshots of Index Contention

Posted by Jason Strate at 5/4/2009 11:51 PM | Add Comment

Sorting Project Files in SSMS

Posted by Jason Strate at 5/4/2009 7:55 AM | Add Comment

Analyze This - Analyze Your Indexes – Part 6

Posted by Jason Strate at 4/29/2009 7:00 AM | Add Comment | Trackbacks

Analyze This – Analyze Your Indexes – Part 5

Posted by Jason Strate at 4/28/2009 7:00 AM | Add Comment

Find Query Plans That May Utilize Parallelism

Posted by Jason Strate at 4/27/2009 7:58 PM | Add Comment

Analyze This – Analyze Your Indexes – Part 4

Posted by Jason Strate at 4/23/2009 2:57 PM | View Comments (2) | Add Comment

What is the size of your index?

Posted by Jason Strate at 4/23/2009 2:10 PM | View Comments (1) | Add Comment

PASS MN – Drive Your Way to the DMV

Posted by Jason Strate at 4/23/2009 8:20 AM | Add Comment

Tonight April PASSMN Meeting (04/21/2009)

Posted by Jason Strate at 4/21/2009 9:00 AM | Add Comment

Analyze This – Analyze Your Indexes – Part 3

Posted by Jason Strate at 4/21/2009 8:15 AM | Add Comment | Trackbacks

Analyze This – Analyze Your Indexes – Part 2

Posted by Jason Strate at 4/20/2009 6:59 AM | Add Comment

Analyze This – Your Indexes Analysis – Part 1

Posted by Jason Strate at 4/19/2009 11:56 AM | Add Comment | Trackbacks

Blogging Again…

Posted by Jason Strate at 4/17/2009 10:55 PM | Add Comment

Monitoring Index Contention With DMFs

Posted by Jason Strate at 2/25/2009 9:24 AM | Add Comment

Rounding Up to the Nearest 1,000

Posted by Jason Strate at 2/17/2009 11:34 AM | Add Comment

Troubleshooting Permission Issues with CREDITIALS

Posted by Jason Strate at 2/13/2009 4:54 PM | View Comments (3) | Add Comment

Database File Information

Posted by Jason Strate at 2/12/2009 4:34 PM | Add Comment

Change Trusted State of Foreign Keys

Posted by Jason Strate at 2/6/2009 9:46 AM | Add Comment

UPDATE - ORDER BY and Deadlocking

Posted by Jason Strate at 2/5/2009 8:48 AM | View Comments (1) | Add Comment

DMV Version of sp_who2

Posted by Jason Strate at 2/4/2009 8:22 AM | Add Comment

Scripting Object Level Permissions

Posted by Jason Strate at 1/9/2009 12:31 AM | Add Comment

I don't Want To Use the Object Browser (sp_helptext)

Posted by Jason Strate at 11/19/2008 12:59 AM | View Comments (2) | Add Comment

PASS Next Week & Certifications

Posted by Jason Strate at 11/11/2008 1:22 PM | Add Comment

SQL Server Virtual Conference This Week - Nov 5, 6, and 7!

Posted by Jason Strate at 11/2/2008 2:15 PM | Add Comment

Remove All Non-Numeric Characters From A String

Posted by Jason Strate at 9/18/2008 12:48 PM | Add Comment

Second Shot Exams...

Posted by Jason Strate at 8/10/2008 11:30 AM | Add Comment

Index Size and Usage

Posted by Jason Strate at 7/10/2008 3:02 PM | Add Comment

AUTO_UPDATE_STATISTICS_ASYNC SQL Server Database Configuration

Posted by Jason Strate at 7/2/2008 11:28 AM | Add Comment

Last Time SQL Server Restarted

Posted by Jason Strate at 7/1/2008 11:25 AM | Add Comment

Database Mail Failed Items Log

Posted by Jason Strate at 6/26/2008 1:40 PM | Add Comment

Database Edition msdb Sample Database Projects

Posted by Jason Strate at 6/20/2008 3:27 PM | Add Comment

CLR_AUTO_EVENT Wait Stat

Posted by Jason Strate at 6/19/2008 10:49 AM | Add Comment

Transfer Logins Between SQL Server 2005 Instances

Posted by Jason Strate at 6/11/2008 1:54 PM | Add Comment

24 Hours of SQL Server 2008

Posted by Jason Strate at 6/6/2008 11:05 AM | Add Comment

Incrementing Values

Posted by Jason Strate at 11/14/2007 10:12 AM | Add Comment

Change the Server Collation of SQL Server 2005

Posted by Jason Strate at 10/18/2007 3:14 PM | Add Comment

The 2008 PASS Community Summit

Posted by Jason Strate at 10/11/2007 1:53 PM | Add Comment

Restoring a Database with Symmetric Encryption

Posted by Jason Strate at 10/2/2007 5:27 PM | Add Comment

Microsoft Certification Second Shot Exam, It's Back...

Posted by Jason Strate at 9/21/2007 9:24 AM | Add Comment

Deadlock Resources

Posted by Jason Strate at 9/17/2007 11:20 AM | Add Comment

Is This Cluster Good Enough?

Posted by Jason Strate at 9/14/2007 11:50 AM | Add Comment

Divide By Zero

Posted by Jason Strate at 8/29/2007 12:04 PM | Add Comment

Troubleshooting Performance Problems in SQL Server 2005

Posted by Jason Strate at 4/11/2007 11:02 AM | Add Comment

Online Index Operations

Posted by Jason Strate at 3/26/2007 1:10 PM | Add Comment

Default Trace

Posted by Jason Strate at 3/19/2007 2:16 PM | Add Comment

SQL Server 2005 Performance Dashboard Reports

Posted by Jason Strate at 3/14/2007 1:22 PM | Add Comment

Because One Service Pack Wasn't Enough

Posted by Jason Strate at 3/7/2007 11:49 AM | Add Comment

SQL Server 2005 Best Practices Analyzer

Posted by Jason Strate at 3/6/2007 11:05 AM | Add Comment

Connectivity and SSIS

Posted by Jason Strate at 3/2/2007 2:36 PM | Add Comment

2007 Time Zone Update... Did you remember SQL-NS?

Posted by Jason Strate at 2/27/2007 1:40 PM | Add Comment

It's All ABout The NULL

Posted by Jason Strate at 2/26/2007 12:44 PM | Add Comment

Whitepaper: Empowering Enterprise Solutions with SQL Server 2005 Enterprise Edition

Posted by Jason Strate at 2/23/2007 1:06 PM | Add Comment

SSIS XML DOM Fun

Posted by Jason Strate at 2/22/2007 1:51 PM | Add Comment
Older Entries
Copyright 2008. All rights reserved.
Blog Software