Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Be kind to yourself today. Remember, progress takes time

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

From Compass '99 to Data Community Summit 2022

At this year's Data Community Summit 2022, I am a part of the day 2 keynote. I'm excited to deliver some thoughts and memories of the event. I'm mostly excited the Summit still exists, and I am looking forward to seeing many of you in Seattle in person again. If you haven't registered, think about it. This is the best place to meet other data professionals, network, and not only get knowledge from the experts, but ask them your question in person.

Someone brought to my attention the original event from PASS wasn't the Summit, but was the Compass '99 conference. I saw a recap of the event on the ITProToday site, which brought back memories. I had attended the event early in my career, convincing my boss that this data specific event would be good for both them and me. It was, and it led me to unfathomable success throughout my time working with databases, along with great personal joy.

I don't remember Mr. Flessner delivering a keynote, but I do remember the late Jim Gray. He talked about storage costs and how we'd see the cost of a TB come under USD$10,000 in a few years. Today I see 1TB mobile phones for around $1000 and external drives for USD$20.

In the early years of attending the Summit, I spent time in sessions, taking notes and learning everything I could. I'd ask questions of Microsoft developers and our community experts. I was then, and am still now, proud of how gracious speakers are, willing to take time to help others and share knowledge with them.

However, the Summit has grown to encompass more than listening to speakers. While you can walk up to a speaker and ask them a question, the random conversations with others waiting their turn near the stage, or walking in the hallways, are the real benefit. I get inspired by what other attendees say. I learn things from them, and I get new perspectives that I might never think about. Whether in the convention center, on a #sqlrun, walking to a hotel, or even out socially at night. Talk usually revolves around data, databases, careers, and how we can grow ourselves as data professionals.

It might not even be technical knowledge. Someone might give you a thought on how to better communicate with others, how to tactfully point out a problem, or even how to find a different job. Perhaps you just get a sympathetic ear in which to vent your troubles and frustrations at work. That alone might help you recharge and go back to work feeling better the next week.

I've been blessed to attend most of the Summits, both in Seattle and around the US. I've been to conferences all over the world, and there is something special about the large data conferences, focused on the craft that we practice. We get the best and brightest in the world coming together to create synergies we get nowhere else. The #sqlfamily is on full display, with introductions taking place alongside greetings by name, handshakes, and no shortage of hugs.

It's a little less than a month until the Summit. There is still time to register and join us, either in person or virtually. I recommend in-person as the benefits outside of the sessions far outweigh the travel costs. I've gotten knowledge to save my company far more than the cost of a flight and hotel. If you have a vexing problem, you might convince your boss that you could easily cover those costs by being able to troubleshoot on a whiteboard with Microsoft experts or industry gurus.

I hope to see you there, and please feel free to stop me for a handshake, hug, picture, or a short chat. If not this year, then somewhere in the future. In the meantime, I hope many of you are as excited as I am. Now, to work on that keynote...

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 18: Time Intelligence Dates Functions

Bill Pearson from SQLServerCentral

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces five DAX Time Intelligence functions related to Dates: DATESBETWEEN(), DATESINPERIOD(), DATESMTD(), DATESQTD(), and DATESYTD(). He discusses the syntax, uses and operation of each, and then provides hands-on exposure to the functions in Power BI.

External Article

Introducing the MySQL INSERT statement

Additional Articles from SimpleTalk

In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that fall into the category of data manipulation language (DML), a subset of statements used to query and modify data. Another DML statement is the INSERT statement, which lets you add data to MySQL tables, both permanent and temporary. This article covers the INSERT statement and the different ways you can use it to add data.

External Article

Sign up to PASS Data Community Summit 2022

Additional Articles from Redgate

There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE.

From the SQL Server Central Blogs - Tales From The Field Weekly Wrap Up for the Week of 10-17-2022

SQLBalls from SQLBalls

 Hello Dear Reader!  I hope you had a fantastic weekend.  This weekend we celebrated my parents 50th wedding anniversary, my oldest daughter flew into town for an early birthday,...

Blog Post

From the SQL Server Central Blogs - Getting Help Online

Grant Fritchey from The Scary DBA

I spend a lot of time in the forums on various web sites, trying to assist people with getting help online. It’s shocking how hard they make it. Let’s...

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

PARSEing strings

What does the PARSE() function do?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

The Scariest Data Type

What's the scariest data type in SQL Server?

Answer: sql_variant, xml, hierarchyid, cursor

