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

Upgrading Your OS

I loved Windows 7. I haven't felt that way about many of the Windows systems. I tolerated 3.1, preferring DOS and Solaris at the time. Windows 95 was great, with me skipping Windows 98 after installing it on a few PCs at work. I thought Windows 2000 was OK, and did really like XP. I avoided Vista, running XP until I got a beta of Win 7. Then I thought Microsoft had made a great move, slimming down the OS and making it faster on the same hardware.

I skipped Windows 8 and moved to Windows 10, so I guess I like every other version of Windows. That makes sense. I've often felt every other version of SQL Server was really good, with some slim, not quite sure I like this, not quite sure this is worth the money, in-between versions. That might be changing as I liked SQL Server 2016, 2017, and 2019 is looking good.

I ran across an article on the move to Windows 10, which Microsoft has been pushing and which as proceeded very well. Many people upgraded, especially with the free offer to upgrade. However, the pace of change has leveled off, with Windows 10 at 44% recently and Windows 7 at nearly 37%. The disconcerting issue is that the latter number has barely changed from the end of 2018. With Windows 7 expected to EOL in Jan of 2020, Microsoft is trying to push people forward.

There are all sorts of reasons people are loathe to update their OS. Compatability issues, the comfortable feeling of knowing how a system works, and certainly resource concerns. I wish security was a higher level of concern for more people. When Win7 EOLs, enterprises can pay $200/yr/machine to get patches, but there is no option for Home users. I think this is a little short sighted as many Home users might not see value in upgrading, but they (and the rest of us) need secure machines on the Internet. Why wouldn't a $50/yr charge for security patches make sense?

Modern hardware is powerful and lasts longer, so I could understand an individual that started running the OS in 2011 not seeing a need to change. They are happy with a PC that runs email, browses the web, plays solitaire, and manages money. Do these people need to upgrade to Win 10? I don't know that they do, and the vast majority of the world are consumers, not creators, so the much of the work done in Win10 isn't useful for them.

There isn't a right answer here, and certainly there are security concerns from an older OS, but at some point the OS and hardware will be good enough for most people to stick around a long time. Microsoft ought to be prepared in those cases to enable very long term support, perhaps with some yearly charge, to provide patches to the OS. I don't know if Win7 is the place to do that, but I do think that Win10 ought to be around for a long, long time with paid support.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

The Subtle Differences Between COALESCE and ISNULL

omu from SQLServerCentral

See how ISNULL and COALESCE behave in different situations and ensure you know which one to pick when.

External Article

Using the Default Trace in SQL Server

Additional Articles from MSSQLTips.com

I have heard of the default trace in SQL Server. I know it’s on by default, but I don’t know how to use it. What can I do with the default trace?

Technical Article

The State of the Database Landscape in 2025: Insights and trends

Steve Jones - SSC Editor from SQLServerCentral

How are you navigating the database landscape? Our latest report sheds light on the current state of database management and offers valuable insights into how organizations can navigate and simplify the growing complexities of the database landscape.

Blog Post

From the SQL Server Central Blogs - The Book of Redgate–Being Reasonable

Steve Jones - SSC Editor from The Voice of the DBA

As a part of the Book of Redgate, we have a series of (red, of course) pages with the title “What we believe”. These are our values, as set...

Blog Post

From the SQL Server Central Blogs - Improving Our Conversations

K. Brian Kelley from Databases – Infrastructure – Security

If we aren't having the same conversation, we aren't going to be heard. That's what Charles Duhigg, author of The Power of Habit, covered in the following TED talk:

Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

Site Owners from SQLServerCentral

Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. 

 

 Question of the Day

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

 

SQL Server Collations

At what levels can we set the collation in SQL Server 2022?

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)

Importing Flat Files

What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?

Answer: any delimited format and fixed width files

