SQL Azure Database Service Update 1 Released on February 17
Microsoft’s David Robinson has announced on the SQL Azure Team Blog that they have released Service Update 1 for SQL...
2010-02-19
523 reads
SQL Server 2005/2008, Service Packs - announcement
This is a good news from the Microsoft about SQL Server Release Services for both versions SQL Server 2008 & 2005.
SQL...
2010-02-19
659 reads
Speaking at the PASS DBA Virtual Chapter
Next week, I’ll be “in the cloud” as I give a presentation for the PASS DBA Virtual Chapter. The topic...
2010-02-19
350 reads
Getting over to ASK
I haven’t been great about spending time at ask.sqlservercentral.com. It wasn’t my idea to set it up, and while I...
2010-02-18
756 reads
sys.dm_os_wait_stats
This is a short note explaining he sys.dm_os_wait_stats DMV.
This DMV returns the following columns/values regarding waits encountered by executed...
2010-02-18
1,326 reads
More on SQLSaturday – From Jack Corbett
My friend Jack posted a nice aggregate of comments so far about the transfer of SQLSaturday to PASS, and added...
2010-02-18
550 reads
Interactive Sorting Using a Tablix in Reporting Services
Many organizations collect data, lots and lots of data. We have the opportunity and ability today to collect more data...
2010-02-18
1,068 reads
NOT EXISTS vs NOT IN
Continuing with the mini-series on query operators, I want to have a look at NOT EXISTS and NOT IN.
Just one...
2010-02-18
56,459 reads
BugMeNot
Warning: Rant coming
Every once in awhile I get a note from someone, usually a somewhat nasty one, that complaints about...
2010-02-18
1,108 reads
SQLSaturday Acquired by PASS – Reactions
The Announcement
On February 2nd, PASS (@sqlpass), here, and Andy Warren (@sqlandy), here, announced ownership of the SQLSaturday franchise brand was transferred...
2010-02-18
1,238 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
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...
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...