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

Daily Coping Tip

Spend time wishing for other people to be happy

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.

Digitizing Construction

Perhaps you think of the construction industry as being more analog and less interested in building a robust digital infrastructure. This article talks about one large company that is modernizing, and has accelerated that move during the pandemic. They are generating lots of data with drones capturing images of projects and collaboration between many different groups that are often not physically co-located together. While their business is construction, they are really a large enterprise that faces many of the same challenges any enterprise faces with moving information around, securely and conveniently for their staff.

However, even smaller companies are depending more and more on a modern infrastructure. I had a contractor renovate my bathroom recently, and while there certainly is some in person work, plenty of the planning, payment, supply chain, and more comes from the use of digital technologies. Even a 55 year old contractor is embracing new ways of doing business.

Many repair companies around the US are consolidating and joining into groups, with better guarantees for their work, but also more precise scheduling, bidding, smoother (and quicker) payments, and even the sharing of designs and problems through images, reducing the number of physical trips that staff makes, and giving a better experience to the customer. This does come at a charge, often with a higher cost for projects, but I find that I can count on many of these services more than I could with random handy-people and contractors in the past.

Construction will always be a hands-on job for some. Plumbers need to go where the pipes are, but they are taking advantage of more technology and innovations to make their jobs easier. We use new materials, new techniques and products that make the construction of physical spaces, and the deconstruction, quicker and easier than in the past. In many cases, we often get a superior product, though there is a cost.

There are also problems. Any time someone is building something, there is a chance they make an error, or a physical part fails, or the supply chain doesn't keep up. It does seem that I tend to find less of these issues than in the past, and often an organization will fix a problem. If they don't, the one part of the digital world that definitely affects construction is the sharing of information by customers. Bad ratings, complaints, and more are common, and can often affect business for contractors quite a bit. Positive ratings can result in more work than an individual can handle. Maybe that's the part I like the best, that the digital connections we have allow us to share feedback and images of workmanship. At least in my area, that's led to some good outcomes.

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.

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 10: Function / Iterator Function Pairs: The DAX Product() and ProductX() Functions

Bill Pearson from SQLServerCentral.com

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX Product()and ProductX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Product()and ProductX(), respectively, in returning the product of numbers in a column and in returning the product of an expression evaluated for each row in a table.

Collecting SQL Server performance monitor data

Additional Articles from SimpleTalk

SQL Server provides information for troubleshooting performance. Ed Pollack demonstrates collecting SQL Server performance monitor data.

3 ways MSPs can offer more value

Additional Articles from Redgate

In the Global State of the MSP Report from Datto, cloud and cybersecurity were identified as two key areas for growth. In this blog we cover three wants Managed Service Providers can offer more value in this areas.

From the SQL Server Central Blogs - Connecting to Azure Blobs in Power BI

DataOnWheels from DataOnWheels

The step-by-step process below walks through connecting to data housed in Azure Blob Storage from Power BI using a SAS token. There are many ways to grab your data...

From the SQL Server Central Blogs - Using Variables in Power Automate Desktop

Devin Knight from Devin Knight

In this video Devin continues building on a previously created Power Automate Desktop Flow design to show how to leverage variables to make solutions dynamic.

 

 Question of the Day

Today's question (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?

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)

Index Type Limits

Which of these data types are not allowed for the columns in an index? (choose 2)

Answer: xml, varchar(max)

