Help Build the SQLRally Speaker/Topic Selection Process – Part 1
Last week we announced PASS SQLRally, the new event that we’ll be holding in May 2011 in Orlando (aka the...
2010-07-29
706 reads
Blog Posts
Indexes and their Effect on Query Performance
Indexes play a huge role in the performance of a query. Without indexes, you very simple query to get the...
2010-07-29
1,005 reads
Interviewed by Andy Leonard
Last year Brent Ozar interviewed all the candidates for the PASS Board of Directors. I think it went over pretty...
2010-07-29
1,915 reads
Introduction to Parallel Data Warehousing
What are we talking about?
Recently Microsoft released a new version of SQL Server 2008 R2 called Parallel Data Warehouse Edition....
2010-07-29
800 reads
Limiting Table Access for Reporting Part 1
End users may have a need to do some form of reporting of data from source systems. Opening up the...
2010-07-29
465 reads
Limiting Table Access for Reporting Part 2
Blog Title: Limiting Table Access for Reporting Part 2
In the first blog post of this series, I showed you how...
2010-07-29
582 reads
Log Shipping By Abi Chapagai (Revised)
Log Shipping By Abi Chapagai (Revised)
In SQL Server, transaction log provides an ability to recover a database to a point...
2010-07-29
2,394 reads
Pesky Protected Mode
How many of you keep falling for this one…You open up Report Manager for a user that you know you...
2010-07-29
1,484 reads
Poor Little Misunderstood Views
Some people love ‘em, some people hate ‘em. But, one thing I have found to be nearly universal is that...
2010-07-29
60,221 reads
Schedule Published for SQLSaturday #51 in Nashville
Just released, http://www.sqlsaturday.com/51/schedule.aspx?sat=51. Five tracks, lots of good speakers, but I see a few new names too. Looks like a...
2010-07-29
1,374 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers