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

Daily Coping Tip

If you can’t change it, change the way you think about 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.

Follow Wheaton's Law

I've tried to live my life as someone that treats others well, respects them, and cheers for them to succeed. Even before I heard it, I think I was unconsciously following Wheaton's Law (apologies for the slightly off color language).
 
I think about this often in my life, as a minority in most places I go for work or in society. I've had a lot of success, I'm intelligent, am comfortable talking with people, and many things go my way. At the same time, I'm not any better than anyone else. I try to say hi to the facilities staff at Redgate in the same way I do with my fellow advocates. I may sit and chat with our cooks or cleaning staff just as I might take a moment to chat with a developer.
 
With the dramatic changes brought about in our world by the COVID-19 pandemic, I have been thinking about the way that many people are interacting with those who work in much of the public world. Especially service workers, who these days may be deemed essential and are often the contact we have with lots of businesses, as cashiers, delivery people, and more.
 
This article upset me. Many people that have the least power, the depend on their jobs the most, with few other options, are often treated poorly by the people they encounter. I've seen poor behavior in the past in many situations, but the current pandemic and the push back against wearing masks has made things worse.
 
The entry level workers, those making low wages and doing many of the service jobs in our world, don't deserve to be poorly treated because you don't like the policy of some business. This certainly includes people doing manual work in our offices, acting as assistants, or some other non technical job. Treat other people well, as you'd want to be treated if someone didn't like the way you were instructed to do your job.

Steve Jones - SSC Editor

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

 
  Featured Contents

Access external data from Azure Synapse Analytics using Polybase

Sucharita Das from SQLServerCentral

Learn how you can use Polybase technology in Azure Synapse to load data into your warehouse.

Exploring the SQL Compare Options

Additional Articles from Redgate

Phil Factor dissects and disentangles the various SQL Compare options.

How to Expand a Range of Dates into Rows using a SQL Server Numbers Table

Additional Articles from MSSQLTips.com

In this article we look at different T-SQL code examples that can help you build a range of date rows based on a starting and ending date.

From the SQL Server Central Blogs - Using LAST_QUERY_PLAN_STATS in SQL Server 2019

John Morehouse from John Morehouse | Sqlrus.com

In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced.  The amount of improvements across the platform really allows...

From the SQL Server Central Blogs - Comparing SSIS and Azure Data Factory

Tim Mitchell from Tim Mitchell

For the better part of 15 years, SQL Server Integration Services (SSIS) has been the go-to enterprise extract-transform-load (ETL) tool for shops running on Microsoft SQL Server. More recently,...

 

  Question of the Day

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

 

The I in ACID

What does the I in ACID stand for when related to relational databases?

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)

The Binary Cast

What happens when I run this code?

SELECT CAST(0x7e AS NUMERIC(10,4))

Answer: "Msg 8114, Level 16, State 5, Line 10 Error converting data type varbinary to numeric." is returned

Explanation: This returns a conversion error as the scalar binary value is likely (guessing here) the wrong size to convert back to a numeric. It converts fine to an int. Any other explanation is welcome. Ref:

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
Table Partition in Sql Server - Hi Team, we have a table like 1.5 tb in size and around 800 cr records. I would like to make it as partitioned table. to make partition we need to drop and recreate primary and FK constraints will take more time. we need to perform this on more tables. so is there any approach […]
SQL Server 2017 - Development
How to performance tune ssis pkg when dev environment isnt as good as prod - Hey everyone, my dev envoronnebt has 56 GB of memory and 4 virtual processors with a speed of 2.29 GHz. My prod environment has 163 GB of memory and has 8 virtual processors at 2.29 GHz. I can update pkgs on my dev environment to run multiple data flows using Modulo and that pkg runs […]
SQL Query Help - CHARINDEX - Need query help. create table #tblTest1 (ID int, SName varchar(50), Type varchar(10)) INSERT INTO #tblTest1 values (1,'abc/efg','OS') INSERT INTO #tblTest1 values (2,'xyz/tgf','OS') INSERT INTO #tblTest1 values (2,'tgf/xxx','OS') INSERT INTO #tblTest1 values (3,'ccc/ppp','OS') INSERT INTO #tblTest1 values (4,'ddd/tqm','OS') INSERT INTO #tblTest1 values (5,'mpg/eee','OS') create table #tblTest2 (SName varchar(50)) INSERT INTO #tblTest2 values ('efg') INSERT INTO #tblTest2 […]
SQL Server 2016 - Administration
Best way to replicate 1 table from Production DB to Dev Db - I'm sure there are a dozen different ways that this can be accomplished and many things that will make some better that others. I have a VM win2012R2 SQL2016dev 'dev' and a box win2016 sql2016ent 'prod' Developers cannot have any access to prod, and have full access on dev. I would like to provide them […]
SCOM alert offline/recovery pending/suspect... but DBs seems fine - Hello experts, We are using SCOM to monitor SQL Server AOAG, and I am having trouble resolving this alert: Database is in offline/recovery pending/suspect/emergency state I use the alert details to check the status of the databases on each of the AOAG replicas, as well as the Always On High Availability Dashboard. The dashboard is […]
What Should be...? - Dear friends, Using Always On in our corporate site, we have 3 nodes deployed, our main database backup is based on images of that virtual  machines, but constantly I have databases requesting transaction log backups, what role should have a normal backup of transaction log files vs virtual machines images backup, our management team has […]
SQL Server 2016 - Development and T-SQL
How to grant only read(Select) permissions to the Group of Users - I have a business requirement where Business Users are all available in Group "TradingBusinessUsers" , Now i want to grant select permissions to all tables for the users in the group "TradingBusinessUsers"  and also users are allowed to create table on their own Self-schema and manage their tables. Can anyone help me to solve this […]
Is it possible to display Date in between in cube without multiplying the Data? - Ahoi, I have to display "discount" as a measure in my Cube. The basic structure is: DateFrom DateUntill DiscountMeasure   The request is: Have a Date and display the DiscountMeasure. My question is: Is there a better way to solve this than creating a dataset for each day between DateFrom and DateUntill? I was hoping […]
SQL Server 2012 - T-SQL
Need help formatting BCP output - Hello, I have a bcp script that generates stored procedure code output as shown below. bcp "select RTRIM(LTRIM(c.text)) FROM sys.objects AS o INNER JOIN sys.syscomments AS c ON o.object_id = c.id WHERE o.type = 'P' AND o.name = 'sp_ic9av0_dx_length'" queryout "\\dbserver1\j$\Backup\NG Sps\sp_ic9av0_dx_length.sql" -t -c -r "\t" -SServer1 -T -dMyDb There is a formatting issue in […]
SQL Server 2019 - Administration
Update - I have a Use case like. We migrated around 1000 millions of rows into around 5-6 tables. client requirement frequently change to update some columns. Is there any best way to Update those tables other then Batch/looping updates. We tried disabling all the index but still it's taking too much time. Even we have 5-8 […]
Page File. Set Value, or let Windows Manage it ? - I friend at another company said they got an out of memory error on their Production SQL server. It has 24 Gig of RAM and a 4 Gig page file. Their hosting company said they can increase the page file to a set value, or let Windows manage it. If Windows manages it, is there […]
SQL Server Hardware Recommendation - Hi,   I'm looking for a recommended Hardware Spec to run SQL Server 2019 Enterprise on. Our software vendor has suggested the below, but was looking for other people's thoughts. Our Database is currently sitting on a SQL2000 database - it's around 300GB in size and is accessed by around 90 people at a time. […]
SQL Server 2019 - Development
Change color scheme for Admin account in SSMS - I was reading one of Brent Ozar's posts about SSMS, and he was talking about "never use the sa/admin account unless you need to", so I was wondering if there is a way (I know there is) to change the background color or the color of the window for just the SA/admin account, so I […]
DateDiff for only @p_start_date and @p_enddate - So I am trying to get the datediff for parameters selected, even though the 2 dates could span 60 days, for an example I have 2 dates available(2018-01-05 11:08:00) and unavailable (2017-10-30 05:05:00) I only want the datediff where @p_start_date = 2017-12-01 and @p_end_date = 2017-12-31 those are the selected parameters.
Integration Services
Access Files Stored in Box.com - Has anyone created an SSIS package which grabs data from one or more files stored on Box.com? I would be interested in hearing how you got on. Did you get the Box API working from a script task? Any issues adding DLLs to the GAC?
 

 

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

 

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