Stairway to SQL Server Agent - Level 3: Agent Alerts and Operators (SQLServerCentral 12/13/2017)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Stairway to SQL Server Agent - Level 3: Agent Alerts and Operators]( - [Free eBook: SQL Server Transaction Log Management]( - [Partition Level Locking: Explanations From Outer Space]( - [Checking SQL Configuration with Pester & Dbatools]( (From the SQLServerCentral Blogs) - [Security Architecture: Knowing the Adversary]( (From the SQLServerCentral Blogs) The Voice of the DBA It's Time for SQL in the City Today is [SQL in the City 2017](. Once again we're streaming the event online, live from Cambridge in the UK. I've flown over, along with Grant Fritchey and Kathi Kellenberger to entertain you for the day. We'll be broadcasting at 11am in the UK for five hours before we take a short break and return for a 1pm EST start of the second broadcast. You can still [register]( and we hope you'll tune in for a few a session or two, or all of them if you can convince the boss to give you a training day. You won't know unless you ask. I'm excited to show off a few things today, as I'm sure Kathi and Grant are as well. Our developers have been hard at work throughout the year, improving our software and adding new features, while fixing a few bugs. It feels like the pace of change is steadying out, with most products releasing changes every two weeks, but we're adding a lot more exciting and interesting changes. It seems that the products are maturing well, in ways that I didn't expect. I've been especially excited by the changes in SQL Clone this year. We've really grown this product up, with the team being reponsive to customer requests. It's exciting to be the one to present some of the changes to you, as well as try to introduce others to the product. This is one of those products that I wish would have been available 15 years ago as I would have saved lots of storage costs as well as gained a tremendous amount of flexibility. SQL Prompt and SQL Monitor have also had great years, and I've been impressed with their growth. Unfortunately I didn't get the short straw and had to leave those products to my colleagues. I guess I can't have all the fun. Maybe I'll try to photobomb my way into one of those sessions. Presenting at events is exciting, and I'm looking forward to the day. It's long, but it will still be a fun time. These streaming events are also a neat experience, as we've got a bit of a TV studio feel, with multiple cameras, displays, tape on the floor, and more. For someone that is used to sitting at a desk and working at my pace, I get a little excited by the efforts put into the broadcast from our IT staff. We have various schedules and checklists, and I've spent the last couple days rehearsing the talks. I still like live events, and hope we'll do a few in the future, but for now, sit back, relax, and enjoy SQL in the City from the comfort of your office. 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.7MB) 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 [SQL Compare]( 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]( [Database DevOps]( Continuous Delivery for SQL Server Databases Spend less time managing deployment pain and more time adding value. [Find out how with database DevOps]( Featured Contents  [] [Stairway to SQL Server Agent - Level 3: Agent Alerts and Operators]( Richard Waymire from [SQLServerCentral.com]() How to be notified when a job succeeds or fails, or be notified when a SQL Server performance condition is met.[More »](Series/72453/) ---------------------------------------------------------------  [] [Free eBook: SQL Server Transaction Log Management]( Press Release from [Redgate]() When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.[More »]( ---------------------------------------------------------------  [] [Partition Level Locking: Explanations From Outer Space]( Additional Articles from [Brent Ozar Unlimited Blog]( Erik Darling partitions the Stack Overflow database, then uses sp_WhoIsActive's @get_locks = 1 parameter to demo locking.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Checking SQL Configuration with Pester & Dbatools]( Andrew Pruski from [SQLServerCentral Blogs]( I know, I know, there’s loads of different ways to test the configuration of SQL Server but I’ve started playing...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Security Architecture: Knowing the Adversary]( Brian Kelley from [SQLServerCentral Blogs]( When I present or teach on a security topic, I take the time to cover the mindset of the adversary....[More »]( Question of the Day Today's Question (by Steve Jones): I want to create a function in R that will return the next number of a Fibonacci sequence if I pass in the current 2. How should I write this code? 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 [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): I'm working with sales and I want to sum my totals by year and month, but I'd also like a total for the year in my result set. I have a few queries I've written. Which of these will give me a total for each month and a total for the year? I should end up with 13 rows in my result set. -- Query 1 SELECT YEAR(OrderDate) AS OrderYear, MONTH(OrderDate) AS OrderMonth, SUM(SubTotal) AS Incomes FROM Sales.SalesOrderHeader WHERE YEAR(OrderDate) = 2012 GROUP BY YEAR(OrderDate), MONTH(OrderDate) WITH ROLLUP; GO -- Query 2 SELECT YEAR(OrderDate) AS OrderYear, MONTH(OrderDate) AS OrderMonth, SUM(SubTotal) AS Incomes FROM Sales.SalesOrderHeader WHERE YEAR(OrderDate) = 2012 GROUP BY YEAR(OrderDate), MONTH(OrderDate) WITH CUBE; GO -- Query 3 SELECT YEAR(OrderDate) AS OrderYear, MONTH(OrderDate) AS OrderMonth, SUM(SubTotal) AS Incomes FROM Sales.SalesOrderHeader WHERE YEAR(OrderDate) = 2012 GROUP BY GROUPING SETS ( YEAR(OrderDate), (YEAR(OrderDate),MONTH(OrderDate)) ); GO Answer: Query 3 Explanation: The GROUPING SETS query (query 3) will return the results correctly. This gives me a group by each month (12 rows) and a final row for the year. The ROLLUP operator will give me 14 rows, one which has the year total and one that has a null for the year that repeats the total. The CUBE operator gives me too many rows. A loop could work, but it is unnecessary. Ref: GROUP BY - [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 2017]( : [SQL Server 2017 - Administration]( [How do I log into SSMS v17 on a home network?]( - I've got SSMS v17 installed on a new laptop. And I've got SQL Server 2016 Developer Edition on a desktop... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [SSRS Subscriptions => The job failed. Unable to determine if the owner (MyDomain\ReportService) of job ... has server access ... error code 0x5. (Error 15404)]( - Hello, I have searched this issue for a full day and have been unable to determine the best route to... [Need chart for DB size vs Recommended memory for SQL Server dedicated VM Server.]( - Is there any recommended chart from where I can setup up the Server Memory for the size of database or... [SSRS - Inherited Server - Unable to find instance - Is it possible to repair?]( - Hello! On the SQL 2016 Server I am a "DBA" of now, I was looking to setting up SSRS. At first... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [error on dynamic sql]( - Hello comunity, I try to solve this SP but i always have the same error maybe due to numeric fields ? [code... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [Bulk insert into table from csv]( - Hi, i have table in CSV: As you can see there are a lot of columns. My source table data types fields are: --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [How to get TOP ID in query?]( - USE GO CREATE TABLE .(     (15, 2) NOT NULL CONSTRAINT DEFAULT ((0)),     (10) NOT NULL CONSTRAINT DEFAULT ((0)),     ... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [Intellisense broken?]( - Up until about a week ago, Intellisense on my SSMS worked fine. Now it's still working but for some reason... [Retrieving revenue total for last day of previous month]( - Hi Im trying to retrive total revenue last day of previous month, i can get all the months totals, however i cant... [SpinLocks]( - Hello, Does anyone know what the following Spinlocks stand for? name collisions spins spins_per_collision sleep_time backoffs ALLOC_CACHES_HASH 426181802 324947377588 762.4619 25544 154546374 SOS_CACHESTORE_CLOCK 13071 5429436964 415380.4 0 17156 SOS_OBJECT_STORE 6559674 ... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [PRIME NUMBERS]( - Dear all, I have SP : CREATE proc . (@opt tinyint, @ResultCount int) as set ROWCOUNT @ResultCount declare @NextInt int--This is the next number... --------------------------------------------------------------- [SQL Server 2008]( : [T-SQL (SS2K8)]( [query help]( - IF OBJECT_ID('Tempdb..#tStudents') IS NOT NULL DROP TABLE #tStudents CREATE TABLE #tStudents(    (6) NOT NULL ,   (50) NOT NULL,   (MAX) NULL,     ... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server Newbies]( [Can we restore copy-only full backup and regular tlog backup?]( - Good Morning Experts Can we restore copy-only full backup and regular tlog backup? --------------------------------------------------------------- [Cloud Computing]( : [SQL Azure - Administration]( [Monitor spids on SQL Azure instance? Can we do it?]( - Hi All, Can I do the below for SQL Azure instance/db? Suppose, I want to take a look at what is... --------------------------------------------------------------- [Programming]( : [General]( [How to Automate the closing of a window?]( - What is the best way to automate the clearing out of an error message that pops up a few times... --------------------------------------------------------------- [Data Warehousing]( : [Integration Services]( [Design Input for ETL of OLTP Database]( - Hello All - I wasn't sure exactly where my question fit, so thought i'd put it here first. I just started... --------------------------------------------------------------- [Data Warehousing]( : [Strategies and Ideas]( [Effective date updation in Fact records]( - HI Team This would be a common problem and I tried to search the net but could not find a... --------------------------------------------------------------- [Data Warehousing]( : [Analysis Services]( [Distinct Count on Column in Tab Cube]( - Hello, I have a tab cube, with a dimension key column I'd like to get a distinct count on with... --------------------------------------------------------------- [SQL Server 2005]( : [T-SQL (SS2K5)]( [Find and count Incomplete records in a table]( - Hi, I have a problem which is stretching my basic T-SQL coding capabilities and hope you might be able to... --------------------------------------------------------------- [SQL Server 7,2000]( : [Administration]( [Tempdb]( - 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