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

Daily Coping Tip

Make some tasty food for someone who will appreciate it

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's Important to Your Organization

I've had the chance to work in a number of organizations in my career. Every one of these places needed to run a network and software applications to support the business. Most of them also built some a portion of the software they used. No matter how much software they built, but there was always a need to manage a software lifecycle with new applications, patches, and the retirement of systems over time.

While every organization recognized the value of software, some saw this as an expense, like salaries or buildings. The funds needed were the "cost of doing business." In these organizations there was always a focus on controlling or reducing costs, doing what needed to be done, and being efficient with how computing was integrated into the business. These organizations seemed to be stodgy and traditional, with management focused more on the analog world than the digital one. Some were quite successful, which I often think is a combination of good management, good staff, and luck.

These days, I think that view that software is an expense is less and less successful in many organizations. Over time, this will see a deterioration in the success for those businesses. It might be a slow decline over decades, or a more rapid one in a few years. I truly believe in software eating the world, and every company needs to be a technology company. They don't all need to build software, but they do need to manage it, and more importantly, take advantage of software to better run their businesses.

We see this in all kinds of industries. Perhaps it's highly visible in the automotive industry, but in plenty of others, from finance to insurance to retail to manufacturing, the use of software as a strategic asset improves the competitiveness of business. Even in government, organizations are finding that making better use of software allows them to offer more services at a lower cost.

I wonder how many of you see your employers treating software as a strategic part of their business model. Do they aim to increase profits or become more efficient or even innovate in their industry with the power of modern computing? Or is it just a tool that they depend on, and consider the cost of doing business? If your group isn't seen as strategic, likely they don't value your work as highly, don't provide training, and don't create opportunity or innovation that ensures your work is interesting. If those are things that matter to you, perhaps it is time to look around for other employment.

Steve Jones - SSC Editor

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

 
 Featured Contents

Docker Desktop on Windows 10 for SQL Server : Step by Step

pauline.xiong from SQLServerCentral

This short article explains how to quickly run SQL Server in a Docker container, for both Windows and Linux.

How to query private blob storage with SQL and Azure Synapse

Additional Articles from SimpleTalk

Azure storage can be marked Private to control access. Dennes Torres explains how to query private blob storage with SQL and Azure Synapse.

Using Multiple Azure DevOps Organizations with SQL Source Control

Additional Articles from Redgate

Describing a database version control system using an Azure DevOps-hosted Team Foundation Version Control repo and SQL Source Control, and a workaround for authentication problems when connecting to multiple Azure DevOps organizations.

From the SQL Server Central Blogs - Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

gana20m from Ganapathi's MSSQLLover

New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

In this blog post, I covered how to simplify large SQL Server database migrations...

From the SQL Server Central Blogs - Estimating Nonclustered Index Size in SQL Server (Powershell)

sqlrider from Sqlrider - Speed enthusiast

I recently encountered a requirement to estimate the size of (a lot of) nonclustered indexes on some very large tables due to not having a test box to create...

 

 Question of the Day

Today's question (by Evgeny Garaev):

 

Zero or Hero?

What will be result of this query:
IF (1 <> 0)
BEGIN
DECLARE @NumOfHolidays INT;
SET @NumOfHolidays = 0;
END;

SELECT @NumOfHolidays;

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)

An anonymous lambda in python

In the Python REPL, I run this with these results:

>>> lambda y: y+5
 at 0x0000020DDC55F0D0>

How do I run this function?

Answer: _(5)