Explanation: These types are not allowed as columns in an index: ntext, text, varchar(max), nvarchar(max), varbinary(max), xml, or image Ref: Table Constraints - https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-table-constraint-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 2016 - Administration
Transaction log shrink w/ logshipping - Hello everyone, Again with this question. I've got a log-shipped database, and I would like to decrease the size of the transaction log. What's different from the other examples of this question I've seen here is that I do know that the current size of the transaction log was caused by a single large […]
How to limit SQL Job Success events - Hi, We have a monitoring tool that reads Windows Event Log entries for Failure and Success of SQL Job executions. So, we have setup MSSQL jobs to write to the Windows Event Log when they fail or complete successfully. This works okay, however for jobs that run at a very high frequency I find that […]
SQL Server 2016 - Development and T-SQL
Bulk Insert 4832, 7399, and 7330 errors - Hello all, I was wondering if someone can shed some light on my dilemma. I have a SQL job that runs a script containing a bulk insert process. Occasionally fails with the three error codes. 4832, 7399, and 7330. Executed as user: xxxx . Bulk load: An unexpected end of file was encountered in the […]
Not with delete Statement help - Hello There Good Morning,   Have a quick question, with delete statement right now I have the below statement. so i am trying to delete the other records that means not matching below criteria can i use NOT ? Delete from Patient WHERE (isnull(billamount,0)+isnull(discamount,0)<100 AND ( domesticpatient = 'Y' or invalidaddress = 'Y' or invalid […]
Administration - SQL Server 2014
Slow performance after database shrink - Hi, We performed a database shrink on both log as well as data files as a last resort to save some space. It did helped us to resolve the space issue but the DB is running tremendously slow post that. We checked for the index fragmentation and reorganize/rebuilded them accordingly. Now I am not a […]
Development - SQL Server 2014
Alternative to LAG(SUM) - Can a Column Reference The Sum of the Values Above It - Hi Everyone, I'm trying to do something that seems pretty simple, but SQL Server doesn't seem to allow it. For a given column - let's call it col C - I want to use the SUM of all values in col C in rows above the current row to determine the value of col C […]
SQL 2012 - General
Migrate SQL Sever 2012 Database To Server 2014 and Subsequent Versions - Hi Guys, I have an SQL Server 2012 Express database that I would like to migrate to SQL Server 2014 Express as well as subsequent versions.  The reason for wanting multiple versions of the database is because I will be developing an application using the database and I haven't decided which version of .Net I […]
SQL Server 2019 - Administration
Need to change RS Execution Acct PWD, automatically w/ T-SQL - We use a 3rd party vendor to administer our SQL Server service account PWDS. We have an API to capture the new PWD -- which changes every "n" days and we're looking to automate the PWD update for our SSRS Execution Account. Using T-SQL, is there a way to change the SSRS Execution Account PASSWORD […]
Setting data compression on a database or even server level possible? - I well realize data compression is a subject to a few variables, such as table/index/both and page vs row but in case a certain data compression implementation is desired across all database tables and indexes both, all page, for example, is there a way to set this on a database or even a server level? […]
SQL Server 2019 - Development
NOT IN vs. NOT EXISTS - This is a basic question which occurred to me while reading something on the usage of NOT IN and NOT EXISTS. It made me to go back and look into a query I wrote a few years go to compare differences. In below queries, although they both give me the same result and same processing […]
Remove table partitioning - Hi all, Just wanted to check something out if I may, we have a table (call it TableA) that is 29GB in size, its currently split over a number of partitions, I need to remove the partitioning and I wanted to check to see if there was another/easy way to do this, as of now […]
Having sum(amount) = 0 returns negatives as well. - Hello all, I'm trying to get a list of ID's that have a total sum of their amount column = to zero... But I'm getting a lot of negative numbers, but no positives. So, for example, I might get an ID that has two rows in total which if you add up their amounts it […]
SQL Server 2008 - General
Storage Space of a Column having XML datatype with NULL value - Does XML datatype with NULL Value in SQL Server 2008 consume any storage space? As mentioned in https://www.sqlshack.com/optimize-null-values-storage-consumption-using-sql-server-sparse-columns/ If we store a NULL value in a fixed-length column such as a column with INT data type, the NULL value will consume the whole column length. If we store a NULL value in a variable-length column […]
Amazon AWS and other cloud vendors
How is Throughput optimized HDD (st 1) - Hi Everyone. i am planning to shift my website to AWS   I want to know the difference between Throughput HDD (st 1) & General Purpose SSD (gp3) My website is related downloads, it has 20-30k visitors.   Will there be concurrent connections problems?   i am currently using Digital Ocean SSD
Reporting Services
AVE ON GROUP TOTAL - I created a report with average on group totals on [Length of Stay] column. In VS, it renders properly. =Sum(Max(Fields!LengthOfStay.Value, "PTGroup"))/CountDistinct(Fields!UniqueID.Value) When I upload the report on the reporting server, I'm getting this instead: And when I export to EXCEL, this is what I get:   Any ideas why?    
 

 

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

 

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