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

Daily Coping Tip

Take time to reflect on what you accomplished this week

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.

What I Learned at Community Summits

I went to the first  Community Summit in 1999. This was one of the first conferences of my career, and I was excited to have one focused on SQL Server and data. I met Kalen Delaney and shook her hand after having her educate me about how tempdb worked in SQL Server 7. That event started a 20-year journey of traveling to subsequent Summits nearly every year since. Over the years, I have a lot of memories from Summits, mostly of people that I've met and talked with. Much of the time I've been at any of the Summits was spent on networking and business purposes more than learning, but I have picked up a few things along the way.

Early on Brian Knight and I delivered a presentation in a debate format. We were talking about the pros and cons of using identities. It was an enjoyable session and one where we learned a few things. A developer from Microsoft was in the audience and helped clarify some of the specific numbers related to limitations and scaling issues with using the feature.

When SQL Server 2005 was ready for release, I still remember going to watch Donald Farmer talk about Integration Services, a radical change from the way that Data Transformation Services used to work. It was quite an eye opening session for me.

Early in the time when I was working with DevOps and databases, I watched a talk on how you might apply some of the techniques with Reporting Services to implement CI and ensure your report changes would actually work correctly. It was a hack, but I think that a number of the technologies that Microsoft has added to SQL Server aren't designed with version control and automated code review, which is a shame. However, that's one of the great things about Summits. You can learn how someone else solved a problem.

There are many other memories from the event where someone taught me a bit more about SQL Server. Being in the same place as so many smart, talented, inspiring data professionals was magical. That was one of the big reasons that my boss wanted to see the conference continue. Nowhere else in the world brings so many people together.

You can still register for the event next week. It's virtual this year, and completely free. No cost, and even if you get busy next week with work, you have access to the content after the conference, so register today. It's a few minutes, and you'll get the chance to learn from some amazing speakers.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

How to Recover a Corrupted Azure Data Factory Integration Runtime

diponkar.paul from SQLServerCentral

I would like to share my recent experience with Azure Data Factory (ADF) where AutoResolveIntegrationRuntime become corrupted and how did I recover it. I still don't know how the Integration Runtime (IR) was corrupted. However, if it happens, then this article will help you to solve the issue. Problem In general, the ADF AutoResolveIntegrationRuntime should […]

SQLServerCentral Article

CData AWS Glue Connector for Salesforce Deployment Guide

JerodJ from SQLServerCentral

AWS Glue is an ETL service from Amazon that enables you to prepare and load your data for storage and analytics. With Glue Studio, you can create no-code and low-code ETL jobs that work with data through CData Glue Connectors. In this article, we walk through configuring the CData Glue Connector for Salesforce and creating and […]

External Article

Scripting with Flyway Teams and PowerShell

Additional Articles from Redgate

During the development cycle, the mechanics of reliable delivery must not be allowed to dominate the design work. With script callbacks in Flyway Teams, many of the development tasks required during a database migration can happen automatically, producing reports, build scripts, code reviews, or documentation.

External Article

Cosmos DB Data Migration Between Containers using Databricks and PySpark

Additional Articles from MSSQLTips.com

In this article learn how to use PySpark scripts in Azure Databricks service to copy data between Cosmos DB containers.

Blog Post

From the SQL Server Central Blogs - The DBA as a helpdesk.

Kenneth.Fisher from SQLStudies

Every one and again you will see people asking What skill do you think is the most important for your ... Continue reading

Blog Post

From the SQL Server Central Blogs - TSQL-Tuesday 143: Short Code Examples

Diligentdba 46159 from Mala's Data Blog

I decided to resume tech blogging after a long break and this tsql-tuesday came in handy. This month’s blog part is hosted by John McCormack (B|T). He would like...

 

 Question of the Day

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

 

The Tail-Log Backup

What is contained in a tail-log backup?

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)

Protocol Order

If I want to change the order for client protocols to be tried for OLEDB and ODBC connections to SQL Server, what should I do?

Answer: Use the SQL Server Configuration Manager, SQL Native Client Configuration and open the Client Protocols properties