Explanation: The documentation notes that this works with CSV and fixed width text files (PR submitted to fix this), but the wizard works with the PROSE  framework and can detect pipe or other delimeters. Ref:

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 - Administration
Changing Machine Type - Hi, presently my azure server running under Standard_D64ds_v4 .i am planning to upgrade the server . can you please help me what is next configuration .
SQL Server 2016 - Development and T-SQL
Need help accessing and loading a temp table - I'm trying to dynamically create a temp table, basing the column names on another table.  It appears to be working (???) but I can't select or insert any data into the table that was just built? Here is a test of what I'm trying to do. IF OBJECT_ID('tempdb..#source_table', 'U') IS NOT NULL DROP TABLE #source_table; […]
How to get result from deleted row - Hi Guys I have a store proc that delete a row from a and I would like to get the result of the deleted row whether be =1 or True in order to execute another store proc. Could this be possible? ---- I am aware this code won't work I am trying to explain what […]
Joining against min date only - This is one of those things very hard (for me)to explain in words. See image below, the requirement is assign all of the sales with Reqdate prior to the "Best Before Date"  but ONLY the earliest "Best Before Date." I am trying to do this only with T-SQL.  My full scenario is of course more […]
Union where it matches against only one shared column - Hi folks I have two tables, both with a NAME, START and END fields I'd like to list all of the rows from Table A, and then only the rows from Table B where only the START does not exist in Table A.  The NAMES in Table B will ALWAYS be different from those in […]
SQL Server 2019 - Administration
Running DML on a Primary AG Instance - Kind of a DML question - but specific to an AG instance running on SQL Server 2019 - so starting here. We have 3 AGs and 3 SQL Server 2019 Instances. I cannot so easily remember the AG listener names so I often use the Primary Instance name instead - thinking that other than in […]
SQL Server 2019 - Development
Replace calculation in cursor with set based logic - Hello and thanks if you can help. The calculation in the cursor is correct. Alas my attempt at doing the calculation in a select statement is not.  SQL Server 2019 DROP TABLE IF EXISTS #Test CREATE TABLE #Test (PricingDate DATE NOT NULL,Price DECIMAL (5,2) NOT NULL,Factor DECIMAL (9,7) NULL) INSERT INTO #Test VALUES ('2025-04-01',11.94,NULL) INSERT […]
t-SQL help.. - I have the following...anyone can point me the right direction to rewrite this code?       IF Object_id('tempdb..#TMP1') IS NOT NULL DROP TABLE #TMP1 IF Object_id('tempdb..#TMP2') IS NOT NULL DROP TABLE #TMP2 SELECT * INTO #TMP1 FROM ( SELECT 1251470 XID,       1569175 TRX,       59164   CID UNION ALL SELECT 1251470,    […]
what etl tool are folks moving toward? - Hi as we replace on prem machines , sometimes not with vm's, what should we be thinking about for etl? from my little corner of the world where we use both talend and ssis, and where talend is getting costly, and where ssis is slowly being squeezed into a call from data factory to an […]
General
Count of Distinct Values - Hi If value is 21000030 it should return 4 not 5 . In first record 21000030 exists 2 times 21000032 then it should return 3 not 4. USE [Live] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[OCRD]( [CardCode] [nvarchar](15) NOT NULL, [Emp_1] [nvarchar](10) NULL, [Emp_2] [nvarchar](10) NULL, […]
SQL Server 2022 - Administration
Snapshot Replication: Pre-application script to check prerequisites - Is it possible to write a script that checks a subscriber's environment for prerequisites and prevents the application of the snapshot if those prerequisites are not met? I'm familiar with adding the (pre/post) scripts to the Publication, but not how I can force the job to fail before the snapshot gets applied.
install sql express - I yesterday dowload a sqlexpress and intalled on one of a testing database for one of my test applications. After Install I found i n sql server configuration manager there are two intances installed, one is called sqlexpress, one is called MSSQLServer. Both of them are sqlexpress Edition, I cannot remember how comes it installed […]
Sever Migration - Hi, one of my server configured with Standard_D64ds_v4 what is next level of version is it Standard_D98ds_v4 or Standard_D128ds_v4
SQL Server 2022 - Development
SSIS XML Source Columns Don't Match XML/XSD - In my SSIS package I have a Data Flow with a XML Source with the below XSD. The problem I have is when I try to do a Data Conversion and subsequently an OLE DB Destination, the columns available for PortfolioExport__PortfolioData__OfficeParks__OfficePark__Properties are Properties_Id and OfficePark_Id. What I need are the OfficePark.Id and the Properties.SourceId. I […]
Get days between 2 dates excluding weekends. - Hello all. Trying to measure the time in days between to dates excluding weekends. Currently I have this but  I am nit sure how to use the generate_series command in this code so there are errors. Select fsono, fcompany, forderdate, confirmdate, confirmed--, (select Count(*) as daysopen from generate_series(a.confirmdate, a.forderdate -interval '1 day' interval '1 day') […]
 

 

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

 

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