Setup Full-Text using T-SQL–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wrote a previous post on how to...
2021-06-30
125 reads
Blog Posts
T-SQL Tuesday Retrospective #015: Aggregations
In early 2011 Jes Borland invited us to write about aggregations: I want to hear how you solved business problems with aggregate functions. I want to see your cool...
2021-06-30
42 reads
Using Readable Secondary in Azure SQLDB
When using a Geo Replicated Azure SQL Database Readable Secondary there are a few things to consider when it comes to performance tuning. Check out this episode of Data Exposed:...
2021-06-30
14 reads
When Read Committed Snapshot Goes Bad – Version Store Filling TempDB
We all had those calls, it’s the middle of the night and we get that phone call that a customer is getting error messages due to their tempDB being...
2021-06-30 (first published: 2021-06-18)
746 reads
Daily Coping 29 Jun 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-06-29
12 reads
Virtual Presentations: A Presenters Perspective
While we are clearly beginning to see in-person events on the calendar, the vast majority of presentations, events, talks, etc., are virtual. There are a lot of positives to...
2021-06-29
2 reads
A Weekly SQL Clone Image Creation Process
SQL Clone is a neat product from Redgate that I wish I’d have had when I was doing database software development. It lets me have a consistent image for...
2021-06-28 (first published: 2021-06-16)
234 reads
Daily Coping 28 Jun 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-06-28
15 reads
Server Review Essentials for Accidental and Junior DBAs—Prepping for Server Reviews
Welcome back to our series, Server Review Essentials for Accidental and Junior DBAs, where we’ve been taking an in-depth look at how to get ready to perform regular SQL...
2021-06-28 (first published: 2021-06-16)
458 reads
Azure SQL Database High Availability
Business Continuity in Azure SQL database is about the mechanism, policies and procedures that enable business to operate in the face of disruption such as(more...)
2021-06-26
46 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers