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

Daily Coping Tip

Look for something positive in your world and notice how things are better because of this

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.

Building a PC

I've built and bought some PCs throughout my career. Having a decent machine at home is important for me as a technologist. When I was younger, I liked assembling parts into my own machine. Now, I hate it. Actually, now I just buy used machines from Glenn Berry and let him play with the parts.  He's an expert on hardware, and he's helped me numerous times.
 
I saw an article this week on building a PC, which I think is a good general set of things to think about. This is roughly the process I'd follow, and I'd urge you to read the whole thing before you start. I've often had to make a second trip to Microcenter (the Denver local PC parts place) to get something I'd forgotten the first time. I've also occasionally picked the wrong part and needed to return something and get a better (or compatible) part.
 
If you aren't a hardware person, building a PC isn't hard. Glenn helped my son figure some things out when he wanted a gaming computer as a teenager, and he assembled the system himself. It is invaluable to have someone that you can call if you have questions. While most things just fit together, the world is way more complex than it was in 1990 when I built my first PC. There are lots of guides on how to put one together and you can create a very powerful PC at a reasonable cost.
 
And if you don't want to build one, think about buying one. Glenn has some systems for sale. and many local retailers or computer shops will help you pick what suits you if you don't want to build one. However, as a technical person, I think it can be a fun exercise to pick your parts and assemble your own system. You might even enjoy personalizing things with some colors, lights, or a cool case for your desk.
 
Creating a PC is a good exercise for you as a technical person. Not for me. I've done it enough times. Now I just want to go pick up a new (to me) box from Glenn that just works and buy him lunch so he'll move the storage from one system to the other

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Dealing with Transaction Log Growth

Br. Kenneth Igiri from SQLServerCentral

Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]

External Article

The benefits of database change management

Additional Articles from SimpleTalk

Using a change management system for database code is a new idea for many database administrators. Grant Fritchey explains the many benefits of database change control.

Blog Post

From the SQL Server Central Blogs - Running dynamic SQL in a different database

Kenneth.Fisher from SQLStudies

This is one of those things that on hindsight was a stupid problem, but still cost me hours and a ... Continue reading

Blog Post

From the SQL Server Central Blogs - VMware & SQL Server 823-824 alerts

kleegeek from Technobabble by Klee from @kleegeek

We’ve been tracking a weird state with SQL Server virtual machines on VMware and possible warnings on database corruption while VM backups are running, largely centered around (but not...

 

 Question of the Day

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

 

The Browser Port

I have installed a named instance of SQL Server 2019 on a server. I have enabled remote connections, but want to have clients connect automatically to the instance by name as it uses a dynamic port. What firewall change do I need to make for the SQL Browser to function?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Carlo Romagnano)

EXCEPT

What does this query return?

SELECT * FROM Sorders  WITH(NOLOCK)
WHERE order_dat >= '20220503'
except 
SELECT * FROM Sorders
WHERE order_dat >= '20220503'

Answer: Returns distinct rows from the left input query that aren't output by the right input query.

Explanation: EXCEPT returns distinct rows from the left input query that aren't output by the right input query. Ref: EXCEPT - https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-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
Named pipes - Hi All, A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. Named Pipes Provider: Could not open a connection […]
SQL Server 2017 - Development
when save float numbers it converted to IE so how to solve this issue ? - I work on sql server 2017 i face issue when save data on float column data type it saved as IE-07 AND ie-05 so what this and how to handle it please how to save data on float numbers as it is if there are any way to save data on correct way on another […]
SQL Server 2016 - Administration
Is it possible to Side Load a DB to AOAG then rename? - Hi, I have a large database within an 2016 AOAG that needs to be refreshed quite  in a test environment from a copy in production. In order to minimise restore time due to tight maintenance windows, i was looking at an option to restore a copy of the database alongside the existing database in a […]
SQL Server 2016 - Development and T-SQL
SQL Server 2016 SP3? - It’s been almost 4 years since Microsoft released 2016 SP2 and I’m wondering what happened to SP3 given that they usually release one service pack a year during mainstream support. Did 2016 join the Modern Servicing Model like SQL Server 2017? Is 2016 SP 2 the last service pack and from now on we will […]
Help Converting JSON to SQL Format - Hi Community, Can someone help convert the attached JSON file to SQL Format. You will notice there are a quite a number of columns. I have attempted to convert the column "Keywords" using the following code: SELECT report.* FROM OPENROWSET(BULK N'C:\Users\Carlton\Documents\caplogic\DATA\myjson.json', SINGLE_CLOB) AS j CROSS APPLY OPENJSON(BulkColumn, N'$keywords.columns') WITH ( [column] INT '$.keywords' , [score] […]
SQL Query Questions and Answers - Hi Community, Can someone provide some helpful links to where I can find SQL Query Questions on certain industries. For example, there is a book called "Query Answers with SQL Server", by Adam Aspin & Karine Aspin. This book gives lots of Sample Query questions on the Automotive Industry. I was wondering someone could help […]
SQL Server 2012 - T-SQL
Using 'row_number() over (partition by' to get a count - I have a CTE successfully using 'row_number() over (partition by' to return a list of patients with more than one diagnosis using 'and CTE.Row_Num > 1'. The challenge is I need to add a couple of lines to eliminate patients that have more than one 'dx_class_id' with the value of 276. I've tried adding a […]
SQL Server 2019 - Administration
Can an Index improve tempdb high usage ? - Hi All, Imagine a scenario where a datawarehouse database is working and, at the same time, limited disk space in our tempdb system database. When any process runs that loads data into memory, the tempdb alert reaches the maximum size. Is it worthiness to add an index to reduce tempdb usage ?. But, of course, […]
Database Log File - Hello, Whenever I am restoring the database from the backup to the database with the different name in SQL Server 2016 and 2019, it releases the used space from the log file. I need to preserve this used space for the testing, so the new database would be exactly the same as the old one. […]
which collation to use for japanese - Hello setting up a new enviroment I need make sure japanese langusge will be store correctly,which collation should I use? SQL_Latin1_General_CP1_CI_AS would work?  
SQL Server 2019 - Development
with within with error - Hello! Please, consider the following simple code   with cte AS ( SELECT [cntSRVLDAPLOADAVERAGE] FROM [watchdocstats].[dbo].[servercounters]); WITH cteCORE AS ( SELECT * FROM cte ); SELECT * FROM cteCORE Would someone please elaborate on why I get 'Incorrent syntax near ;' error?
Global ##TempTable created from different source databases - Naming Conflict?? - Hi all,  Really quick one I hope.   I have a stored procedure as part of an ETL process that drops the global temp table and SELECT * INTO  ##Global_temp_table. we are hitting issues with the error message ##Global_temp_table already exists (so you can't instantiate it with a  SELECT...INTO) We are running both QA and […]
Reporting Services
SSRS Delivery Options - All: Trying to upload a data file and have two questions: The User Name and Password, are NOT being saved see screenshot #1? \\IP Address\Assets\uploads\docs\GIS The second question. 2. Does anyone know if we can upload a file to a web location using the URL?
  •  https://www.dnsname.org/Assets/uploads/docs/GIS/ The Username and […]
XML
Looking for my "why use xml" aha moment - I'm learning xml. I'm getting the hang of the nitty gritty, tags, elements, etc. I haven't come across the WHY except that it's "good for sharing across platforms." So I put something into xml. Then share it across platforms. Then what? If the data was gathered to be used by someone who doesn't know xml, […]
Analysis Services
Analysis Services server failed to build OLAP database - Help needed - Hi All, We are building the OLAP Cube from Share point Central Administrator tool for Project Server 2019 and receiving below error message. The issue looks similar to the below link. Here we are using SQL Server 2017 so SSAS is also same version that comes with 2017 on windows 2016. As mentioned in the […]
 

 

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

 

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