Explanation: The underscore in the REPL will execute the last expression evaluated. Ref: Anonymous Functions - https://realpython.com/python-lambda/#anonymous-functions

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
Flat file import - I am importing a flat file from a network share which is dropped there by an application and populating a table. Now there is an additional requirement from the application team to have these files perform updates to existing records. I'm thinking updates need to be scripted and run manually as a query rather than […]
Memory Optimized Tables, UDF and Cross DB access - Hi everyone. I have a database call DBMemOpt with a memory optimized table tTableMemOpt I create a table value function in DBMemOpt in this way: USE DBMemOpt GO CREATE OR ALTER FUNCTION [dbo].[fTest_MemOpt] (@param as int ) RETURNS @fooTable TABLE ( idintNOT NULL, foointNOT NULL ) AS BEGIN INSERT INTO @fooTable SELECT id, foo FROM […]
SQL Server 2016 - Administration
is Forced Parameterization usually more beneficial than less? - On a hybrid server, with ~70% OLTP vs 30% (somewhat heavy) DW workloads, with over 60% of all heaviest recompilations coming from AdHoc queries: We view the recompilation reasons via the Histogram (via the below XE Session) and querying it (also below)  that produces this result (this is for most recent 24 hrs). Should I […]
csv export has line returns from a column on one server not the over - Ok i have a test server and a production server. (I did not set up) . On the test server when I export the query results to a csv vile one of the column (workinst) has line returns so the sheet is messed up with line returns and the following columns are no longer on […]
How to get spid of jobs that are running along with job name - Hi, Can you please let me know how to get spid of jobs that are running along with job name Thanks
Administration - SQL Server 2014
Linked Server to MS Access Database - Hello all - I am hoping someone here can help shed some light on what I am seeing in my environment.  I have a SQL Server 2014 Standard (12.0.4100.1 (X64)) installation. On this server, I created a linked server to a Microsoft Access Database called Property, which lives on a separate windows file server.  The […]
Development - SQL Server 2014
SSRS + SSAS Issue -   Hi I installed analysis services/ reporting services on SQL 2014 server and then restored databases -report server and report server tempDB and also restored the analysis databases from SQL 2012 server. The issue I am now facing is while configuring SSRS reports and giving a connection string as below : Provider=SQLNCLI11.1;Data Source=xx;Integrated Security=SSPI;Initial Catalog=xx […]
SQL Server 2019 - Administration
Loop thru DIRs and COPY latest BAK file to our DR Dir - I need to LOOP thru our Ola Hallengren gen'd backup DIR's to identify the most current FULL backup file and COPY it to a D/R directory (our Server team will then copy the files in the D/R directory t tape and ship offsite). I only wnat the single, most current FULL backup file copied fro […]
removed - removed
new sql installation of developer edition errors - I am learning to work with SQL server 2019. During the installation I got some errors. TITLE: Microsoft SQL Server 2019 Setup ------------------------------ The following error has occurred: Cannot find the user 'DESKTOP-QGVGUB6\PdwComputeNodeAccess', because it does not exist or you do not have permission. Changed database context to 'DWConfiguration'. Script version: 107 Version_History table created. […]
Irritating bug in the 2019 SQL Installer - When installing SQL, be careful on the Server Configuration\Services Account page when you select the "Grant Perform Volume Maintenance Task..." option. Even if you have selected an Active directory account for the services to run under, the right is actually assigned the SQL Server Managed Account NT SERVICE\MSSQLSERVER and NOT to the account you have […]
General
Update table from other tables - Hi, Basically i have 2 tables check-in and check-out where users check-in and check-out using a RFID card. I am wanting to display who's in the building or been in the building on a given day. I have a VB.net program writing to the tables how in SQL would it best to display this data. […]
Integration Services
How to copy data from Salceforce to SQL SERVER tables - Hello Good Morning, I have about 8 tables in salceforce  i would like to copy/load them into sql server daily. (just truncate and reload) in sql server. but automated way not manual loading. please share any thoughts or ideas... Thank you Asita
C# Script for sending email - Can anyone help me with some script to send email with C#. I tried the "Send Mail Task" and it failed also. Here's what I have so far. It runs but I get no mail. My port number is 25 and I'm using basic authentication with password. Any ideas?: public void Main() { try { […]
SQLServerCentral.com Website Issues
private messages gone - hi, Maybe I'm doing something wrong now, but it seems that the option to look at my private messages is now gone from my profile - did had a few private discussions with members and can't find the option anywhere now.
 

 

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

 

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