Where are my SQL Server Errors?
Have you ever opened the SQL Server Error Log and wondered, “where are all the errors?” Digging through the Error Log to find what you need can be a...
2021-06-02 (first published: 2021-05-20)
903 reads
Blog Posts
Daily Coping 1 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-01
13 reads
Moving Synapse Databases Between Subscriptions – Practical Guidance
One of the tasks, we often do with migration projects is move large volumes of data. Depending on how you are configured, you may need to do the migration...
2021-06-01
6 reads
A quick primer on binary and hexadecimal
A few years ago, I wrote that a CPU is “a hot mess of on-off switches.” There’s more to it than that when you get into the weeds of...
2021-05-31 (first published: 2021-05-19)
432 reads
Daily Coping 31 May 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-05-31
9 reads
Tesla and DevOps
That’s how someone described a Tesla recently, talking about how the software keeps changing. I had watched a few videos after I stumbled on this one: That got me...
2021-05-31 (first published: 2021-05-20)
400 reads
Automating AlwaysOn Availability Group Failover for SSISDB 2012/2014
Hopefully not many people are still configuring SSIS instances on SQL 2012 or 2014 – especially HA instances – but if you are, this post is for you. If...
2021-05-28
8 reads
Automating AlwaysOn Availability Group Failover for SSISDB 2012/2014
Hopefully not many people are still configuring SSIS instances on SQL 2012 or 2014 – especially HA instances – but if you are, this post is for you. If...
2021-05-28
124 reads
Creating a configurable SSMS script
Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from ... Continue reading
2021-05-28 (first published: 2021-05-18)
780 reads
Daily Coping 28 May 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-05-28
12 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