Load Extended Events via Powershell (SQLServerCentral 8/22/2017)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Load Extended Events via Powershell]( - [How to Find Out Which Database Object Got Deleted]( - [Power BI Custom Visuals Class (Module 62 – Beyondsoft Calendar)]( (From the SQLServerCentral Blogs) - [SELECT…INTO in SQL Server 2017]( (From the SQLServerCentral Blogs) The Voice of the DBA Jumping Ahead While on vacation recently, I went to see [Spider-Man Homecoming]( with my family. It was an enjoyable movie on a rainy afternoon, and a nice addition to the Marvel lineup. I think this actually might be my favorite Spider-man movie, and I'd recommend you watch it if you enjoy this genre. It was humorous, well written, and some nice special effects. As with any of these Marvel movies, you definitely need some suspension of disbelief, especially with the technology. In the movie, Peter Parker is anxious to join the Avengers and become a full time super hero, going on missions that have a large impact in the world. He chafes as the idea that he needs to stay in school and let his life progress at a more normal pace, which Tony Stark seems intent on pushing. Many of us have felt the same chafing in our own youth, wanting to get out of school, go to work, and move on in life. However, even in our careers, I find people wanting to jump forward, moving to new technologies and platforms as quick as possible. I certainly see this in the SQL Server world, often from developers, that want to find the holy grail of database storage in CouchDB, CosmosDB, Neo4J, etc. I've often seen this in the development world with different types of technologies, such as web frameworks. Maybe we in the data space are more conservative? Or we like sticking to what we know works well? We data professionals are not immune from the desire to jump ahead. I see plenty of data people wanting to jump into some new area to grow their careers. Data Science ( and AI, Machine Learning, etc.) is the newest craze, with quite a few people learning some R, some model training, and wanting to find a use for their skills. Or maybe an employer, preferably one that pays more than they make now. Good luck to you, but I'd encourage you to remember that good data science takes lots of skill, knowledge, and practice. I wouldn't expect a quick jump into this new area. There are certainly other changes in the data world, such as the graph capabilities coming to SQL Server 2017 and the explosion of cloud database implementations. However, don't get caught up in expecting quick changes in your job or your income. Continue to learn, experiment, build a POC and practice your skills. Change usually comes for most of us at measured paces. This pace is hard to accept if you don't have the habit of regularly learning something and applying it in small doses, understanding that not everything you learn will be useful (or used) in your current situation. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( --------------------------------------------------------------- The Voice of the DBA Podcast Listen to the [MP3 Audio]( ( 4.2MB) podcast or subscribe to the feed at [iTunes]( and [Libsyn](. [feed]( 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 [Redgate Hub]( Do a lot more with Redgate tools You probably have a favored Redgate tool but if you’ve been using it for a while, you may not be making the most of the latest features. Keep track of features and releases on the new Redgate Hub. [Discover the Redgate Hub]( [SQL Clone]( SQL Clone: Now supporting databases up to 64TB Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. [Try it free]( Featured Contents  [] [Load Extended Events via Powershell]( Aakash Patel from [SQLServerCentral.com]() Learn how you can load Extended Events with PowerShell, nice and fast.[More »]( ---------------------------------------------------------------  [] [How to Find Out Which Database Object Got Deleted]( Additional Articles from [Database Journal]() Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Power BI Custom Visuals Class (Module 62 – Beyondsoft Calendar)]( Devin Knight from [SQLServerCentral Blogs]( In this module you will learn how to use the Beyondsoft Calendar Custom Visual. The Beyondsoft Calendar displays a single...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [SELECT…INTO in SQL Server 2017]( Andrew Pruski from [SQLServerCentral Blogs]( One of the new options available in SQL Server 2017 is the ability to specify a filegroup when using SELECT..INTO...[More »]( Question of the Day Today's Question (by Steve Jones): I am trying to round down for in my coffee card tracking to ensure that I never run out of money. For each amount, I want to round down and ignore the cents, which means that I will be saving fractions of dollars throughout the year. I'll use all these at the end of the year to buy Christmas presents. I also want my deposits (show as negatives) to also be rounded, to add more savings. In testing, I don't seem to get the right results from this query. WITH mycte (a, n) AS (SELECT a, n FROM (VALUES ('Coffee', 2.38), ('Coffee', 4.53), ('Recharge card', -15.50), ('Recharge card', -5.25)) a (a, n) ) SELECT a, SUM(FLOOR(n)) FROM mycte GROUP BY a; I have more tracked in recharges than I added, not less. Why? Here are my results. a ------------- ------- Coffee 6 Recharge card -22 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: T-SQL. 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 [Exam Ref 70-761 Querying Data with Transact-SQL]( Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. [Get your copy from Amazon today](. Yesterday's Question of the Day Yesterday's Question (by Steve Jones): What parameter for SQLCMD will give performance statistics in a compact way, with the values just separated by a colon? Answer: -p1 Explanation: The -p1 parameter is used to compact the performance statistics to just the values, colon separated. Ref: SQLCMD - [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](. --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [Index creation not completed]( - Hi, tried to create below index CREATE NONCLUSTERED INDEX IDX_POSITION_ID_FROM_DATE_TO_DATE ON . (,,) INCLUDE (,,,,,) index creation is not completed after 30 minutes. issue is in... [Best practices for setting up service users]( - I'm very new to setting up SQL Servers, and I'm wanting be diligent about security. I'm currently setting up a... [Strange transaction log activity]( - I'm suddenly seeing unusually large transaction log backups for a small database, and the application team swears that nothing has... [SQL Server Data Tools and Management Studio 17.x on Disconnected Networks]( - Hi All, Rumors have been circulating that if telemetry is blocked and there is no internet access, SQL Server Data Tools... [how to deploy 10 T-SQL scripts across 200 databases]( - Hi , Can any one suggest an efficient way where we can apply about 10 T-SQL scripts on about 200 databases... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [Need help with "Where" clause]( - Hi Everyone,     I have a query that brings back a list of orders. I have the SELECT portion to where... [SSRS Sunburst - Show Labels Outside]( - Hello, We are changing our data effective September 1st which creates the need to change one of our dashboard graphs from... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [Script or Ways to check if SSRS encryption key backed up]( - Hi Experts,      Can anybody help me finding out how to check if the SSRS encryption key have been backup up... [Standard to Enterprise Edition upgrade or reinstall]( - I just installed a new SQL 2014 Standard Edition with Rpt Services and Analysis Services and realized I installed Standard... [RAMDisk? Use it for TempDB?]( - RAMDisk used to exist in Windows NT. I used it and it worked really well. Then, it was eliminated in... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [Optimize query that is using like statements]( - I currently have a large query which is taking over an hour to run, and am attempting to optimize. Unfortunately,... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Help on Writing multiple steps query]( - Create [Need to find a store procedure in a database]( - Hello Experts. Ive been trying to find the whole weekend a logic which is creating a xml file of this calculation: --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [How to reduce the space /shrink SQL Server 2008 R2 Data file (MDF) and Log file (LDF)]( - Dear Guru's, I have read that using the DBCC ShrinkFile is not the best practice but our data and log files... --------------------------------------------------------------- [SQL Server 2008]( : [T-SQL (SS2K8)]( [Trying to create function to create folders (and sub folders)]( - I'm using sp_OACreate in a scalar function to create a folder if it doesn't exist, and it works fine if... [Subroutines in TSQL]( - I am a heavy TSQL coder, I love the many aspects of TSQL but I always wonder why we should... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 Performance Tuning]( [Enormous Page Life Expectancy (PLE)?]( - I've been running perfmon and analysing the results on a production Windows 2008 R2 server running SQL Server 2008 R2... --------------------------------------------------------------- [Data Warehousing]( : [Analysis Services]( [Why did added partitions make cube processing slower?]( - We have a cube based on a 300 Million --------------------------------------------------------------- [SQL Server 2005]( : [Data Corruption]( [Corrupted page not repairable w/ DBCC - how to delete it?]( - Hi all, My db has a corrupted page (checksum mismatch) that is not getting repaired by DBCC CHECKTABLE(tReports, REPAIR_ALLOW_DATA_LOSS). Other errors... --------------------------------------------------------------- [Career]( : [Certification]( [70-473 Anyone studying for this, or passed it?]( - Hello, I'm studying for this exam, just wondering if anyone else was? Regards, D 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](. 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: webmaster@sqlservercentral.com