Getting started with ROUND() and Its Use Cases (2022-12-02)

SQLServerCentral Newsletter for December 2, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Getting started with ROUND() and Its Use Cases]( - [A Real-world Implementation of Database DevOps: People, Processes, Tools]( - [SQL RAISERROR to Better Handle Errors]( - [From the SQL Server Central Blogs - On Hybrid Events]( - [From the SQL Server Central Blogs - SQLibrium SQL Server on VMware training now free]( Question of the Day - [The Last Valid Restore Time]( The Voice of the DBA  Daily Coping Tip Enjoy new music today: play, sing, dance, or listen I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. An Amazing Summit It's been a couple of weeks since the PASS Data Community Summit 2022. I was lucky enough to attend the event, and I had the chance to experience things firsthand for the in-person part of the event. I also had many people come up to tell me that they loved the event as well. It truly felt like a homecoming with so many people that I've seen at past Summits in the same place at the same time. I know I'm biased here, but it was a wonderful way to reboot the Summit after not having an in-person event since 2019. Before the event, I was a bit nervous. While we have a number of people who have been a part of the Summit previously, and a lot of Redgaters coming who had been to events, the effort to execute on an event of this scale is high. There was a lot of stress and worry, and a lot of last-minute tasks. I was watching the various Slack channels in the background while being available to offer help where needed. To be clear, I really had nothing to do with organizing, planning, or executing this event. I spoke at a few sessions, but it was a lot of other Redgate employees and various contractors that made everything run fairly smoothly. Despite a few hiccups with getting started and some streaming issues, almost everyone I talked to thought that the event was very similar to previous Summits and the highlight of their year. For me, this was fun for many reasons. First, because of the people. Far too many to name, and far too many that I didn't get a chance to speak with, but it was wonderful to meet new people and see so many friends from the past. The event was 5 days for me, but I never had enough time to stop and talk with others. Second, it was fun to be a part of the [Lego Steve promotion](. Every time I saw [a picture posted]( or talked with someone about it, I had to laugh a little. It was a fun part of the event for me, and I have some fun memories of the experience. Starting the week off with [a photoshoot]( was very enjoyable. Lastly, I loved seeing plenty of people taking advantage of networking and also seeing very quiet hallways during the presentations. People were learning from speakers and taking time between sessions to talk to each other. I had more than a few people tell me they networked and met some great new friends. Something that I have done many times over the years. I've had a strange relationship with the Summit over the years. Sometimes I've loved the event, other times I've been angry with the organizers. I've skipped a few as well. Over time I've come to realize that this is a magical event for the data community, bringing many of the best and brightest together with a happy, eager, hopeful, and wonderful #sqlfamily. I look forward to next year, and hopefully, finding more time to chat with people during the week. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Getting started with ROUND() and Its Use Cases]( Manvendra Deo Singh from SQLServerCentral Learn the basics of the ROUND() function in this article. [External Article]( [A Real-world Implementation of Database DevOps: People, Processes, Tools]( Additional Articles from Redgate This series of articles describes a path you can take to transforming an existing, manual and error-prone database development and release process into an automated and reliable Database DevOps 'pipeline', starting here with an overview of what we set out to achieve, and the people, processes and tools involved. [External Article]( [SQL RAISERROR to Better Handle Errors]( Additional Articles from MSSQLTips.com Learn how and why to use RAISERROR in your SQL Server code to be able to better handle errors that may occur during code execution. From the SQL Server Central Blogs - [On Hybrid Events]( @DBA_ANDY from Nebraska SQL from @DBA_ANDY  In my blog post last night on Days 1 and 2 of the PASS Summit, I included the following comment: (Along with that, I think having "hybrid" events like our... [Blog Post]( From the SQL Server Central Blogs - [SQLibrium SQL Server on VMware training now free]( kleegeek from Technobabble by Klee from @kleegeek I’m proud to be a part of the SQL Server communities globally. I do everything I can do to give back when I can. Too many times, I feel...   Question of the Day Today's question (by Steve Jones - SSC Editor):  The Last Valid Restore Time In SQL Server 2022, there is a last_valid_restore_time column in sys.backupset. What is this used for? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Assigning a Server Role I want to create a new Server Role for my SQL Server 2019 instance, but I want another server principal to own this role. What should I do? Answer: Use CREATE SERVER ROLE WITH AUTHORIZATION= Explanation: There is an AUTHORIZATION clause with the CREATE SERVER ROLE that you can use to set the owner. Ref: CREATE SERVER ROLE - [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [Does the db_ddladmin database role permissions apply to db system object?]( - The db_ddladmin is another powerful role because it allows a user to create, drop, or modify any objects within a database, regardless of who owns it. (. Question1, it states it allows a user to create, drop, or modify 'any objects' within a database, does this include 'system objects' or just 'user objects' within the […] SQL Server 2016 - Administration [Batch Requests/sec ; FROM sys.dm_os_performance_counters -how to get SUM /hour?]( - Is it possible to query the SUM(cntr_value) for the previous hour ? (for example, to compare it with Sum of the current hour?) (or any other time period, for that matter?) SELECT cntr_value,* FROM master.sys.dm_os_performance_counters WHERE counter_name='Batch Requests/sec'; Administration - SQL Server 2014 [Replacing Physical Server]( - Hi We are going to update our old SQL physical servers to brand new machines. In the planning in my head stage but need some advice. Thinking I can setup the new hardware with the exact same OS, SQL version, instance name but with a different server name. Then when the new server is setup […] SQL Server 2019 - Administration [Is it best practice to the password for distributor_admin?]( - Hello, Our audit team has decreed that all logins should password policy turned on for all SQL Server logins. They also decreed that the login password needs to be 32 characters. I found the command to change the password: sp_changedistributor_password The question that I have, is this something that is going to break my replication? […] [how to minimize prevent sql injection]( - Hi All, We are having sql injection from website. The login used in the connection having only data reader and execute all SP. We use SP, view and function, no adhoc query. To find we are running server side trace. From that, I have found someone executed SP where this sp do number of items […] [tran log won't grow. i can't understand why.]( - My tran log is set to autogrow, by 256 mb, to unlimited. I fill the log but it doesn't grow. I can grow it manually. Why is it not autogrowing? If it's relevant, it's in a 4 replica AG. This is a test db / issue so we're talking small numbers here, MBs. SQL Server 2019 - Development [SQL Developer]( - ISDATE(OPS_PROJ_FMIS.STATE_OPTION_2) = True Trying evaluate if this OPS_PROJ_FMIS.STATE_OPTION_2 date and keep getting an error How Do I used IsDate Funtions in this?  [Get all StudentIds for each consecutive date]( - I have a table wherein each student submits their assignment. I need to write a query to get all the students who submitted their assignments each day. So from the table shown, StudentId 1 and 2 submitted their assignments on all 3 days. The output should be 1 and 2. Any hint will be helpful. Amazon AWS and other cloud vendors [AWS CDK | Multi-repository serverless project structure]( - Hello, everyone I'm trying to split my huge serverless CDK project into separate repositories/services. Everything is fine except one thing: I don't understand how to deal with shared API Gateway. Those multiple separated services should be exposed via one particular API Gateway. Do I need to separate shared resources to different git repository as well […] General Cloud Computing Questions [Is there a reason to use Cloud SQL rather than BigQuery?]( - I'm studying for the GCP exam and the text made it pretty clear that BigQuery was for large analytics datasets and cloud sql made more sense for small transactional data. But the pricing for BQ just seems insanely lower than cloud sql for smaller data too. I'm working on a personal project that will have […] Reporting Services [Empty Field is causing entire Page to be blank]( - I'm a little new to SSRS and am running into a strange issue. I have a Table tied to a data source. Essentially, it is just a letter with text and two fields from the dataset ([Salutation] and [FullName]). The [Fullname] is a field that defines the Associate for the record and it may be […] [Empty Field is causing entire Page to be blank]( - I'm a little new to SSRS and am running into a strange issue. I have a Table tied to a data source. Essentially, it is just a letter with text and two fields from the dataset ([Salutation] and [FullName]). The [Fullname] is a field that defines the Associate for the record and it may be […] [update the SSRS branding files]( - i'd like to update the SSRS branding files. I was wondering if there is a copy of the default branding files that i could download to use as a back up, just in case anything goes wrong? or how can i download and back up the existing branding files in use? If I just add […] General [Partial dependency]( - A partial dependency occurs when fields are indirectly or partially reliant on the main key but are also dependent on other keys that depend on the primary so that if the field on which another field depends is deleted, that field will still exist owing to its dependence on the primary key. I'm not sure […] Integration Services [Retrieving Active Directory information]( - I have a requirement to process AD information through an SSIS package and have hit a problem with the "objectClass" attribute. The ADO.NET source is configured as: and the package has converted all of the output data types to NTEXT. This isn't an issue for most of them as I've converted them to DT_STR using […]   [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -