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)
892 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
9 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
1 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)
421 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
5 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)
390 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
76 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
2 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)
761 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
9 reads
Blogs
Webcast Tomorrow on SQL Server Disaster Recovery
By Brian Kelley
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL...
SQL Server Quickie #48 – Azure SQL Managed Instance
Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking...
Spark Connect Dotnet November 2024 Where are we?
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
Forums
Agent job security account
Hi All, I have few sql server agent scheduled jobs which are supposed to...
How to manage Time zone changes for countries
Hello Everyone, I am using Microsoft SQL Azure (RTM) - 12.0.2000.8, as of October...
How much transaction logs generated by hourly/daily
For MSSQL is there any queries or methods for me to pull historical data...
Question of the Day
What's the Ceiling?
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers