| A community of more than 1,600,000 database professionals and growing |
| | | Where Do You Run Your R Scripts? I know most of you don't work with the R language. In fact, plenty of you might not know anything about R other than a cursory understand of this as some sort of data analysis language. If you want to know more, here's what the R Project is. Microsoft wants you to use R Services in SQL Server, or the R Server product available as a standalone system. However, I saw someone ask the question why would someone run their R scripts inside SQL Server, because these are expensive CPU cycles to burn on analysis. Someone else noted that Microsoft loves your licensing dollars, so their push to use R Services is perhaps a little self serving. Push the intellignce to the data makes sense. Isn't that what we do with large data warehousing queries or SSAS cubes? We're trying to get the analysis done at scale without having to move the data elsewhere, especially considering we've (usually) already moved the data in some sort of ETL (or ELT) process. Gaining insights from our ever increasing scales of data requires some computational cycles somewhere. What's the alternative? Large queries that pull data to some client? I think that's fine, and that might be a better alternative since simple queries to pull data don't burn as many CPU cycles as those that might perform analysis. I certainly understand that the licensed CPU cycles for a SQL Server instance are expensive, and we want to be careful how they are used. Adding complex R scripts might not be the best use of our licensing dollars. On the other hand, if I can perform analysis quicker, that is more useful, than perhaps I can eliminate other random queries analysts want to run on my database? Ultimately I think that R Services make some sense in SQL Server, but not as some experiment. I would suggest that the R client is the way to experiment, preferably on a copy of data that allows someone to build scripts and determine if there is insight to be gained from a particular set of data. Build a Proof of Concept (POC), and only deploy it to a SQL Server if you find it provides value. And if you do so, continue to experiment. That R script you run today might not be as useful in six months as your application, database, and business evolve. Data analysis isn't a set-it-and-forget-it, but rather an ongoing, iterative process. 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.8MB) 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 | | | | Want to include your database in your ALM processes? With Database Lifecycle Management, you can add your database to your source control, continuous integration, and release management processes, to reduce risk and improve efficiency. See how with this free whitepaper. |
| | | | How to fix SQL Server disk I/O bottlenecks (without a hammer) In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now. |
| | | | How can you help your team write better, shareable SQL faster? Find out by discovering 15 Super SQL Tips from Microsoft MVPs and other SQL Server experts. Using SQL Prompt to write, refactor, and share SQL, they show how it strips away the repetition of coding and standardizes it everywhere. View the tips and download a free trial. |
|
|
|
| | | | | Mala Mahadevan from SQLServerCentral.com In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R. More » |
| | The team behind SQLServerCentral.com will be in Seattle at the PASS Summit next week, and we’d like to hear from you. If you’re heading to the event, we’d love to get feedback on how you use the site, and hear about any changes you’d like to see. If you’d be willing to have a quick chat, please email us webmaster@sqlservercentral.com, and we’ll set up some time with Steve and the team. More » |
| | Additional Articles from Database Journal Arshad Ali demonstrates how you can analyze the data collected by Query Store either with T-SQL scripting or with the graphical user interface in SSMS. More » |
| | Todd McDermid from SQLServerCentral Blogs Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server... More » |
| | dustinryan from SQLServerCentral Blogs I had a call with a customer this morning discussing different ways to publish Power BI content and how to... More » |
|
|
| | | Today's Question (by Steve Jones): You work with a junion DBA that was told to implement a way to track who is logging into a SQL Server 2016 instance. The DBA wants to use a logon trigger, but you have been concerned with the way this trigger is written. As part of a troubleshooting script, you want to ensure you can quickly remove the logon trigger if there are issues. The trigger name is "CaptureLogins". Which batch should you 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: Triggers. 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 | | If you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I decide I want to grant someone else the ability to back up databases. I create a new login, BackupOp, and assign a password to this account. I have two databases on my instance, Sandbox, and Sandbox2, that developers use. In the Sandbox2 database, I perform the following: CREATE USER BackupOp FOR LOGIN BackupOp; GO ALTER ROLE db_backupoperator ADD MEMBER BackupOp; GO In the Sandbox database, I do this: CREATE USER BackupOp FOR LOGIN BackupOp; GO One of our developers connects to the SQL Server instance with the BackupOp login, using the Sandbox database to run some queries. They decide to they want to also test in Sandbox2, but first need to run a backup. Does this work: USE sandbox; GO BACKUP DATABASE SandBox2 TO DISK = 'SandBox2.bak'; GO
Answer: This works fine. Explanation: This works fine. The user has the db_backupoperator role in Sandbox2, and can issue the BACKUP DATABASE command from any other database context. Ref: I cannot find a direct reference for this scenario. BACKUP - https://msdn.microsoft.com/en-us/library/ms186865.aspx » Discuss this question and answer on the forums |
|
|
| | | | S M from SQLServerCentral.com Copy the script in SSMS Run it Capture the details and use it accordingly. You can find some useful details like:- 1. backed up page count 2. compression ratio 3. Throughput - KB/sec 4. Device where the backup was taken. Etc.. 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. Newbie here... Wishing to learn SQL and SSIS/SSRS/SSAS - Hi all, A newbie here wishing to ask for advice on Microsoft Business Intelligence. Hoping this is the right forum to... Accidentally Overwrote Stored Procedure - I was working in the "Modify" script of a stored procedure just now. I accidentally selected only a small part... Differential backup too big - Since two weeks, my differential backups are getting too big. I have a 4 TB database. Our backup schedule: full... Blocking by Insert - Found the below query causing blocking from different SPID. declare @0 bigint,@1 bigint,@2 varchar(50),@3 bit,@4 varchar(50),@5 datetime2(7),@6 varchar(50),@7 datetime2(7) INSERT [dbo].[Transaction] ([TransactionId], [ConId],... FCI + AG Alwayson 2014 - Hi Guys, I need some one to clarify please. It very urgent. We have Two stand alone SQL Server 2014 server... Displaying Multiple rows clock event Under a different Column view - I would like to query the data were table output is by each row but i need need display the... Very bad performance on a good HP DL380 Gen9 Server - This issue is something that I haven't had much luck trying to solve via on-line research, and was hoping to... Deadlock error MERGE - I have a step that produces the xml and the MERGE table 1 insert and update, if you run it... SQL error: A severe error occurred on the current command. The results, if any, should be discarded - I am using VS Studio 2105 to create a console app and SSMS 2014 v 12.0.410. I am running a... SQL query running slow after upgrading from 2005 to SQL 2012 - I’m seeing some strange behaviour with the ''update" query If you increase the ‘available’ memory available to the SQL Instance... Recording data changes - I'm working with a windows application that uses SQL Server 2012 on windows server 2012 R2. There is something happening... sql backup - Do you have any idea how long it might take to sql backup for 600 gb. Thank you log is full due to Availability Replica - We had log full issue on primary replica and log was waiting on Availabilit _replica. When checked the Asynchronous DR... Dynamic rows into columns - Hello, I'm a SQL Server novice. I've been polishing up on my T-SQL skills while working for the last few months... update trigger get fields before and after update - Hi, Im inserting data into audit table before update and after update is there any other effective method. Create trigger trg_employee on employee AFTER... Mystery Value in Variable - I'm trying to interpret the code of the guy who preceded me at my current position (unfortunately he's dead, so... DBCC Checkdb cannot exclusively lock database - We are running weekly DBCC CheckDB job. The error is "The database could not be exclusively locked to perform the... With recompile in the master stored proc - Dear all, If I have a procedure like: sp_1 (@par1, @par2) AS begin exec sp2 exec sp3 end if I add the expression "with recompile" on the master... Restore database - Dear all, how do I know if the backup files are ready to restore without any corrupt ? How to make sure... Fact table with hundred of columns - Any alternative? - Hi everyone, I am designing a accumulating snapshot fact table to evaluate the performance of the product forecasts since they... |
|
| 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 ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
