Disaster Recovery Tip #8: Maintain up-to-date contact information
A corollary to Murphy's Law states that disaster is most likely to strike when your senior people are out of the office.
2013-08-01
4,236 reads
Press Release
SQL Saturday #234 Baton Rouge, LA
SQL Saturday is coming to Baton Rouge for a free day of SQL Server training and Networking on August 3.
There is also a pre-conference session presented by Bill Pearson on Practical Self-Service BI with PowerPivot for Excel on August 2nd.
2013-07-31 (first published: 2013-07-19)
2,648 reads
SQL Saturday #236 St Louis, MO
SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there.
2013-07-30 (first published: 2013-06-26)
4,464 reads
Disaster Recovery Tip #6 - Monitor Your Systems
Today's complex systems are too large to be able to rely on any DBA's memory for knowledge of each component, and its configuration options and settings.
2013-07-25
4,301 reads
SQL Server Central Webinar Series #24: Prepare for When Disaster Strikes
Our next webinar on July 23rd has Steve Jones presenting on some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.
2013-07-23 (first published: 2013-07-03)
5,539 reads
SQL Monitor Custom Metric: Top Buffer Cache Object
This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. You should use this metric if you want to monitor what is in the buffer area, or if you are having performance-related disk read problems.
2013-07-22
3,313 reads
Disaster Recovery Tip #4 - Learn about partial restores!
Sometimes recovery simply entails rerunning a failed process.
2013-07-19
3,818 reads
SQL in the City Seminar Sacramento 2013
Join Red Gate for a free a seminar on July 26 (the day before SQL Saturday Sacramento). SQL Server MVP experts, Steve Jones and Grant Fritchey will present sessions featuring best practices for SQL Server database development and deployment, in addition to showing Red Gate tools in action.
2013-07-18
1,834 reads
SQL Saturday #239 East Iowa
SQL Saturday will be in Iowa City on July 27, 2013. This free day of SQL Server Training and Networking will also have pay-for pre-conference sessions presented by Bill Pearson, Louis Davidson and Tim Mitchell.
2013-07-18
2,185 reads
SQL Saturday #222
SQL Saturday is coming to Sacramento on July 27, 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday also features a paid-for full day pre-con session with Kalen Delaney
2013-07-17
421 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers