| A community of more than 1,600,000 database professionals and growing |
| | | The Digital Twin The world is changing quickly, and it's becoming incredibly personalized thanks to digital technologies. I saw a fascinating video from GE on digital twins. These are digital representations of their products, using specific data (sensor, visual, weather, settings, etc.) to build a model of a specific piece of equipment. This model runs on a platform and constantly analyzes new data to evaluate and predict the performance of the system. With equipment like jet engines, power plants, and more, a tiny increase in efficiency can translate into incredible cost savings or revenue increases. The idea of using digital twins is taking hold in other fields, and I expect that we'll continue to see all sorts of digital representations and models of real world items. We are even starting to see this in medicine, with personalized treatments for various diseases, including cancer. By using more data, and powerful computing capabilities, we can tailor our treatment to the individual and their particular ailment. This personalization has an annoying side as well, after all many of us have experienced more targeted advertisements and annoying uses of our personal information, however much of that is crude, and lacking in sophistication. Perhaps if the models using data about me would be less annoying if companies didn't try to sell me a laptop a week after I've purchased one, or show me sales on products when I'm looking at SQL Server articles. I'm amazed and hopeful that our computing systems will evolve, with more talented data scientists blending their knowledge in some problem domain with powerful computing capabilities and lots of data. I expect that some of the challenges we face with our aging infrastructures and physical systems will be helped by extensive data and powerful machine learning models specific to an instance. 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 | | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
| | | | How do you manage sensitive data? Redgate's Foundry team are researching data discovery and classification. Fill out this short survey if you think you can help, and at the end you'll be entered into a prize draw. Fill out survey |
|
|
|
| | | | | Gregory Larsen When you build applications that store records in SQL Server you will most likely have to store date and time values as part of the data. To manage all the different date related tasks you might need to perform Microsoft has introduced a number of date functions. In this stairway I will be exploring those date and time functions. More » |
| | Press Release from Redgate In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton. More » |
| | Additional Articles from MSSQLTips.com In this tip John Grover will help you make the transition to SQL Server on Linux by explaining the things you need to know. More » |
| | Find out what's new, what's next, and what's coming soon to Redgate's free prototype tool, SQL Data Mask. Don't forget to let them know what you think - if you want to help shape what data masking by Redgate should look like, the team are always available to talk! More » |
| | Andrew Pruski from SQLServerCentral Blogs Last week in Part Two I went through how to create named volumes and map them to containers in order... More » |
| | Kenneth Fisher from SQLServerCentral Blogs Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about... More » |
|
|
| | | Today's Question (by Steve Jones): For these questions, I am working with RStudio without any additional packages installed. I want to plot the number of Home Runs for Hank Aaron. I create a vector with the CU count: HankAaron <- c(13,27,26,44,30,39,40,34,45,44,24,32,44,39,29,44,38,47,34,40,20,12,10) Now I to graph his home runs over time showing the count of each relative to the others. What should I run? |
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: R Language. 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 | | T-SQL Querying (Developer Reference) Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | | Vishnu Gupthan from SQLServerCentral.com ####################################################################################################################################### Pre requisites for this script to run. A.Below files shoule exist 1. D:\ps\AddUser\AddLoginquery.sql--> Add user SQL script location 2. D:\ps\AddLogin\SQLServerList.txt --> Text file with the SQL Server connection string details ####################################################################################################################################### Log file location --> D:\ps\AddLogin\log1.txt ####################################################################################################################################### D:\ps\AddUser\AddLoginquery.sql should be saved as the .SQL file in the metioned location in the below Format. --For Windows Login creation CREATE LOGIN <name of Windows User> FROM WINDOWS; GO --For SQL Login creation CREATE LOGIN <login name> WITH PASSWORD = '<password>' ; GO ####################################################################################################################################### Once all the above mentoned scripts , location and files are ready , we are good to go with the execution of the powershell script attached. Note: You can very well change the SQL Script to your desired one if you want to perfrom some other operation across multiple SQL Server instances. More » |
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Max. Degree or Parallelism - Afternoon All, Sometimes setting MAXDOP 1 for a query results in a faster execution. Is this simply because the process of... SQL 2016 SP1 CU2 - sudden and unexplained shutdowns - Hi there, Anyone had problems with unplanned instance shut-downs on SQL 2016 SP1 CU2? We patched our Data Warehouse to CU2 in... To find the when SQL server was rebooted couple of times earlier? - Though there are different ways to find when sql server was rebooted couple of times earlier. But is there any... DevOps - Can someone guide me how DEVOPS is useful for DBA Backup detected log corruption in database - Hi. Database FULL backup failed through management plan as well as manual backup. Error Backup detected log corruption in database JMDBIOMET. Context is... How to obtain first, but not empty value? - Hello, I have a table of travel booking details (over several millions of records). Some of the records may have passenger's... Question on CASE statement - In the pic above of the SQL results above I am needing to alter the DisciplinaryActionReasonCode value for any seq... Call Stored Procedure From Another Stored Procedure - Hi Guys, I'm having difficulty with calling a stored procedure from another stored procedure and can't figure out what I'm... XML - Basic but help me out if you can - Hi, This is probably pretty basic but I've never really played with queryingXML. I've attached a screenshot which shows my XML... Add where clause after a stored procedure. - In my asp.net project, I need to code to select a data from a stored procedure and then bind to... Hashing column using SHA256 - I've got a table with one ID column (10 chars long). I'd like to create a new table with 2... OpenRowSet works locally but not over networked drives - Hi, My company got some new stuff. I spent an hour or so on the phone with a sysadmin this morning... Parameterless stored procedure to update insert - I am working on a stored procedure that is supposed to insert or update rows in a remote table. I... Year, Month and Days from date of birth table - Hello, I need Year, Months and Days from date of birth column from age table. Can you please help me to extract... Database not available - Hi hope someone can assist with this. We have a database running on SQL 2008 in our production environment which recently... Database Design Theory regarding best practices for querying tables - Hi all, Up until now, I've largely operated on the principle that any database-related work should be done 100% on the... Partition by or Row num or Subquery - Assistance - Hi I have the below problem. I am trying to see how often a customer has requested Re-Activation of their Internet account. The... Formatting in HTML table - Hi guys, I have created a HTML table dynamically to send on mail. That table contains few amount columns. It's... Job in hung state..How to fix - Good morning Experts, There is a job in hung state as shown above. Please help in troubleshooting this Error 1222: Lock request time out period exceeded - Our server is set up with connections settings with a timeout of 0 (unlimited). However we have suddenly developed a... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