Explanation: Happy Halloween! No wrong answers today, but feel free to give your reasoning in the discussion.

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 - Administration
Publish AWS RDS SQL Server Database - I am in the process of migrating an on-premises application to AWS.  The on-premises app publishes a SQL Server db, subscribed to by a couple of other servers in our environment.  I am struggling to find a way to replicate that functionality in AWS RDS SQL Server.  Lots of guides on replicating into RDS, but […]
Get Read and Writes per a duration - Hello, I want to be able to view the number of read and writes for a database or (tables in the database) in a day or week or month. Currently, I am using the following query: SELECT name AS 'Database Name' ,SUM(num_of_reads) AS 'Number of Read' ,SUM(num_of_writes) AS 'Number of Writes' FROM sys.dm_io_virtual_file_stats(NULL, NULL) I […]
SQL Server 2017 - Development
Update Column query - Hi All. Need help in implementing this logic. I have a table in below format. Currently, a new Config ID is generated for every item number- Revision combination. I want to take the config ID of minimum(Revision) for every item number and update it per item number. Expected Config ID is desired output. It is […]
SQL Server 2016 - Administration
Patching AlwaysOn AG - Hello Everyone, I have Availability Group, one primary replica and one secondary replica. SQL Server version is 2012. It is configured for automatic failover and is in synchronous mode. I already googled but found different answers, so I want to know the correct procedure. How to do patching step by step.
SQL Server 2016 - Development and T-SQL
Create table having a StartDate and EndDate for each week - I want to create a table that has a StartDate, EndDate, WeekNum for the year 2021 starting with the First Wednesday of January to the end of December ( I know the last week may land in 2022, that's fine).  So in 2021, the first wednesday is January 6.  So the table would start with […]
SQL server help - I need to show the total count for a particular field with my select statement. But this should be shown only once for each VID. I wrote the following to get the count, but it displays it for every record. Is there away to display it only in one row for a specific VID? I […]
SQL 8144. Error: Procedure \'InitiateLoad\' has too many arguments specified. - Hi Community, When I attempt to execute the following Procedure called InitiateLoad, I get the error: Sql error number: 8144. Error Message: Procedure or function InitiateLoad has too many arguments specified. Can someone take a look at the SQL Code and let me know where the problem is:   CREATE PROCEDURE Process.InitiateLoad (@Area VARCHAR(150), @Domain […]
SQL 8144. Error: Procedure 'InitiateLoad' has too many arguments specified. - Hi Community, When I attempt to execute the following Procedure called InitiateLoad, I get the error: Sql error number: 8144. Error Message: Procedure or function InitiateLoad has too many arguments specified. Can someone take a look at the SQL Code and let me know where the problem is:   CREATE PROCEDURE Process.InitiateLoad (@Area VARCHAR(150), @Domain […]
Capturing what calls a trigger - I have a DML trigger and I need to know where the action is being called from, whether it be a simple T-SQL command or a stored procedure.  For example, if I have an insert trigger on Table A and that trigger runs, I want to know what code was executed that caused the trigger […]
SQL Server 2019 - Development
How do I JOIN to a Linked Server in a VIEW without using a CTE - I need to create a VIEW that joins a table in the current database (SSMS2019 environment), to a table in a database on a different server (SSMS 2014 environment). The VIEW will be created in the 2019 environment server. To start, I created a Linked Server in my 2019 server called [REMOTE_SERVER_2014_ENV] which successfully connects […]
SQL Azure - Development
What can we do about SSRS and SSIS in an Azure VM? - We have a third-party product which uses SQL Server 2016. It also uses both SSRS and SSIS. The network group wants to migrate the test version of this database into an Azure VM - basically a lift and shift approach. We asked the vendor of the application for their input as to the viability of […]
SSRS 2016
Drill down Action: one main report with two subreports - Hallo, i have to implement one main report with two sub reports. In the main report and the subreports the columns are closed.  By a drill down action, the selected column in each of the three reports should open. How can I implement this drill down behaviour in all three reports? Thanks, duloran  
General
When using Microsoft 365 tools, how do you backup your data? - Is there any easy way to automatically backup my data using the microsoft 365 tools, and it is possible to set schedules? and is there any option to retrieve my loss file?. Thanks by the way.
Integration Services
How to keep For Loop Container continue on error? - Hi all, So I found a solution of a problem I was having with For Each Loop Container in my SSIS package. If error was received on any of the task inside container the package was failing instead of going to next iteration. The solution found here: https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/ is to create event handler on error and […]
SQLServerCentral.com Website Issues
E-mail Notifications - I've noticed that I've received no alerts today. Are others experiencing this?
 

 

RSS FeedTwitter

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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -