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

Daily Coping Tip

Shift your mood by doing something you really enjoy

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.

Fixing Report Visuals

I'm not a visual designer, and I find that as I learn a bit more, many of my previous reports contain lots of silly mistakes. They're often full of data, which I like, but which can be hard for others to follow and understand.

I need to do better, and I do ask for help at times from friends. I also need to get a better process for evaluating if I'm doing a good job. I was thinking about that as I saw a makeover article from storytellingwithdata. It gives a short process of things to consider when building reports.

With most of our software, we go through iterative approaches, either by ourselves, or with others, to try and build something that meets the needs or a client. Reports involve the same process, but I know that often the report process is my showing them something very raw and them asking for changes.

What can be more time consuming is that the numbers are often the thing a client is concerned with early on. Are we calculating things correctly and including enough data. We might go back and forth quite a bit on this part of the report process.

Once we agree, and they are happy, I think I'm done and can move on. However, often this is where they start to now care about the visual appear. The layout, colors, etc., and I am drawn into another report writing session, spending more time on something that is far, far less interesting than writing queries or other software code.

I can see why tools like Power BI, which let the client mess with the visual design, have a lot of appeal. As a software developer, I'm out of the loop here, or more out of the loop. Let them decide they want a vertical or horizontal bar chart, or a stacked line chart. What do I care?

I know visualization, layout, colors, etc. are important. They're not enough of my job to care, but I do think someone needs to. I'm lucky in that my company has artists, so I can send over slides, reports, etc. and get hints about what I should change. It's certainly something I wish I'd have had in the past at other jobs, since anything beyond a simple graph or table is well outside my wheelhouse.

Steve Jones - SSC Editor

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

 
 Featured Contents

How to Restore a Snapshot in AWS RDS with the Same Name?

Vasanth Kumar Makam from SQLServerCentral

The demand for increasingly scalable, capable, and inexpensive database, backup, and recovery solutions has never been higher than it is now, as digital transformation reaches its pinnacle. Restoring is the process of recovering data from a backup and applying logged transactions to the data. Backups are used to restore data. Restoring returns the backup file […]

SQL Server and hyperconvergence

Additional Articles from SimpleTalk

To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.

The key to great database CI is disposable databases

Additional Articles from Redgate

Redgate engineer Matthew Flatt talks about the challenges of database Continuous Integration and what you need to do to become great.

From the SQL Server Central Blogs - AI is going to be everywhere and in everything

kleegeek from Technobabble by Klee from @kleegeek

I recently was a part of GestaltIT’s AI Field Day and have been thinking heavily about artificial intelligence (and by extension, machine learning and deep learning) lately. I put...

From the SQL Server Central Blogs - Command Line Report with SQL Compare 14

Steve Jones - SSC Editor from The Voice of the DBA

I wrote recently about the use of the command line in SQL Compare 14 to find differences for specific items. Now I want to actually see the changes to...

 

 Question of the Day

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

 

Data Flow Error Handling in ADF

I have an Azure Data Factory with a data flow activity in it. I am loading data from a source to an Azure SQL Database sink. If I encounter an error, what is the default error handling action?

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)

Swapping Values

I have this in python 3.9:

a = ['a','b','c']
b = [1, 2, 3]
a,b = b,a
b

What is returned?

Answer: ['a', 'b', 'c']

Explanation: This is shorthand for swapping values in Python. Ref: Python: Swap two variables - https://www.w3resource.com/python-exercises/python-basic-exercise-91.php

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
SSRS Query Designer times out - Hello experts, I am getting the following error when trying to open the Query Designer for the a report Dataset in Report Builder. The report runs successfully in the browser and in Report Builder. And the data sources for the report validate successfully. I also checked for TLS issues, but the report server is correctly […]
Error 17311 while trying to run query with OPENDATASOURCE - SQL Server 2016 SP2 terminates suddenly with the error id 17311. Here's the SQL dump error: 2021-06-27 10:32:05.29 spid63 SqlDumpExceptionHandler: Process 63 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2021-06-27 10:32:05.29 spid63 * ******************************************************************************* 2021-06-27 10:32:05.29 spid63 * 2021-06-27 10:32:05.29 spid63 * BEGIN STACK DUMP: 2021-06-27 10:32:05.29 spid63 * 06/27/21 10:32:05 […]
SQL Backup/Restore - Hi, Production database : I have a database Backup size is 300 GB from production server. Total size of hard disk is 1 TR in Production. Test environment: I want to restore a database in test, not all the tables from backup mdf. , i need only 50 GB data, from the database backup. Total […]
SQL Server 2016 - Development and T-SQL
Unable to create USER with T-SQL - Hello Community, Can someone explain why I'm getting the error Incorrect syntax near '-' When I run the followng sql code: CREATE USER DT-SERVICES-TEST WITHOUT LOGIN; My guess is because of the hypen '-' If that is the case, can someone let me know how to add the code with the hypen? Thanks    
sp_server_diagnostics_sleep - Hi, we are trying to bulk write the data in the table. but the process seems to get slow. On checking the wait type, i found continuous records of sp_server_diagnostics_sleep. Couldn't find the real reason for the latency of bulk insert in the table. Kindly help Saumik Vora
Need to get records based on Sub Query - I have written the query using ranking function. I tried to write the same query using sub query no clue. Can any body help The query below as follows WITH HighRecords AS ( SELECT BusinessEntityID, FirstName, MiddleName, LastName, TotalDue, ROW_NUMBER() OVER(PARTITION BY BusinessEntityId ORDER BY TotalDue ASC) AS RN FROM Person.Person Pp INNER JOIN Sales.Customer […]
Trouble filling missing months of data with zero values - Hello, Hopefully someone can help a novice with the following problem i have. We have as system that records monthly reported figures and for several accounts, quite often the sites don't report their figures. So for a 12 month period there can often be gaps. I would like to show all months in a result […]
Administration - SQL Server 2014
Unable to connect to SQL Server instance - I just created 2 named instances on 2 different server. Created firewall rules, enabled TCP/IP, made sure SQL Browser was running, both instances are running under default acct. I am able to connect to 1 named instance thru SSMS from my local machine and not to the other. I am also able to ping both […]
Development - SQL Server 2014
SQL Server 2014 Developer Edition - Hi, Can we use SQL SERVER 2014 Developer free Edition for UAT environment. Please help me. Thanks, Carmelo Labadie
SQL Server 2012 - T-SQL
Cursor replacement suggestions - I have a process that uses SqlAgent jobs to process data coming from many sources, and I'm seeing performance issues trying to process the data. Looking for suggestions on processing of the data table. I have a single SP currently processing from the table and it has a parm of equip_id so I break the […]
SQL Server 2019 - Administration
(Newbie) Help with strange tables in my database "dbo.183" etc. - I don't know how to read about this or any other way to ask it because I don't know what they are called.  But my sql server database is full of tables with strange names that I am not sure what is in them or what they are for. Examples are dbo.a183 dbo.a184 dbo.a185 Etc.  […]
Who Update the Stored procedure Last time? - Hello EveryOne, Need your help once again. I have lots of Stored PRocedures in my Database and we are 3 sql dba/developer . But need to know who updated the stored procedure last time? or by whom the stored procedure was updated last time?? Any Help or suggestion would be appriciated. Thanks in advance.
SQL Server 2019 - Development
transposing date column to rows - Hello people, I am trying to transpose date column to rows. I am not sure if this can be done for more than 10000+ rows. For example, I am trying to convert the table in image 1 to image 2. Please note that the below is just a example extract of the data , the […]
Splitting adhoc queries into a data structure - Issue - Current adhoc SQL can be generated by our reporting module that is difficult to maintain much less decipher.  The TSQL is huge and almost un-manageable.  This makes it extremely hard to figure out what to do since we can have hundreds of queries Partial solution - instead of using profiler we have a […]
Powershell
load xls file to sql - Looking for a script to load xls files to SQL without using dbatools or a Driver that's need to be loaded... Is there any Native loads of xls to SQL using PS script? I've been trying to use a script that converts cls to csv, but I run into issues on fields where the delimter […]
 

 

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

 

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