Monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services (2020-02-24)

 SQLServerCentral Newsletter for February 24, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services]( - [Deployment Suite for Oracle: What’s New?]( - [Saving Game Data with Unity]( - [From the SQL Server Central Blogs - Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)]( - [From the SQL Server Central Blogs - Top 3 Database Life Hacks]( Question of the Day - [More PowerShell Variables]( The Voice of the DBA  Toilets and Your Systems Today we have a guest editorial from Grant Fritchey as Steve is away on his sabbatical. There is no way in the world that simply flushing the toilet could sink a ship. Right? Well, actually, yeah, it not only could, it did. Not a ship in this case, a boat, but, yes, flushing the toilet [did sink this U-Boat](. However, it wasn’t simply the toilet that brought down, literally, this submarine. It was a combination of bad design, poor training, and gross operator ignorance. Does that sound familiar? Yeah, to me too. I’ve worked for that company, several times. When we start designing systems, whether we’re talking at the macro scale of building out your data center, or at the micro scale of creating a new database, we’re starting from a particular set of knowledge. We may be great at what we do, or not. However, no one knows everything. Further, we make compromises to the design, whether to offset costs, increase speed of delivery, who knows. Then, requirements change over time, and we introduce more compromises. Suddenly, here we are, standing in front of the systems equivalent to the U-1206 toilet, and we need to flush. Let’s add to the fact that maybe your organization hasn’t had a data specialist for a long time, if ever. So, others fill in the gaps. I became a DBA that way and I know a bunch of others who followed similar paths. Now you’re standing in front of your toilet, uh, I mean database, and you need to flush, oh, wait, tune a query, run a restore, whatever. Yet, you haven’t done it before. The senior person you do have is either unavailable, or you never had a senior person. So, you’re going to try the valve alignment/database restore on your own. Where is all that water coming from? One of the reasons I love history is because it really does teach us so much. We do need to think through our systems, databases, code, what have you. Is the system overly complex? Can we simplify it? If we can’t, do our people know enough to deal with the system as is? Do we have training in place to ensure that people are ready? Can we get our people to a less ignorant state before they flush that toilet and sink our figurative submarine?  Grant Fritchey [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services]( Pablo Echeverria from SQLServerCentral Learn how to monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services [Deployment Suite for Oracle: What’s New?]( Additional Articles from Redgate Stephanie Herr describes the new features in the Deployment Suite for Oracle that will help you automate your database releases safely, on Linux or Windows. [Saving Game Data with Unity]( Additional Articles from SimpleTalk One of the most critical things that a game must do is to save data like the preferences and score. In this article, Lance Talbert demonstrates two ways to save data when you create your game in Unity. From the SQL Server Central Blogs - [Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)]( Adetokunbo Ige from Adetokunbo Ige I am very passionate about having a disaster recovery architecture, plan and strategy. This is very important for business continuity. I will be walking you through a journey on implementing High Availability (HA) (AlwaysOn Availability group) on MSSQL Server. From the SQL Server Central Blogs - [Top 3 Database Life Hacks]( SQLRNNR from SQL RNNR Three very powerful but simple hacks that can give you back dozens of minutes per day. Related Posts: Best New(ish) SSMS Feature December 26, 2017 Puzzles and Daily Trivia May 14,...   Question of the Day Today's question (by Steve Jones - SSC Editor):  More PowerShell Variables I have this code: $name = 'Steve' write-host( 'My name is $name') What is returned? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Kendra Little) Fashion What kind of shirts does Steve Jones like to wear? Answer: Hawaiian Explanation: [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 [TDE for Always on databases]( - Hi All, In terms configuring and usage of TDE encryption is there a difference for Standalone instance databases & databases involved in AG? Because the secondary will be in read-only, just want to know how to configure TDE on AG databases and during failover do we need to take care of any additional steps etc.. […] [Parameter Sniffing]( - Hi All, I know there are various causes for parameter sniffing issues, but one I want to focus on is: not having a covering index. Logically speaking then, having a covering index would be a way to address the issue. This is further evidenced in Tara Kizer's comment on: There’s lots of ways to […] [script out the dbmail settings and profiles]( - How can we take the script of existing db mail settings and profiles ? Administration - SQL Server 2014 [Problem with KB4532095 installation]( - Has anyone else had trouble installing this security patch? It starts up and I get to the screen where I have to select my instances and it won't select anything... my instance is running and I can connect to it. But the update patch won't let me select anything on this screen. Any thoughts on […] SQL Server 2012 - T-SQL [update query is running very slow]( - HI All, I am new to sql tuning. I have this below update statement which is taking more than an 1 hour. Why it is taking long time or is there a way to speed things up? UPDATE [dbo].[Test_tbl] set SQL_DETAIL='SELECT ROWID_OBJECT, HUB_STATE_IND, MDM_ID, SEQ_NM, MSP_END_CUST_NM, SEQ_TYP_CD, OST_NM, ALIAS_NM, STATUS_CD, DUNS_NMBR, C3_DUNS, BO_CLASS_CODE, C6, C6_NM2, […] SQL Server 2019 - Administration [grant unmask to role]( - Hi All, i am using SQL Server Management Studio 2017. i have a database and i have masked a column. There are 500 users who are using the database. Upon request i need to provide unmask data to around 150 users. Would it be possible to create a database role and give the grant to […] [Cannot connect to SQL Server, which is on VirtualBox, through my host computer]( - I have successfully pinged and telnet my virtualbox with my host computer but when I go to connect to the sql server with workbench I get the following error: 'Lost connection to MySQL server at 'waiting for initial communication packet', system error: 60'. Have tried everything it seems like and cannot seem to fix the […] [SQL Replication - Uncooperative Databases]( - I have a database from a vendor which I need to mirror. This database, as a product, has tables which are dropped and recreated, truncated regularly, etc. Many issues which prevent a replication from being set up as I normally have. I very much wanted to have a transactional replication of this database as a […] T-SQL (SS2K8) [Transposing the data and then converting monthly data to daily data]( - I have a Budget Table in following format Account -- Year -- Month1- Month2- Month3- Month4- Month5- Month6- Month7- Month8- Month9- Month10- Month11- Month12 500100 - 2020 - 100 - 200 - 300- 300- 300- 300- 300- 300- 300- 300- 300- 300 I would like to convert the data like below Account Period Amount 500100 […] SQL Server 2008 High Availability [What's the requirement to have a witness server added?]( - I have a database which is configure with High safety without failover operating mode for it's mirroring. Now I would want to add a witness to this mirroring to allow it to perform automatic failover. May I know what is the requirement for the witness server? Does this server need to have a sql server […] SQL Azure - Development [FileStream - Azure managed instance]( - Hi, Simple question, I know that FileStream is not supported in Azure DB single database or Elastic pools but is it supported in a managed instance? I've tried to find a definitive answer but I'm getting conflicting info. Says it only applies to SQL Server (Windows Only) and not Azure SQL Database But […] Amazon AWS and other cloud vendors [Amazon RDS linked server issue]( - I have an RDS issue with a linked server (I know its not good, but I've inherited it) I keep loosing my linked server and we get the error "an error occurred during encryption" according to my google assistant and a few hours research every time... this occurs when Amazon switch us onto new hardware […] Integration Services [OLE DB Destination has written 0 rows]( - Hi SSC, I'm having issues with one SSIS Package running on SQL Server 2017. What it does is basically: Truncate Table DFT OLE DB Source -> no Transformations or something -> OLE DB Destination When I run the Source Statement wether it's as a source preview or SQL Statement it works as expected. When I […] Hardware [Search for wicked fast direct attach storage]( - After working and managing many different SAN's ( i am not going to name them but you can guess, these are top 5 ) i am sick and tired of dealing with networking changes and having army of people lined up to add a shelf. I was super happy with FIO direct attached storage, scaling […] Disaster Recovery [Clustering - WSFC vs AGs]( - Hi, More and more I'm having discussions with customers who want to move away from FCI to AGs. The main reasoning is that AGs offer "faster, almost instant" failover times. I will admit I've never delved in to this difference, so I am asking here. What are the under-the-hood pros and cons of each; there […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -