How to Find the SQL Server Instance Startup Time (2023-05-12)

SQLServerCentral Newsletter for May 12, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [How to Find the SQL Server Instance Startup Time]( - [Understanding how to Successfully Sell the Cloud]( - [Database Branching and Merging without the Tears]( - [From the SQL Server Central Blogs - Experiments with GitHub CoPilot]( - [From the SQL Server Central Blogs - Power BI Cruise Recap – Deep Data Dives]( - [Expert Performance Indexing in Azure SQL and SQL Server 2022]( Question of the Day - [SQL Server 2022 VLF Changes]( The Voice of the DBA  They Call Me Andy Null Today we have a guest editorial as Steve is out of town. This editorial was originally published on Jun 9, 2017. There’s no doubt that working in the world of data and databases gives one a unique perspective on many things, a perspective that is often difficult to explain to those who aren’t well versed in the dark arts of data. For example, lately I’ve been getting mail (the kind that requires a stamp) addressed to “Andy Null”. When the first one arrived I have to admit to looking at it with disdain. What knucklehead converted a null to “Null”? But disdain didn’t last long, as I smiled about the vendor buying a list that had been cleaned and standardized, and no doubt marketed as having no nulls. Then I started thinking about the data team at said vendor trying to clean up the dirty data and soon I’m picturing a data version of [who’s on first]( Marketing: Please move the nulls from the list. Data: I did Marketing: I still see nulls Data: No, we always filter out nulls Marketing: I STILL see nulls Data: Oh, I see what you’re talking about. Those aren’t NULLs. Marketing: What? Data: I’ll just convert the Nulls to NULLs and then you won’t see them again. Marketing: Go away. So now I’m a member of the Null family. Nulls propagate (truly, I have 2 children). I suppose the whole Null family will be removed from the list(s) soon enough, though we’ll probably live on in the database forever since the last name column cannot be null (wait, it is!). Sadly I didn’t do this on purpose. But in this age of personal branding, maybe it’s worth some thought. It’s hard to imagine a judge objecting to the request. What would be the impact? Would I still have to pay taxes if the IRS doesn’t handle nulls? Or perhaps I’d be unemployable because HR wouldn’t be able to enter me into their system. Only a data geek could have this much fun with a piece or two of junk email. Andy Warren [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [How to Find the SQL Server Instance Startup Time]( Nisarg Upadhyay from SQLServerCentral Learn a number of methods to view or programmatically get the SQL Server instance startup time. [External Article]( [Understanding how to Successfully Sell the Cloud]( Additional Articles from MSSQLTips.com Many businesses are hesitant to adopt cloud technology due to security, cost, and complexity concerns. This can make it challenging for organizations to sell the benefits, leading to missed opportunities. Learn about different techniques to help sell cloud technology in your organization. [External Article]( [Database Branching and Merging without the Tears]( Additional Articles from Redgate Armed with a schema comparison engine and an object-level directory of the source for every recent version of the database, you'll be able to remove a lot of the uncertainty around merging database changes back into development. [Blog Post]( From the SQL Server Central Blogs - [Experiments with GitHub CoPilot]( Steve Jones - SSC Editor from The Voice of the DBA There has been a lot of attention given to ChatGPT and AI over the last month or two. I’ve tried a few things with the public interface at Open.ai.... [Blog Post]( From the SQL Server Central Blogs - [Power BI Cruise Recap – Deep Data Dives]( DataOnWheels from DataOnWheels Thank you so much to those of you who were able to attend this three-hour, C# packed session! The Power BI Cruise was an incredible conference, and I cannot... [Expert Performance Indexing in Azure SQL and SQL Server 2022]( [Expert Performance Indexing in Azure SQL and SQL Server 2022]( Site Owners from SQLServerCentral Take a deep dive into perhaps the single most important facet of query performance―indexes―and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other […]   Question of the Day Today's question (by Steve Jones - SSC Editor):  SQL Server 2022 VLF Changes In SQL Server 2014, if a log file grew by less than 1/8 of the current file size, only one VLF was created. If the growth was more than 1/8 of the current size, then there would be more VLFs. These were the rules: - <64MB growth, 4 VLFs created - >=64MB and <1GB, 8VLFs created - >1GB, 16 VLFs created. In S<64MB, QL Server 2022, the engine tries to be more efficient. How have things changed? 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) Managed Instance States There is the ability of Azure SQL Managed Instance to stop the instance. With this feature, what are the states that a Managed Instance can report to the admin? Answer: Online, Stopping, Stopped, and Starting Explanation: Previously a Managed Instance only reported that it was online. With the Stop feature, we now have these states (as of Mar 2023). - Online - Stopping - Stopped - Starting Ref: Stop and start an instance (preview) - Azure SQL Managed Instance - [ [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 2016 - Administration [Index Creation for large table failed.]( - I'm trying to create a clustered index on a very large heap table. Below is the script i'm using to perform the creation job. CREATE CLUSTERED INDEX [IX_Arc_tblFST_GSNID] ON [dbo].[tblFST] ( [GSN_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON, DATA_COMPRESSION=PAGE) ON [ps_tbl_arctbltnr]([TNR_Date]) However the creation […] [Always ON, HA, File Location Problem]( - Hello All, I have four VMs setup while I am learning SQL Server Admin tasks and configurations. SVR01 is the DC, the other three are the servers to be used. I am attempting to setup Failover clustering, however I run into this error every single time, no matter what folder I use, what name I […] SQL Server 2016 - Development and T-SQL [Extracting Data from XML file]( - Hi all, I have a XML file which consists this type of data: 12345 1 ABC XYZ TEST TYPE TEST REFNUM 2016-11-30 TESTCOMMENT TEST DESIGN TEST NAT TEST TYPE EXACT 1964-07-17 […] [How To Enumerate Hierarchical Info on SP calls]( - NOTE: Forgive me if I am using the wrong terminology with regards to this. \ I am trying to get a list of all The SP's (Stored Procedures) that are called by an SP. For example let's say I have the following SP's: LF5_Job1, LF5_JOb2, LF5_CalcResFees, F5_CalcCommFees & LF5_PopulatFees The SP LF5_Job contains one 'EXECUTE' […] SQL Server 2019 - Administration [Log File continue growing]( - Hello everyone, i read a lot about growing Log Files on this forum but can´t find a solution for my problem. I moved a database from one server to another, cause there were several performance problems on that old server. Since i moved the database the lfd file is continue growing. Database (mdf) file is […] [Generate 1 log file every 1 hour doing a backup every 1 hour?]( - EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES', @Directory = 'D:\DADOS-LOG', @BackupType = 'LOG', @LogSizeSinceLastLogBackup = 1, @TimeSinceLastLogBackup = 60, @DirectoryStructure = NULL, @FileName = '{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}.{FileExtension}', @AvailabilityGroupDirectoryStructure = NULL -- How to modify this script to generate 1 log file every 1 hour doing a backup every 1 hour? [how to set to a variable]( - how can I make SELECT SERVERPROPERTY('MachineName') to set to a variable? Thanks, SQL Server 2019 - Development [Script to import BACPAC file?]( - Did some searching, and the closest I've seen is using the SqlPackage command-line tool, either directly from CMD or through a PowerShell script. I'm aware that in SSMS, you can do this by right-clicking and selecting "Import Data-tier Application". Is there any way to do this through a standard SQL script? Or is the only […] [select query]( - Hi, I would like to select the specific string from the field(Text_Loginame) value from a table. Below are the two records in that filed. Text_Loginame Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided.[CLIENT: XXXXX] Login failed for user 'ABC\XXXX'. Reason: Failed to open the explicitly specified […] [Importing XML data into a Table]( - Hi, I am trying to write a script which will import fields from an XML file into a table. Below is the example XML Test company other Other 111111 […] [Grouping the words which has maximum count]( - Hi All, I have to highest two word in the columns. It should have the maximum two words combination. I have attached the excel for reference. General [SQL server loads slow troubleshoot common issues?]( - What are some best practices to identify and troubleshoot slow query performance issues on an SQL server, and what are some effective tools and techniques to resolve problems with server crashes or connectivity disruptions? How do you optimize SQL queries for performance, and what are some common pitfalls to avoid What are some advanced features […] Analysis Services [How can external customers access SSAS cubes to create their own analysis]( - My company has a number of SSAS tabular cubes which are deployed to a server and Power BI reports are built on top of that. We have lots of bespoke reporting requirements from external customers and are thinking it would better for them to do there own analysis and reporting as long as we can […] Strategies and Ideas [Injest user-provided Excel?]( - In today's episode of "Products that Should Exist (and maybe do)": Have you come across a solution (preferably a web-based portal) that allows an end user to upload an Excel file, digests the data, identifies tabular data, walks the user through column mapping to structured data, performs data validation, highlights invalid data, allows editing of […] Integration Services [SSIS package succeeding but Job failing (fail - converting date and/or time)]( - Hi, I successfully created an SSIS package and it executed perfectly in Visual Studio's development environment. However, when I scheduled this very package within a SQL Server Job Agent, it mysteriously fails: " Hresult: 0x80040E07 Description: "Conversion failed when converting date and/or time from character string.". End Error Error: 2023-05-04 13:33:28.19 Code: 0xC004701A Source: Load […]   [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -