SQL Server 2008 R2 reaches RTM
On April 21 Microsoft announced SQL Server 2008 R2 has been released to manufacturing.
The downloads on Technet/MSDN on May 3....
2010-04-22
405 reads
Blog Posts
SQLSaturday 31 Chicago: Recap
Last weekend I had the distinguished pleasure of attending Chicago’s very first SQLSaturday event. Before I begin my recap I’d...
2010-04-22
667 reads
The Knowledge... (quote)
The quote about Knowledge, sure it is Albanian quote:
Learn the Knowledge but you'll never get rewarded by the God(All-llah) until...
2010-04-22
1,368 reads
What is a Good Way to Quickly Disable SQL Agent Job Schedules?
Introduction
I recently blogged about a Stored Procedure to Sequentially Run SQL Agent Jobs and have been meaning to blog about...
2010-04-22
462 reads
2010 Scripting Games
Since I've decided it's time for me to learn Powershell, naturally the best way to learn it is to dive...
2010-04-21
764 reads
A DMV a Day – Day 21
The DMV for Day 21 is sys.dm_os_ring_buffers, which is helpfully NOT described by BOL as:
The following SQL Server Operating System–related...
2010-04-21
2,585 reads
Attending Microsoft Most Valuable Professional Open Day from Montreal
Currently, MVPs from across the country are attending an all day event.
We are discussing Azure, Windows Live, Office 2010, Windows...
2010-04-21
681 reads
Big SQL Server Announcement This Morning at 7:30AM PDT
Microsoft’s Ted Kummert and Tom Casey are holding a public conference call this morning at 7:30AM Pacific time, where:
Microsoft...
2010-04-21
731 reads
Free E-Book on SQL Server 2008 R2
Free E-Book on SQL Server 2008 R2
Ross Mistry and Stacia Misner have done a wonderful job on this free e-book
http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx
You...
2010-04-21
3,689 reads
Log Shipping Delays are Good
In the past, when I’ve set up log shipping, it was primarily as a DR device, designed to get copies...
2010-04-21
3,202 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...