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

Managing SQL Server containers using Docker SDK for Python - Part 1

carlos10robles from SQLServerCentral

There are multiple ways to interact with the Docke...

How to Copy a Table in SQL Server to Another Database

Additional Articles from MSSQLTips.com

Learn about options to copy a table from one SQL Server database to another including Linked Servers, PowerShell, Integration Services, backup and restore along with the associated performance metrics and completion time.

From the SQL Server Central Blogs - What is a distributed transaction?

Kenneth.Fisher from SQLStudies

A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example ... Continue reading

From the SQL Server Central Blogs - 12 Ways To Rewrite SQL Queries for Better Performance

Bert Wagner from Bert Wagner

Watch this week’s video on YouTube. Thanks to you, we just crossed the 2k subscriber mark! Over the past several week’s I’ve been exploring ways to rewrite queries to improve...

 

 Question of the Day

Today's question (by mkdm):

 

Service Broker Undelivered Messages

Service Broker is enabled on my database, but messages are not arriving in my TargetQueue. I have confirmed that the initiator and target services have been configured correctly, and that my queues are enabled. Where could I look for the undelivered messages?

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

 

Redgate University
 

 

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

No More Denial

I decide to prevent the Sales role from accessing the dbo.SalesArchive table. I run this:

DENY SELECT ON dbo.SalesArchive TO Sales

Later I realize that this is breaking our application and need to remove the deny. What code should I run?

Answer: REVOKE SELECT ON dbo.SalesArchive FROM Sales

Explanation: The DENY is a permission added to the user. The REVOKE statement on that permission will remove this, the same as it does for a GRANT. Ref: REVOKE - https://docs.microsoft.com/en-us/sql/t-sql/statements/revoke-transact-sql?view=sql-server-2017

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 - Development
Import XML into a sql table - Hey guys! How do I upload a file with the structure as in the picture? The XML  has a structure like this ??? ???????????555.00.111-33?? "????????? ???????????????? ??????"80000055639-182018-12-23333-33-33/12018-12-23586?????9,10x7,73x4005?110?? 001.392-200617333-33-33/182234-18?? 95 166-9832407.00.01378??????? ?????? ? ??????? ??????? ???????? ??????? […]
Count of entries & grouped by month - extracted from a date - hiya amazing people I need some help with the query below. I need to see the breakdown of entries by month but the [RecvdDate] has a datatype of (varchar,null) & the date appears something like 2019-05-31 for example. What should I add in my SELECT statement to get the monthly breakdown? SELECT COUNT(ID) AS 'Total […]
SQL Server 2016 - Administration
Audit login's permission change - Is there a way to keep track of who is changing permission for one of the login our web is using? That login has owner rights and time to time, we run into issues where that login no longer has owner rights. But who is causing it? I created a user, granted that user with […]
Database is in emergency mode or is damaged and must be restarted - When connecting to SSMS, the database shows online and I am able to run queries against it. But, while trying to backup the database it is giving me this error message "Could not run BEGIN TRANSACTION in database because the database is in emergency mode or is damaged and must be restarted".   Thanks.  
Disable Read-intent mode onlyavaibility Group - Hello everyone I have an Alwayson cluster in Avaibility Group AG mode the secondary replica is configured in "Read-intent only" mode I configured read request routing to the second node to ease the load on the primary node Currently following a license problem it asked me to make the second passive node not accessible in […]
Administration - SQL Server 2014
[HELP] I did a DROP and CREATE blank records on a production database  - Hi there, My name is Kay and I work as a data analyst in Indonesia. I made a terrible mistake when I (intent to) copy the query from an old database to the live production database. Instead of copying the query, I was unaware that I did not remove the check-mark in  the checkbox on […]
Restore SSIS without backup and only from MDF and LDF files - I am needing to restore / rebuild an SSIS Catalog on a new SQL Server. Problem is, I don't have a backup and only have the MDF and LDF file. I am unfamiliar with SSIS so I have tried attaching the DB but it doesn't re-create the catalog and the jobs. I know the password […]
Development - SQL Server 2014
Exclude records with column value starting with '836' - Hi All, So my latest issue is I need to be able to exclude records with claim numbers that start with '836'. This seems pretty straight forward, but nothing I've tried seems to be working, as I'm still getting back claim numbers starting with '836'. I've tried using NOT LIKE and NOT IN. Could I […]
SQL Server 2012 - T-SQL
Need some help with inserting text - Hi, I am in a scenario where I need to manipulate some text. For example: p11034  - If the first letter is 'p' and the count of characters to the right of the 'p' is 5, then insert 4 zeros between the p and 11034. The end result is 'P000011034' Any assistance would be great. […]
SQL Server 2008 - General
View crashes SQL Studio - Hi all, I have a query which is working fine.  However, when I attempt to put it into a view SQL always crashes. There is no error message when I run the view other than the crash window:  SSMS - SQL Server Management has stopped working. However, if I try save the view, the error […]
SQL Azure - Administration
Backup retention upto 10 years in PAAS - Hi Experts, Do I have to pay additional amount to retain my PAAS SQL database backup for 10 years in Azure?   Thanks Brijesh
Azure elastic database jobs - Hi, I am trying to use this approach to automate some tasks: https://docs.microsoft.com/en-us/azure/sql-database/elastic-jobs-tsql It mentions: "The credential needs appropriate permissions, on the databases specified by the target group, to successfully execute the script. " CREATE MASTER KEY ENCRYPTION BY PASSWORD='password'; CREATE DATABASE SCOPED CREDENTIAL myjobcred WITH IDENTITY = 'jobcred', SECRET = 'password'; GO CREATE DATABASE SCOPED […]
SSRS 2016
Different extensions for view report and generate subscription - Hi all, i need to hide for all reports MHTML extension (I know how to do it: but i need this extension in subscription, and after above chcange i dont see it Any ideas?    
Integration Services
Extract dates from the file name in SSIS - Hi, I have a requirement to extract the 2 dates from the file name in SSIS (2010) as a derived column in the data flow task. The filename is as follows: Abdr_FC_BHYUK_Weekly_Physical_SAVERSHOP_IBLUPGE_All Links Roll up_050519_110519.xlsx Can someone please help on this ? Thanks.  
SQLServerCentral.com Website Issues
Keep getting Subscribed to Topics I've Unsubscribed from - This has happened to me a couple times with long running topics like Today's Random Word and Are the posted questions getting?  Despite Unsubscribing from email notifications they'll randomly just turn back on which is somewhat annoying.
 

 

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

 

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