Explanation: The order of protocols tried by the client is controled with the SQL Serer Configuration Manager. The properties for the Client Protocols allow you to move them up or down. Ref: Client Protocols - https://docs.microsoft.com/en-us/sql/tools/configuration-manager/client-protocols-properties-order-tab?view=sql-server-ver15

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
java.sql.SQLException: Cannot create PoolableConnectionFactory - Application team get this error once application server undergoes reboot and this gets fixed when they do application cache load. Any ideas on this error.   java.sql.SQLException: Cannot create PoolableConnectionFactory The TCP/IP connection to the host  has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on […]
Join Only Option - Always On - Hi all Hopefully a fairly simple question to start things off after a long time absence I have a requirement to add another node to a current Always On system but the change window to do the work is short so I was thinking to save time I could manually restore the databases to […]
SQL Server 2016 - Administration
Intermittent sqlmail success - troubleshooting - Microsoft SQL Server 2016 (SP2-GDR) (KB4583460) - 13.0.5103.6 (X64) SQLMail Account configured with SSL checked and Basic Authentication account to smtp.office365.com Suddenly last week emails stopped working. First we thought it was TLS version configuration issue but after I set it up as a scheduled task running every minute I realized the email works SOMETIMES. […]
SQL Server 2016 - Development and T-SQL
Execute SQL Task error (SSIS) - I am getting this for a simple SQL statement: [Execute SQL Task] Error: Executing the query "" failed with the following error: "". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. update payments1 set [LineItem Amount] = replace([LineItem Amount],'$(','-') It does not […]
Restart SSA in a job? - Hi, I have a job that rebuilds indexes after a refresh of a replicated report DB. The issue is sometime I need to restart the SQL Server Agent to get it to start. Is there a command I can use to first restart it?   Thanks  
T-SQL help - I need help to write the T-SQL with scenario that if room got multiple room_cd and flagged with M and F then room_type will be flagged with majority of M or F like in 106, with room 1 got 1 to 3 room_cd and flagged with both M and F , but there are 2 […]
SQL 2012 - General
what this constrain meaning ? - I work on sql server 2012 i see constrain but i don't know what is meaning ALTER TABLE [Parts].[TradeCodes] ADD CONSTRAINT [UC_PartCode] UNIQUE NONCLUSTERED ( [PartID] ASC, [CodeTypeID] ASC, [PartLevel] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] […]
How to get feature key and feature value separated $ based on part id ? - I work on sql server 2012 i need to get featurekey and feature value separated $ Based on partid but i don't know how o do that by select sql query ? expected result as below   sample data create table #PartsFeature ( PartId int, Featurekey nvarchar(200), FeatureValue nvarchar(200), ) insert into #PartsFeature(PartId,Featurekey,FeatureValue) values (1550,'Botato','Yellow'), […]
SQL Server 2012 - T-SQL
Update table FirstName & LastName from Email addresses - I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field is already populated and follows a 100% consistent format e.g.: John.Dunne@MallWins.com, Lisa.Franklin@MallWins.com, Mary.Renaldo@MallWins.com, etc. I need to write an update query that will populate the FirstName and the LastName as one batch. I tried this to do just the FirstName and it gives […]
SQL Server 2019 - Administration
SQL Instance Aliases - Urgent assistance needed please - I have a migration problem. I cannot get my SQL Server instance aliases to work remotely. I've set up aliases before, and I've double-checked everything. The assigned ports are open, the protocol has been updated with the correct port, the aliases are set up in both spots on the config manager, browser is running, TCP […]
Error connecting using AlwaysON Listener - Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I added a Listener. Though no issues during the creation of the Listener , the connection to the instance using the Listener is not possible. Just can't get through. Wondering if it has to do with the Name Resolution , or it […]
Setting Up SQL Server 2019 for Optimal Performance - Hi I have a very large database (600GB) that I am looking at creating.  I will be running finance data analytic algorithms.  I am considering AI algorithms too as the second project once the main one (data analytics) is completed.  The AI will also be finance related.  I have not decided if I should go […]
SQL Server 2019 - Development
OK, I still think like a programmer -- is there a better way to do this? - My SQL tools tell me this invokes an inefficient step with an index scan.  I am treating this as a learning exercise since it's not really a problem, but I have code written by others (vendors) that I see this a lot and I'd like to be able to suggest fixes.  The query plan is […]
From the sys.sql_modules (linked.db.schema.vw_xxx) seperate column - Hi All, Im working an a issue and have some thinks I would like to fix it. At moment I need the definition of a all views, im jusing the follwoing query to find the definition (SYNTAX): SELECT definition, uses_ansi_nulls, uses_quoted_identifier, is_schema_bound FROM sys.sql_modules WHERE object_id = object_id( 'view' ); All the views is a […]
Analysis Services
SSAS partitions delete - .prt files not deleting - I have an unusual problem with an existing cube. When I delete a partition using SSMS or xmla the partition deletes from the cube successfully in SSMS. However, the physical files are not deleting from the server. Does anyone know why this is happening and how to correct it? thanks Jason  
 

 

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

 

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