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

Daily Coping Tip

Get back in contact with an old friend you miss

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.

Remembering the Past

Just a short time ago, the SQL Family lost Gareth Swanepoel. It was fairly sudden and sad to have someone I knew fairly well pass away. He was the first person that I directly knew that was lost to the COVID-19 pandemic.

I'm getting older. I seem to hear about a person I've known passing away almost every year now. I know I've got more life behind me than in front of me, and I cherish the moments I do have and the memories of others.

A few years ago Andy Warren and I were talking about this subject. This was after we lost a common friend, and we wanted to have some way to remember them. We kicked around a few ideas, but other than adding an "Obituaries" category to Database Weekly, I didn't do much.

I decided to change that after I heard about Gareth. While processing my grief, I bought sqlmemorial.org and started to put something together. I've been hearing about Jekyll and I spent a little time messing around with it. I ended up deciding to put this up and start ensuring that we have a way to remember the people that have taught and touched us. I'll also share some articles on how I put this together.

I set this up as a GitHub repo, and I am taking pull requests for people that want to add a memory, a link, a picture, or something else. I'm also hoping that people will let me know as others pass, a sad fact of life that we will continue to experience in the years to come.

I'm hoping this helps me, and many of you, fondly remember the people in our SQL Family.

Steve Jones - SSC Editor

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

 
 Featured Contents

Building SQL Memorial - Getting Started

Steve Jones - SSC Editor from SQLServerCentral

Introduction One of the projects I've been wanting to tackle for some time is putting up a memorial for those people that our community has lost. I talked about it when Dwain Camps passed, and I kicked myself for not having something available when Tom Roush passed. Recently Gareth Swanepoel suddenly left us after COVID-19 […]

SQL Server interview questions for experienced developers

Additional Articles from SimpleTalk

SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this article, Sergey Gigoyan provides his favorite questions for interviewing SQL Server developers.

From the SQL Server Central Blogs - Storage Tiers What SQL Server DBAs Need to Know

SQLEspresso from SQLEspresso

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server and storage performance. No matter how many gerbils power your storage, you need to know...

From the SQL Server Central Blogs - What is the CONTROL permission?

Kenneth.Fisher from SQLStudies

One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: ... Continue reading

 

 Question of the Day

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

 

Python Dictionary to DataFrame

I have this dictionary, which I want to convert to a dataframe. 
Mydict = { 'Broncos': [5, 12], 'Chiefs': [14, 2], 'Chargers':[7,9], 'Raiders': [8,8]}
Which code will do this (assume I have pandas loaded)?

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)

Setting the Date

What is SET DATEFIRST used for?

Answer: Setting the number of the first day of the week in calculations

Explanation: This sets the first day of the week used for calculations. Ref: SET DATEFIRST - https://docs.microsoft.com/en-us/sql/t-sql/statements/set-datefirst-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
WHATSAPP:+1(706)521–4615 WHERE CAN I GET NCLEX CERTIFICATES WITHOUT EXPERIENCE - WHATSAPP:+1(706)521–4615 WHERE CAN I GET NCLEX CERTIFICATES WITHOUT EXPERIENCE https://www.premiumcertifications.com/premium-certifications-express/buy-nclex-certifications-online/ BUY REGISTERED NCLEX CERTIFICATES WITHOUT EXAMS-PASS NCLEX EXAMS WITHOUT EXPERIENCE-BUY NCLEX CERTIFICATIONS WITHOUT EXPERIENCE- BUY ORIGINAL NCLEX CERTIFICATE WITHOUT EXAMS - BUY NCLEX CERTIFICATES ONLINE in Baltimore, Maryland - how to get NCLEX certificate WITHOUT EXPERIENCE - Buy Registered NCLEX-RN certificate Online in Colorado - […]
SQL Server 2017 - Development
Lookup and insert into column without dynamic SQL? - Hi all, 99% sure the answer to this question is "it is not possible", but figured I'd check anyway. Suppose I have the following schema: CREATE TABLE #FieldValues ( ID INT IDENTITY PRIMARY KEY, Field1 VARCHAR(500), Field2 VARCHAR(500), Field3 VARCHAR(500) ) CREATE TABLE #FieldDefinitions ( ID INT IDENTITY PRIMARY KEY, DefinitionName VARCHAR(50), FieldName VARCHAR(50) ) […]
SQL Server 2016 - Development and T-SQL
Find unmatched between 2 tables using field as selection criteria - I have the following tables as a example. Table 1 EmpID, LastName, FirstName 1,Smith,John 2,Jones,Bob 3,Citizen,Jane Table 2 EmpID,ReqID,ReqDesc 1,1,Car 1,2,Diploma 1,3,Phone 2,1,Car 2,3,Phone 3,1,Car 3,2,Diploma 3,3,Phone I want to return all records from Table 1 that don't have an entry in Table 2 that don't have a Diploma for example so ReqID = 2 […]
Administration - SQL Server 2014
Do I need to install two patches for 2014 individually? - We are on version SP3/CU4 for SQL Server 2014.  Since CU4, there have been two security patches released, one on 2/11/20 and the other recently on 1/12/21. If I install the latest 1/12/21 security patch, will it "include" the patch for 2/11/20, or do I need to install both of them (in sequence)?
Development - SQL Server 2014
Save results from Stored procedure to a CSV file. - I have a SqlAgentJob calling a stored proc. that loops through a list of locations and passes the location value and other parameters to a stored procedure.  I would like to save each of the results to a CSV on the server. Because i have 50+ locations my current method of a separate sqlAgenjob using […]
Execute As not reading system view - I have a stored procedure with the following: SELECT physical_name FROM sys.master_files Where physical_name like '%' + DB_NAME() + '.%' When the procedure is compiled normally, this runs fine, but when it is compiled With Execute As 'Paleo-Server\SQLServerZaloha', this select statement returns a null. I ran this statement I found on the web: grant view […]
SQL 2012 - General
Do I need to install two patches for 2012 individually? - We are on version SP4 for SQL Server 2012. Since SP4, there have been two security patches released, one on 2/11/20 and the other recently on 1/12/21. If I install the latest 1/12/21 security patch, will it "include" the patch for 2/11/20, or do I need to install both of them (in sequence)?
SQL Server 2012 - T-SQL
Summary query for number of attendees out of all - hi all i'm trying to write a query to summarize attendance counts per department i've two tables one for event log (login/logout) transactions and the other for users details i need to show the result as dept.      attend users      all users dept1             5        […]
update using self-join - confirm it looks at old values - I'm doing an update using a self-join, and just want to confirm something.  If the query updates a certain row I'll call row A, and then updates another row B based on a value in row A, does it look at the old value in row A, or the new value? Since we can't do […]
SQL Server 2019 - Administration
WHATSAPP:+1(706)521–4615 HOW TO BUY NCLEX CERTIFICATES WITHOUT EXAMS - WHATSAPP:+1(706)521–4615 HOW TO BUY NCLEX CERTIFICATES WITHOUT EXAMS https://www.premiumcertifications.com/premium-certifications-express/buy-nclex-certifications-online/ WHATSAPP:+1(706)521–4615 HOW TO GET NCLEX CERTIFICATES WITHOUT EXAMS-PASS NCLEX EXAMS WITHOUT EXPERIENCE-BUY NCLEX CERTIFICATIONS WITHOUT experience- BUY ORIGINAL NCLEX CERTIFICATE WITHOUT EXAMS - BUY NCLEX CERTIFICATES ONLINE in Baltimore, Maryland - how to get NCLEX certificate WITHOUT EXPERIENCE - Buy Registered NCLEX-RN certificate Online in Colorado […]
MYSQL ERROR - need desperate help - Hi, Im having a problem with new players selecting a player class. Keep getting this error. Message: Error Executing Database Query. URL: /ClassSelect.cfm? Location: C:\websites\myConvicts\www\ClassSelect.cfm Line #: 36 SQL: INSERT INTO DR_Player_Upgrade (PlayerID, UpgradeID, PurchaseDate) VALUES (2930848,27,CURRENT_TIMESTAMP) [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK_DR_Player_Upgrade'. Cannot insert duplicate key in object 'dbo.DR_Player_Upgrade'. The duplicate key […]
SQL Server 2019 - Development
WHATSAPP:+1(706)521–4615 HOW TO GET NCLEX CERTIFICATES WITHOUT EXPERIENCE - WHATSAPP:+1(706)521–4615 HOW TO GET NCLEX CERTIFICATES WITHOUT EXPERIENCE https://www.premiumcertifications.com/premium-certifications-express/buy-nclex-certifications-online/ CONTACT US WHATSAPP:+1(706)521–4615 BUY NCLEX CERTIFICATES WITHOUT EXAMS-PASS NCLEX EXAMS WITHOUT EXPERIENCE-BUY NCLEX CERTIFICATIONS WITHOUT EXPERIENCE- BUY ORIGINAL NCLEX CERTIFICATE WITHOUT EXAMS - BUY NCLEX CERTIFICATES ONLINE in Baltimore, Maryland - how to get NCLEX certificate WITHOUT EXPERIENCE - Buy Registered NCLEX-RN certificate Online in Colorado […]
General Cloud Computing Questions
WHATSAPP:+1(706)521–4615 BEST PLACE TO BUY NCLEX CERTIFICATES WITHOUT EXAMS - WHATSAPP:+1(706)521–4615 BEST PLACE TO BUY NCLEX CERTIFICATES WITHOUT EXAMS https://www.premiumcertifications.com/premium-certifications-express/buy-nclex-certifications-online/ CONTACT US WHATSAPP:+1(706)521–4615 BUY NCLEX CERTIFICATES WITHOUT EXAMS-PASS NCLEX EXAMS WITHOUT EXPERIENCE-BUY NCLEX CERTIFICATIONS WITHOUT EXPERIENCE- BUY ORIGINAL NCLEX CERTIFICATE WITHOUT EXAMS - BUY NCLEX CERTIFICATES ONLINE in Baltimore, Maryland - how to get NCLEX certificate WITHOUT EXPERIENCE - Buy Registered NCLEX-RN certificate Online in […]
Reporting Services
Search Report definitions - I know that there is a query you can run in SQL to search the SQL text procedures & objects for a specific string. Is there a way to search the report definitions of all reports for a specific string (values, table references, etc.)?
Analysis Services
DAX how to rewrite this FILTER to CALCULATETABLE? - Ahoi,   i have been starting to look into DAX and there is something i could not find an answer to somehow. I am very new to DAX so im trying to understand the basics and have come across something bothers me. How do i rewrite the following Query using CALCULATETABLE instead of FILTER?   […]
 

 

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

 

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