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

Daily Coping Tip

Ask yourself: What’s the best thing that can happen?

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.

Something Old Something New

My neighbor had a 1978 Ford Bronco when I was growing up. He drove his kids and I around to various events, and I loved that car. The look, the removable back, the spacious interior. It was a car I've always wanted to own. As I've gotten older, however, the rough ride and lack of modern amenities have made me rethink buying an older version. I've become spoiled in my older age

Ford just announced a modern version of the Bronco, bringing back the iconic truck after over two decades. What is interesting to me is that they appear to be trying to take a page from software design and customized websites by allowing lots of custom options. It appears in this look at the truck that much of the truck body can be removed and replaced with custom sections. I'm sure plenty of third party companies will offer new colors, shapes, lights, and even accessories that might truly make this car your own.

Of course, car manufacturers want to make money, too. There are some mechanical differences with engines, transmissions, and suspension, but also a variety of settings for the drivetrain. However, different trim levels have different numbers of drivetrain settings. I wonder if there is a difference in the models or this is a software limitation (with a different physical switch). I wouldn't be surprised if this were the case.

I had hoped years ago that we would start seeing more customization in cars with manufacturers building a flat chassis and custom bodies, having features into software, providing interfaces, allowing for more plugins from their own and partner suppliers. Instead, it seems like we've gotten more and more proprietary designs, trying to lock in users rather than selling the flexibility of design. I guess that's the way of capitalism, doing what's best for the company rather than creating an ecosystem that might excite the consumer.

While I know modern vehicles are built for efficiency and airflow, I think many of them start to look alike. I would hate to see every car look the same, as they have in some movies. I miss the different designs and details from the past. I would like to think that at some point we'll see modern electric engines, controls, and features available in customized, 3D printed bodies and better software interfaces that allow us to bring back the look of the past with the best of today.

Steve Jones - SSC Editor

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

 
  Featured Contents

Primary keys for an OLTP database

Evgeny Garaev from SQLServerCentral.com

OLTP database performance with different clustered indexes.

SQL Server Backup Monitoring with PowerShell

Additional Articles from MSSQLTips.com

In this part of the series we look at how to use the PowerShell monitoring scripts to collect backup information from your monitored instances.

From the SQL Server Central Blogs - How to Spell and Capitalize tempdb for SQL Server

Kendra.Little from SQLServerCentral

No matter what I write in this post, some of y'all are going to tell me I'm wrong. That's inevitable, because I'm writing about tempdb: a database so complex...

From the SQL Server Central Blogs - T-SQL Tuesday #128–Learning From Others

Steve Jones - SSC Editor from The Voice of the DBA

It’s the second Tuesday of the month and time for T-SQL Tuesday again. This month I’m grateful that Kerry Tyler is hosting. I had the pleasure of sitting with...

 

  Question of the Day

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

 

BDC Containers

What types of containers are supported in Big Data Clusters?

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 Eager Writer

What does the eager writer process do in SQL Server?

Answer: Thie process writes dirty pages associated with minimally logged operations.

Explanation: The eager write process writes dirty data pages associated with minimally logged operations such as bulk insert and select into. This process allows creating and writing new pages to take place in parallel. That is, the calling operation does not have to wait until the entire operation finishes before writing the pages to disk. Ref: Writing Pages - https://docs.microsoft.com/en-us/sql/relational-databases/writing-pages?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
SQL2017 CU21 CHECKDB WITH EXTENDED_LOGICAL_CHECKS - I have a problem running CHECKDB WITH EXTENDED_LOGICAL_CHECKS using dynamic SQL since upgrading SQL2017 standard edition to CU21. The problem occurs with msdb on all seven instances and on two out of 63 user databases. The problem does not occur with CU20. If I run the following static SQL from SSMS: DBCC CHECKDB ([msdb]) WITH […]
SQL Server 2017 - Development
SQL Query Help - CHARINDEX - Need query help. create table #tblTest1 (ID int, SName varchar(50), Type varchar(10)) INSERT INTO #tblTest1 values (1,'abc/efg','OS') INSERT INTO #tblTest1 values (2,'xyz/tgf','OS') INSERT INTO #tblTest1 values (2,'tgf/xxx','OS') INSERT INTO #tblTest1 values (3,'ccc/ppp','OS') INSERT INTO #tblTest1 values (4,'ddd/tqm','OS') INSERT INTO #tblTest1 values (5,'mpg/eee','OS') create table #tblTest2 (SName varchar(50)) INSERT INTO #tblTest2 values ('efg') INSERT INTO #tblTest2 […]
Out of memory error when I try to export an SSIS project in SSMS to an ispac - Hey guys, when I go into ssms and open the integration Services Catalog folder, navigate to a project, right click it and left click on export it runs for some time but then I get an error saying out of memory. How can I correct this?
SQL Server 2016 - Administration
SCOM alert offline/recovery pending/suspect... but DBs seems fine - Hello experts, We are using SCOM to monitor SQL Server AOAG, and I am having trouble resolving this alert: Database is in offline/recovery pending/suspect/emergency state I use the alert details to check the status of the databases on each of the AOAG replicas, as well as the Always On High Availability Dashboard. The dashboard is […]
What Should be...? - Dear friends, Using Always On in our corporate site, we have 3 nodes deployed, our main database backup is based on images of that virtual  machines, but constantly I have databases requesting transaction log backups, what role should have a normal backup of transaction log files vs virtual machines images backup, our management team has […]
Cannot connect after Availability Group automatic failover - Hi We have a SQL Server setup with Availaibility Groups, in the cluster we have four nodes, two in one datacenter and two in another datacenter. There are four AGs on these cluster nodes, each primarially on one of the four nodes, with one other node in the same datacenter for syncronous HA and the […]
SQL Server 2016 - Development and T-SQL
Calculate aging between two date fields excluding weekends and holidays in SQL - Hi Friends, I have a table which has DateTime, IsWeekend, IsHoliday fields in my DB. I have another table which has the list of tickets logged with columns like Select TicketID, Status,CreatedDate,ResolvedDate, etc., From Table_A How can I calculate the aging of these tickets excluding the weekends and holidays. I have read so many posts […]
Is it possible to optimize this SQL to get rid of 2 highlighted subqueries? - Is it possible to optimize this statement to get rid of the case named [aging]? specifically, the two highlighted statements that cause 90% of all waits in the entire select statement. 4 attachments: entire SP, the CULPRIT SQL, and the full Stored Proc where it is called +screenshot that shows fully confirmed problem statements that […]
Is it possible to optimize this SQL to get rid of 2 highlighted subqueries? - Is it possible to optimize this statement to get rid of the case named [aging]? specifically, the two highlighted statements that cause 90% of all waits in the entire select statement. 4 attachments: entire SP, the CULPRIT SQL, and the full Stored Proc where it is called +screenshot that shows fully confirmed problem statements that […]
SQL Server 2012 - T-SQL
Need help formatting BCP output - Hello, I have a bcp script that generates stored procedure code output as shown below. bcp "select RTRIM(LTRIM(c.text)) FROM sys.objects AS o INNER JOIN sys.syscomments AS c ON o.object_id = c.id WHERE o.type = 'P' AND o.name = 'sp_ic9av0_dx_length'" queryout "\\dbserver1\j$\Backup\NG Sps\sp_ic9av0_dx_length.sql" -t -c -r "\t" -SServer1 -T -dMyDb There is a formatting issue in […]
'Too many parameters..' error - Hi Friends, I am a Database-Design architect trying to write some stored procedures. I created an SP with one IN parameter and many OUT parameters....I called it from the below calling-code carefully having carefully declared the parameters but still I get this error.. Will be very thankful if somebody can point to the issue and […]
SQL Server 2019 - Development
SQL Collation to match IBMi - In SQL, these items sort this way INV175 INV190 INVB03 INVB04 On the IBM iSeries, they sort. INVB03 INVB04 INV175 INV190 Is there a SQL Collation I can use in a query to make a SQL Select ORDER BY match the IBM Sort ?   EDIT: I found this in an old post, which seems […]
Understanding the Expression Service - avoiding expression limits - Hi Sql Experts, At my company, we have authored a piece of software that allows users to examine data by viewing it in a grid, and authoring expressions against that data. Our software ultimately distills those expressions authored in the application to sql expressions used in a SELECT. These expressions are all linear (no aggregations/grouping), […]
SSDT
Use a variable for a file connection manager - How do I tell a file connection manager that the file in question is not a static name and will change daily? I have a string variable that builds the daily expected filename but can't see how to use this. SSDT wants me to enter the name of an existing file... which I can do […]
SQLServerCentral.com Website Issues
Ask SSC TLS Error - Posted also over on AskSSC but posting here in case people can't get to the site due to this. https://ask.sqlservercentral.com/questions/156338/tls10-tls-11-error-when-browsing-from-secured-hard.html   Getting an issue when browsing ASK from a CIS hardened desktop with the latest version of Edge or Chrome. This is due to Ask using TLS1.0 or TLS.1.1 which it will not support any […]
 

 

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

 

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