Why I Don't Like Microsoft Access
After seeing Brent Ozar's Top 10 Reasons Why Access Doesn't Rock, and seeing all the comments it generated, I figured...
2010-02-15
4,325 reads
Technet and MSDN coming to Baton Rouge
On March 4th Microsoft will be hosting two half-day events in Baton Rouge, LA.These free live learning sessions will explore...
2010-02-15
733 reads
Set your Warehouse Database to Read Only
In most environments new data is added to the data warehouse daily, weekly or even monthly.Even further, these changes typically...
2010-02-15
735 reads
Useful reading this week
This is a short post for a Sunday afternoon, I thought I’d share some useful reading from the week gone...
2010-02-14
870 reads
Saving Space – Vertical Partitioning
I wrote about data types recently, referencing Michelle Ufford’s presentation at the PASS 2009 Summit. In that post I talked...
2010-02-14
1,536 reads
SQL Server 2005 SP4!
Microsoft has recently announced the planned release dates for the next round of SQL Server service packs. SQL Server 2008...
2010-02-14
697 reads
PayPeriod II
I recently blogged about a solution I had decided to use in order to solve a problem related to PayPeriod...
2010-02-14
805 reads
SQL Server 2005/2008 Servicing Plans
Microsoft Group Program Manager Matthias Berndt has a post up on the Microsoft SQL Server Release Services blog (which is...
2010-02-13
595 reads
SQL Server 2005 & 2008 SP Release Dates
Microsoft has announced that Service Pack 2 for SQL Server 2008 will be released in the third quarter of 2010,...
2010-02-13
807 reads
PASS is Seeking Program Committee Volunteers
The sessions presented at the PASS Community Summit are selected by volunteers from the PASS Program Committee. If you would...
2010-02-12
364 reads
Blogs
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...