 | A community of more than 1,600,000 database professionals and growing |
| | | The Lost Time Last year when Daylight Savings Time moved clocks back, I was wondering how the time change might affect different devices and situations in the world. One area that I wondered about was medicate and health care devices. While I'm sure most (hopefully all) medical device software developers have thought about this, it was something that struck me this year as I was fighting a cold. I was taking a medicine designed to help reduce the length of illness and was supposed to take this every four hours. That meant if I took this at 10pm, the next dose should be 2am. However, if I woke up at 2:10am, it would actually be 1:10am since the clocks would have moved back an hour. If my clock adjusted itself, then it would be 3:10am. Not a big deal for my dosage, but for some people, this might really matter. Certainly software can adjust for this, but can we humans? If I'm dosed every four or six hours, common time frames, both me and my caregiver might get used to a schedule. We might assume that 7am, 11am, 3pm, 7pm is the schedule. We know that 7, 11, 3 repeat throughout the day. Daylight savings time changes that. Once the clock resets, I need to move to 2, 6, 10 the next day. Or to 1, 5, 9 depending on the time of year. It would be easy for someone to think they'd missed a dose and double dose, or assume that medicine was given last out and skip a dose. What about sales transactions? I'm sure this is a slow time of the day and year, but still, I'll get a skewed view of that hour. Either zero sales or double sales. What about auditing? Is this the perfect time to break into a system or perhaps game the tracking of events? If I came and went from a facility during the hour in question, could I leave before I arrived? How could we actually capture a true audit record here? Daylight Savings Time might have been a good idea at some point, but these days I think it's silly and causes more potential issues than it solves problems. I'd like to see it go away and have us stick to some consistent schedule throughout the year. Standard time, savings time, split the difference. I'm fine with anything, just don't arbitrarily move my clock during the year. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.2MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps With SQL Provisions virtual cloning technology, databases can be created in seconds using just 1MB of storage, and sensitive data can be anonymized or replaced with realistic data to ensure it is protected as it moves between environments. Download your free trial |
|  | | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
|
|
|
| | |  | Kimani Mbugua from SQLServerCentral.com Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000. iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code. More » |
 | All the latest insights on DevOps adoption rates among SQL Server Professionals, with a foreword from Donovan Brown Principal DevOps Manager at Microsoft. Read the report to understand the challenges – and the opportunities – of adopting database DevOps alongside broader DevOps initiatives More » |
 | Additional Articles from Database Journal Explore the Azure Data Studio dashboards and see how to customize one of these dashboards to include a new widget. More » |
 | jbookster from SQLServerCentral Blogs So you’ve got a SQL Server that you want to monitor. What should you monitor? In my opinion, at bare... More » |
| | david.fowler 42596 from SQLServerCentral Blogs During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit... More » |
|
|
| | | Today's Question (by Steve Jones): I have a SQL Server 2016 instance on Windows and want to enable the buffer pool extension option on my instance. How do I do this? |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Buffer Pool Extensions (BPE). We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | Expert T-SQL Window Functions in SQL Server Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): What does the MAXX() function do in DAX?
Answer: Returns the max value from the expression passed in as the second parameter, with a table passed in as the first parameter. Explanation: The MAXX() function will take a table as the first parameter. An expression is used in as the second parameter, which is evaluated for each row in the table. The max value is then returned. Ref: MAXX() - click here
» 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.
sp_help_revlogin missing - We have a 2017 install that was set up as windows auth. We recently decided to use mixed mode instead...
Is sp_send_dbmail Asynchronous? - Hopefully this is an easy question. In my scenario, I want some events to trigger an e-mail to someone. I have...
2016 Standard Core install - I need to setup a SQL 2016 Standard that will be core licensed. MS has a 2016 Enterprise Core install, but...
Subscribed to one activity - Hi, CREATE TABLE Activations( ID INT ,ActivityName VARCHAR(20) ,UserID INT ) INSERT INTO Activations (ActivityName,UserID) VALUES ('Baseball', 10),('Soccer', 10), ('Baseball',... Determining a Start Date within a subset of a group - I have a result set that I need to apply grouping within. However, the grouping is not just a simply...
Databses with >40,000 Users - Hello. Has anybody come across any issues with large numbers of Users in a database - i.e. >40,000. We hit 32767 Users some... Out of memory error while scripting structure and data - I am using the Tasks -> Generate Scripts utility to generate a complete (data and schema) script that would allow... Modify_Date Anomaly - As part of the daily checks I'm setting up, I'm restoring the nightly full backups to our test server and... Database refresh from Production DB to Test DB in Sql server 2014 - Hello, I would like to know the what's the best way i can do Database refresh from Production DB to Test DB...
very slow select - Team, I have this query that runs quite a long time, actually the result is not been displayed at all.
Replication error - Hi Team, I have an issue with replication, the log reader always gives this error: The process could not execute 'sp_MSadd_replcmds' The database...
Query tuning with conditional aggregation - Hi all, I have a stored procedure that returns a table 1Million + rows that I then need to pivot (I can't... Migrate all user logins - Hi Guys I need to migrate all user logins ( under security folder in SSMS ) from 1 server to another but... Date functions.. - i was trying to solve an online test... and i stopped here... i tried looking at the newly introduced functions...
Using a MOD function in SSRS - Can someone please let me know how I convert this Crystal derived columns formula to a valid SSRS expression? All...
rollback ssis - Hello all,happy new year 2019 In my SSIS job, I transfer files from one folder to another after processing to Stagging... How can execution of SSIS Package be stopped after a certain task executes? - QUESTION : HOW CAN I MAKE THE PACKAGE STOP right after sending mail task? So if mail is sent on the specified... SSIS research and documenation - Hi All, I am working on documentation prep and I want to know what is the best way to do... Data Flows with 2 or more Sources-Destinations - I have a dataflow. It has 2 sets of OLEDB Source, Data Conversion transformation, and Excel Destination in it (each source-destination writes to...
Help - SSIS Job Cannot Access Excel File - This is driving me crazy now, any help is great appreciated: I have a SSIS package for importing data from an... |
|
| This email has been sent to newsletter@newslettercollector.com. 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.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|