Gila Monster on Estimated vs. Actual Row Counts
I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s just not something I’m that into....
2009-09-22
1,294 reads
Blog Posts
New Cumulative Updates For SQL Server 2008
Yesterday, Microsoft released SQL Server 2008 SP1 CU4, which is Build 2734, and SQL Server 2008 RTM CU7, which is...
2009-09-22
647 reads
PASS Book List
Since the beginning of the year I’ve been trying to include a SQL related book in the bi-weekly Connector. Basically...
2009-09-22
554 reads
PASS Connector Editorial for September 23, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-22
565 reads
Searching for Data in Images
I tried out Bing’s new visual search after seeing a few people note it on Twitter. I was a little...
2009-09-22
1,065 reads
September OPASS Meeting Recap
OPASS met last Tuesday, September 14th, with a mini (15 minute) presentation by Todd Holmes on Backup Basics and Jorge...
2009-09-22
436 reads
Built In Alerts
The more I think about this, the more I think it should be built into SQL Server as a default....
2009-09-21
939 reads
Free eBook: “Protecting SQL Server Data”
SQL Server security expert, John Magnabosco, has just authored the new book, Protecting SQL Server Data, the first book of...
2009-09-21
1,246 reads
Identifying Frequently Running Queries
It’s not enough to look at the longest running query. What if you have two queries, one runs for 5...
2009-09-21
980 reads
More Free Training Resources
A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit...
2009-09-21
1,256 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers