Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1 (2022-09-14)

SQLServerCentral Newsletter for September 14, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1]( - [Monitoring: The ROI of Build vs. Buy]( - [How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application]( - [From the SQL Server Central Blogs - Fast Fingers-Function Keypads]( - [From the SQL Server Central Blogs - SQL Homework – September 2022 – Query window challenge]( Question of the Day - [The Migration Tool to Use II]( The Voice of the DBA  Daily Coping Tip Give yourself permission to say ‘no’ 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. To Which Experts Should You Listen? When I was getting my career going in Denver, Microsoft used to host lunch sessions every few weeks in their office. There were some Microsoft employees presenting and some community members. I learned a lot from both groups. At local user groups, more often than not, a community speaker was present, but there were plenty of people that worked for different vendor companies that delivered talks. I saw many of these people are knowledgeable in their area, and they taught me things I used in my job. At some point, it started to seem that presenters that worked for companies weren't experts, and maybe more importantly, they weren't worth listening to because they were "selling something." In fact, a large community conference, and some small ones, banned "vendor" talks and the use of tools in presentations. Sometimes even free ones, if someone was promoting the software as the focus in their talk. That hasn't applied to Microsoft, even when they are "selling" something, free or not. I understand some of the concerns. I've seen some extremely poor presentations from sales and marketing staff, who often don't really understand the technology or why it would be used in one situation over another. There is no shortage of complaints about the poor experience from the attendees who didn't learn anything useful. There was [a post about this topic]( from a writer. While I think lots of larger technology conferences do end up with speakers that vendors sponsor. The SQL community might be slightly different as we have lots of community speakers, more than I ever imagined we'd have. I love that so many people have chosen to get up in front of groups and share their knowledge. Technical experts abound, and many of them work for vendors. In fact, often the people who give high-quality technical talks get hired by various vendors. I'm one of those, and it's always a challenge to find a way to talk about a problem and potential solutions without selling a product. I must present well because I rarely get complaints. I find there are a lot of other technical experts that do a great job as well. I hope that you give most people a chance and if they end up making a sales presentation, then let the organizers know. They can always address issues in the future. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1]( Jeff Moden from SQLServerCentral In Unix, a timestamp is a whole number that represents a date and time. Learn how we can convert those correctly in SQL Server. [External Article]( [Monitoring: The ROI of Build vs. Buy]( Additional Articles from Redgate There and pros and cons to building a monitoring system versus purchasing one: in other words, the ROI of build vs. buy. In this blog post, Grant Fritchey discusses when you should build, and when you should buy. [External Article]( [How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application]( Additional Articles from MSSQLTips.com Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development. [Blog Post]( From the SQL Server Central Blogs - [Fast Fingers-Function Keypads]( DataOnWheels from DataOnWheels This is the third in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this article for... [Blog Post]( From the SQL Server Central Blogs - [SQL Homework – September 2022 – Query window challenge]( Kenneth.Fisher from SQLStudies I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will ... Continue reading   Question of the Day Today's question (by Steve Jones - SSC Editor):  The Migration Tool to Use II Which migration tool is suited to migrate DB2 to an on-premises SQL Server? 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) Regenerating the Master Key I have a database encrypted with TDE. I want to regenerate the database master key and use the new key to protect the certificate. What should I do? Answer: run alter master key with regenerate Explanation: The database master key is one part of the TDE hierarchy and only protects the certificate used to encrypt the DEK. The ALTER MASTER KEY WITH REGENERATE will create a new master key nad move the encryption to the existing certificates (and other keys). Ref: ALTER MASTER KEY - [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 [MDF size increasing without table size increase]( - We have a database whose data file size was 1500 GB and used space within the file was around 900 GB on Friday. Today when I checked, the file has grown to 5200 GB and it is growing continuously. When I did the breakup of table sizes, its still 920 GB, which is expected. How […] SQL Server 2016 - Administration [Node quarantined status not cleared]( - Hi, Two node AG cluster nodes . one of the node went to quarantined state due to we had network issues multiple times. Quarantined state remain same more than 14 hours. Node status green color up & running also cluster resource online and AG role also running. I tried below PowerShell commands Get-Cluster | Format-List […] SQL Server 2016 - Development and T-SQL [Query for abnormal differences / find ouliers]( - Hi , I am trying to build a query that will identify 'abnormal' differences in the values column between each successive date record available for each individual account. The table will have multiple accounts and I want to identify the abnormal differences. The difference threshold to be identified is an absolute value of 80. thanks […] SQL Server 2019 - Administration [Need TABLE DDL to define finite list of column values]( - Looking for sample DDL syntax to CREATE a TABLE w/ a COLUMN that includes list of finite values. For example, I only want 4 allowable SQL Versions stored in the column SQLServerVersion below. What is the correct DDL to accomplish this? CREATE TABLE MyTable (ID INT IDENTITY(1,1) NOT NULL, MySQLServerName NVARCHAR(40) NOT NULL, SQLServerVersion NVARCHAR(40) […] [how to remove schemabinding from all functions and view in one go.]( - I want to remove the schema binding from all my functions, then want to apply but in one go, how can it be done? 2) I have few cols with columns in my database where collations is specified, i want to remove them in one go,  how both things can be done with few […] [last time index was re-org or rebuilt?]( - i'm unable to find such script online. i found some that had last stats updated but it's not the same thing i'm looking for. any ideas/suggestions? thx [ACCELERATED_DATABASE_RECOVERY and increase in database size]( - Hello , I am looking please for your feedback on the activation of "ACCELERATED_DATABASE_RECOVERY" In SQL server 2019 Especially on the size of the database because I'm worried if I see this SQL Server 2019 - Bug? Databases Auto Growing Out of Control Thanks [SQL on Virtual Machine]( - Hello Fellow Database Enthusiasts, I am an old guy and virtual machines are new to me, normally on a SQL server installation that you are going to have several or more instances running, you would have separate partitions that the instances are installed on, is that necessary on a VM machine running Windows server 2019? […] SQL Server 2019 - Development [Renaming JUST THE EXTENSION OF multiple files in a folder using SSIS]( - Hi, I have three files in a folder - SourceFolder ABC.edifact DEF.edifact NJF.edifact I need to rename these three or more files which drop into the above folder every day to ABC.txt DEF.txt NJF.txt The folder should remain the same, I just need to rename the extension of all files in a folder. I tried […] [Problem : Passing a Variable is not working in Dynamic Query]( - Hi all, I am not able to pass the table name as a constant in Dynamic Query: The logic is to loop through a list of tables name stored in a table 'tbl_names' and produce an output of tbl_name, row count My code is a follows: /* Table tbl_names has 3 column (id, tbl_name varchar […] [Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)]( - Beginner here and trying to solve a problem from which I cannot find any clear solutions. I am supposed to alter a table. I am supposed to add two constraints, these being the addition of a primary key and the addition of a foreign key (Some_ID). However, Some_ID is NULL and I am supposed to […] [Pivot columns to get 0 /1 flag columns]( - Hi, I have a dataset of employees with different "Paytypes" in a single column. I am trying to pivot the table on the Paytype column so that each paytype can be treated as a flag column, i,e, the only possible values in this column should be 1 or 0 Below is a sample code with […] Amazon AWS and other cloud vendors [AWS Managed Grafana authentication]( - Hello. I have built a small project where I call Lambda which parses some data from a website with Selenium and then stores the results to RDS (Postgres). I'd like to visualize this data. It is timeseries data, so I would need something where I can drill down to a certain date, month, year... So […] Reporting Services [world map and errors loading map for VS 2022]( - [Updated 9/6/22] What is the easiest way to get a world map into the map gallery so that I can embed into my report? Also, Using Visual Studio 2022. Any map I load from the map gallery (US only maps there), I get an error when previewing the report: "An attempt was made to load […] General [What should I have done with this?]( - I received this in the mail today. Any thoughts?   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -