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

Daily Coping Tip

Plan a fun or exciting activity for the weekend

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.

The Future of the Internet and Data

I can still remember my early days connecting to the Internet and wandering about. In those days I used gopher to browse around, read through the usenet groups, and got text email through a text client. We had to learn to type well to keep our sanity in the early 90s. I still remember when we first saw browsers, and my early excitement with Netscape Navigator, able to see text and pictures without manually downloading images to my PC.

The online experience has changed dramatically since then, with complex web pages that allow you to enjoy, work, and even try out an OS all inside a browser on the web. Today's Internet allows us to do so many things that it's no wonder the transition to working at home went quickly and smoothly for many of us. I'm amazed these days how many places I can sign in for work with a single sign on, accomplishing things that would have required a VPN and multiple user/password combinations in the past.

If I imagine the future of the Internet, I tend to think of a richer experience, though I struggle to think of how things can be even richer than they are now. I would hope that we don't go down a route of more ads and interruptions, but that might be where things go. There's an examination of how things might change in this article, talking about a dystopian view.

If I enter "sqlservercentral.com", I see a similar view of the site today, though blurred. Instead I get a pop-up that the business no longer exists, another one noting "access denied" beyond the firewall, and then a security warning the site is suspended pending legal proceedings. None of those things would be something I imagine, but all could be possible. I wouldn't be surprised if we started to see some "controls" added to browsers that might be enforced based on government rulings.

The wayforward site in the article is pretty simple, with a few different types of pop ups that speculate about potential restrictions. While I do think some of these might come about, I doubt that a wholesale, 1984-like implementation of the web will take place. I certainly could see some sites "suspended" pending legal review, and I'd welcome that. There are a lot of scams taking place on the Internet, and I do think Facebook/Google/etc. are not doing much to curb their reach.

Rather than limitations based on my views, or even because of censorship, I'd expect to see more paywalls, perhaps with micropayments more easily integrated. Want to see an article, it's US$0.25 each time, or a pack of 10 articles for $1, or a monthly subscription for $5, $10, or something. I certainly expect that like streaming TV/movies, we'll start to see new types of subscriptions that seek to fund more content. I do think places like SQL Server Central, Stack Overflow, and many other individual sites will continue to exist as free resources as well.

Most of us that are working as data professionals recognize the value of data. Many companies do as well, and I expect they will continue to try and find ways to turn a profit on their data. I just hope that we find ways to balance freedom and privacy with the desire for profit.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events

Johan Bijnens from SQLServerCentral

Intro In 2008 I wrote an article called “Scope: The drastic caveat with Logon Triggers.” Ever since, we have been using Event Notifications to capture logins for our SQL Server instances. Issues were only very rare, usually on servers that had an extreme load of many connections. In such a case, we stopped this continuous monitoring and […]

SQLServerCentral Article

Use the CData SSIS Components to Insert New or Update Existing Salesforce Records from SQL Server

JerodJ from SQLServerCentral

Easily push SQL Server data to Salesforce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce or update existing records with data from a SQL Server database. 

External Article

Cybersecurity threats

Additional Articles from SimpleTalk

Not a week goes by without news of a new cyberattack. In this article, Robert Sheldon explains the cybersecurity threats in today’s world.

Blog Post

From the SQL Server Central Blogs - Group By Starting Characters

Kevin3NF from Dallas DBAs

I was chatting with Jeff (b|t) on my team yesterday and the context escapes me but I had this thought: “Can you Group By the beginning characters, or a...

From the SQL Server Central Blogs - External Temp Tables Preventing Plan Reuse in Stored Procedures

david.fowler 42596 from SQL Undercover

Here’s an interesting issue that recently came up. We were seeing very high compilations and recompilations on a server to the point that it started causing us some very...

 

 Question of the Day

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

 

SSIS Catalog Object Names

I want to rename a project in my SSIS Catalog. Which of these is a valid name? (ignore the quotes)

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)

Operator Precedence

Which of these has the high precedence among T-SQL operators?

Answer: ~

Explanation: The binary not, ~, has the highest precedence of all operators. Ref: Operator Precedence - https://docs.microsoft.com/en-us/sql/t-sql/language-elements/operator-precedence-transact-sql?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
cannot generate SSPI context - We have one user who face this issue while connecting to SQL server ''Cannot generate SSPI context" (win authentication)  When i checked the user account the account looks good and there is no password issue. Same user is able to connect SQL using command prompt.  what could be the reason
Database Corruption - LOB - Hello, I have recently inherited a SQL 2012 database (no backups available), running in SQL 2005 compatibility mode with Filestream enabled.  The first error, I received was: Error: 3043, Severity: 16, State: 1. BACKUP 'mcs_mia' detected an error on page (3:1484827) in file 'e:\BLOB\mcs_mia.ndf'. When I ran DBCC check, I received several of these errors: […]
SQL Server 2017 - Development
arabic digits stored in varchar column with Arabic_* collation - Hello, FYI Database collation is Arabic_100_CS_AS Why do Arabic characters in a varchar column (collated as Arabic_100_CS_AS) get handled correctly (inserted and displayed) while digits get transformed into their Latin equivalent? We know that NVARCHAR is able to handle this correctly but we still want to know what goes wrong with our varchar column in […]
SQL Server 2016 - Administration
Partitioning and Indexes needed on huge table - I have a table with 24,000,000 records and 140 fields. The records can be divided into 3 years for a partitioning. I'm still quite new to doing indexes and partitioning and any tips would help. I'm thinking of course I need to do this at night when no one is on. Also I'm using SQL […]
Databases status are recovery pending - Hi All , After SQL restart most of databases turned to be Recovery pending . The restart happened at primary server and automatic fail over happened. moreover the listeners are gone. i couldn’t remove db from AG either . Couldnt bring database online.. When i right click , no option to add listener . Appreciate […]
Remove database from Distributed Availability Group replica AG ONLY! - Hi, all! I have an existing always on availability group on-prem and last week created a second one in AWS.  After that, I created a distributed availability group with on-prem as primary and AWS as the replica AG. Being new to SQL Server, I configured automatic seeding without thinking for a second that it would […]
Finding all logins that can alter DDL - Hello experts, Is there a ready-made query out there that I could run on a server to list all the logins that have the ability to alter DDL in any of the databases? I know some of this can be retrieved by finding members of db_ddladmin, but there could also be individually granted permissions for […]
SQL Server 2016 - Development and T-SQL
Replace Numbers - My goal is to replace the numbers 1-9 in a column with a different number. For this example the numbers would change to 1=7 2=3 3=9 4=1 5=4 6=2 7=5 8=6 9=8 I tried using the replace function shown below but my problem is a value keeps getting changed as it progresses through each replace. […]
Development - SQL Server 2014
How to redesign a query - Hi Result is determined by the calculated Usage, With the below query, the result for the last output row is 0 because usage is based on the previous date and value (using LAG). How can I rewrite this so that the calculated usage is based on the previous date and value where the result is […]
SQL 2012 - General
SQL Server SP updates - Hello, I have a SQL server I'm managing that needs to be updated from SQL server 2012 to SQL server 2012 SP3. I inherited this box so no updates have been applied to it in regards to CUs and SPs. Is installing SP3 right off the bat a bad idea, should I install SP1/SP2 first? […]
SQL Server 2019 - Administration
Cannot connect to Existing Replica - Dear Friends, I setup a test run case on 2-Node AlwaysON , on developer edition.The issue is I want to add another replica to this but the connection doesn't happen in the first page of the Add Replica wizard (please refer attached file for the error). I can though connect to both the instances well […]
SQL Server 2019 - Development
How do I join two temporary tables using MySQL? - Hi all, I'm still pretty new to SQL and could use some help getting this query to work. The ultimate goal is to join two temporary tables. In the first temporary table, I pulled all of the distinct rows from a table called 'Table A' and used a JOIN clause to combine it with a […]
SQL Server 2008 - General
Insert records with a where - I want to insert record job allocations only for selected jobs I know the following code won't work form the WHERE part but this gives you an idea of what I want achieve.  TIA. INSERT INTO dbo.WipJobAllLab(W.Job, Operation, WorkCentre, IExpUnitRunTim, Milestone, IWcRateInd) VALUES(W.Job, 1, '001', 0.01, 'N', 1) ... "WHERE SELECT W.Job FROM dbo.WipMaster W […]
Insert records with a where - I want to insert record job allocations only for selected jobs I know the following code won't work form the WHERE part but this gives you an idea of what I want achieve.  TIA. INSERT INTO dbo.WipJobAllLab(W.Job, Operation, WorkCentre, IExpUnitRunTim, Milestone, IWcRateInd) VALUES(W.Job, 1, '001', 0.01, 'N', 1) ... "WHERE SELECT W.Job FROM dbo.WipMaster W […]
SQL Azure - Administration
Row Level Security - Dear Experts, How can we implement row-level security on Azure when the application is hitting the database using a managed identity. How the same can be implemented on On-prem when an application uses SQL credentials or a windows account? Currently, the application hits the DB using a managed identity and application authentication is based on […]
 

 

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

 

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