This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity Virtual Group entitled “3 Reasons Why Focusing on Tech Is The Worst Way To Deploy...
2021-08-02
11 reads
This blog post is about YAML pipelines in Azure DevOps. I had a repo called InfrastructureAsCode for a client. I have been transitioning them to use YAML for their...
2021-08-02 (first published: 2021-07-15)
163 reads
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-08-02
9 reads
I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to ... Continue reading
2021-08-02 (first published: 2021-07-15)
392 reads
One of my goals this year was to build a report that I can present to kids and parents showing the skills progression of their kids. I have attempted...
2021-08-02
8 reads
I recently encountered a requirement to estimate the size of (a lot of) nonclustered indexes on some very large tables due to not having a test box to create...
2021-08-01
3 reads
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021. As I look at goal progress for 2021, I’m going...
2021-07-31
10 reads
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-07-30
11 reads
SQL Multi Script is a lesser known tool from Redgate Software that is designed to easily allow you to run scripts against many server instances with one click of...
2021-07-30 (first published: 2021-07-19)
309 reads
You might be asking why on earth would you want to get a database into an undesirable state, more specifically into a Recovery Pending state. Well, in my case,...
2021-07-30
2 reads
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
Hey everyone, SQL Server has two mechanisms for deploying and moving a database to...
Comments posted to this topic are about the item How Do You Patch 100...
Comments posted to this topic are about the item Microsoft SQL announcements at PASS...
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers