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

Daily Coping Tip

Build on new ideas by thinking “Yes, and what if …”

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.

Summit Reflections

This is the second year that the annual PASS Data Community Summit has been virtual. Last year, as a pandemic gripped the world, I thought we might never see another one. I'm glad we have one this year, and I look forward to going back to a live, in-person Summit in 2022. That being said, this year's event has been better than I expected in many ways, mostly because of spatial.chat.

I can remember walking through the hallway of the Washington State Convention center and seeing Taiob Ali coming the other way. We stepped to the side of the hallway and had a chat among hundreds of people walking by. I thought about that in the Community Zone when he and I, with a couple others, were talking with each other in a group, away from others that were also in the room. We could see their avatars, but we were far enough away in the virtual space that our conversation didn't upset others.

At early Summits in Washington, there were couches in the Convention Center. Andy Warren and I often planted ourselves for hours on a couch, chatting with each other and those that came by. People would walk up and spend some time, others would drift away, but we had a conversation ebbing from work, life, Microsoft, family, hobbies, and more. We'd laugh and joke among ourselves, bonding and sharing, inspiring, and encouraging each other. I had that experience a few times in the Community Zone last week, as I stopped in various rooms, sometimes gathering in a crowd, sometimes (virtually) walking away to chat with just a friend or two.

When I presented at the Summit, I often felt pressured, rushed, and excited by interacting with people. Getting questions and needing to go off script and explain something was a challenge and a joy. When the Summit opened this Wednesday, I had one of the first Q&A sessions. Most people hadn't watched my recording, so I started to deliver the talk, but quickly realized I didn't have time. I saw a few questions come in the chat, feeling pressure to get to them and quickly answer them. I had no idea how many I'd get, so I did my best to share my screen, show examples, talk through some of the concepts. It was scary and invigorating. It reminded me of the times I'd get a few questions, realize I wasn't quite explaining things well enough, and then feeling pressure to deviate from what I'd rehearsed to help clarify the idea.

Most years I'd have early mornings and late nights. I've be buzzing from my interactions and physically exhausted. As I logged off from holding open the Community Zone Wednesday night, I felt the same way. Getting going Thursday to host the SQL Saturday room for a long time and trying to watch other sessions was tough. Friday harder. Exactly like I'd feel many years at the physical event. I needed a break. I've enjoyed walks around the grounds of the Gaylord, or in the park behind the Washington State Convention Center; at home I go outside and see the horses. Rather than a quiet dinner with a friend (or even solo), I could go cook something and relax with my wife and son here. Both different shades of the same experiences.

I am tired of virtual events. For me, they often lack the excitement and interest I get when I'm in a physical space. I wandered into different sessions, listened in on conversations of others, and enjoyed the interactions of being able to see and chat with others. I escaped at times to get away from the hectic environment, embraced it at others. Unlike my experience two weeks ago at Ignite, I felt like I was at an event.

That being said, I'm looking forward to more live events in the next year. I want to engage with actual people and remember the wonderful emotions of being in the same room. I'll miss those that don't feel comfortable, I respect your choice, and I hope we can continue to find ways to touch each others' lives. I'm also grateful that some of you are willing to come back to physical events and enjoy the #sqlfamily.

 

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

SQL Server Row-Level Security: A Comparison with Gallium Data

maxtardiveau from SQLServerCentral

A quick look at how the native SQL Server Row-Level Security compares with Gallium Data's solution for limiting access to rows of data.

SQLServerCentral Article

Easily Integrate with Any RESTful API Using the CData API Driver

JerodJ from SQLServerCentral

The evolution of APIs has opened up exciting opportunities for businesses. RESTful APIs are a consistent, straightforward way that enables businesses to work with external data and offer access to their own data. In May 2021, the number of public APIs grew beyond 24,000, with about 2,000 APIs added just since 2019.  APIs continue to be beneficial to businesses and developers, and with the CData API Driver, it […]

External Article

What we learned at PASS Data Community Summit

Additional Articles from Redgate

Join Steve Jones, Kathi Kellenberger and Grant Fritchey as they each reveal their highlights, learnings and key takeaways from their 2021 Summit experience.

External Article

SQL Server Database Stuck in Restoring Stat

Additional Articles from MSSQLTips.com

In this tip we look at different reasons why a SQL Server database will be in a restoring state and things that can be done to access the database.

From the SQL Server Central Blogs - Which Processes are waiting on a Spinlock?

david.fowler 42596 from SQL Undercover

Spinlock contention is always a real headache to deal with. I recently saw an issue when spinlock contention on SOS_CACHESTORE was making the server virtually unresponsive. The issue was...

Blog Post

From the SQL Server Central Blogs - SQL Homework – November 2021 – Backup, restore, and move the system databases?

Kenneth.Fisher from SQLStudies

On any instance you have at least 5 system databases. Master, model, msdb, tempdb and one other. First 5 points ... Continue reading

 

 Question of the Day

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

 

Row-Level Security Predicates

What types of security predicates are supported by row-level security in SQL Server/Azure SQL?

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)

Preventing Changes After the Tail-Log Backup

I have a database that I am moving to a new instance. I have restored a full and numerous log backups to the new instance already. Now I want to take a final tail-log backup of the database, but prevent anyone from changing any data in this copy of the database. What can I do?

Answer: Use the NORECOVERY option in the backup command.

Explanation: The NORECOVERY option is used to back up the tail of the log and leve the database in the restoring state. This prevents anyone from connecting and making any changes. 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
Cannot get Read connections to Read-Intent only Secondaries - Hi all Thanks last week first of all for your assistance in getting a quick setup for a third replica in our Always On system Problem I have now is baffling me. We have the Primary and one Secondary on subnet A, the (new, remote) Secondary on subnet B. They all are set to […]
SQL Server 2016 - Administration
DB and VM backup timing - Hello experts, In terms of backups, we have database backups set up, which I am familiar with, but we also back up our Windows VMs that host SQL Servers. Do you know if it is good or bad to have the Windows VM backup happen at the same time as the daily database full backups? […]
SQL 2012 - General
Sql 2012 service pack 3 fails to install - Hallo. Hope you can help. Im trying to install Sql 2012 Service Pack 3 on one of my servers, but it keeps failing. Tried via WU and manual install on the administrator account but no luck. When i look in the summary log: Exit error code: 1 Exit message: The required MSI package 'C:\Program Files\Microsoft […]
Fill down empty cells with values from a previous non-empty row - Hi , I have written code to fill empty rows from previous non-empty row, attached piece of code, it is working without any issues, but the problem is it taking more time due to data is bit higher, around 700k data. I have created index on ID but still running slow, Any help on this […]
How to get data from two tables from sub procedure to main procedure without usi - I work on sql server 2014 I can't get data from sub procedure to main procedure sub procedure will select data from two tables and after two tables select and get data i need to get data from two tables on main report without using insert into because i can't create new physical table to […]
SQL Server 2019 - Administration
Cluster Log warning in SQL Server Always-On Fail-Over Cluster - I have 2019 WSFC with SQL Server 2019 AlwaysOn HA. In the cluster log I constanly see the following warning. [API] s_ApiOpenResourceEx: Resource Scaleout Master not found, status = 5007 It also seems to be accompanied by [RES] SQL Server Availability Group: [hadrag] SQL Server component 'query_processing' health state has been changed from 'clean' to […]
TDE system databases, report server - I know that we cannot encrypt the master, model, and msdb databases; SQL won't even let you...  but is there any issue with encrypting the ReportServer and ReportServerTempDB databases?  I can't find any best practice for that anywhere. Not so much CAN we do it, but SHOULD we do it is what I am asking […]
SSIS packages XML error - GAH. Nevermind. I figured out what the issue is. I'm calling the server with the wrong name.
Offloading DBCC CHECKDB to another server - Hello, we've decided to move CHECKDBs for our biggest databases to another server, separated from production instance, with full weekly checks on restored DBs. I assume it wouldn't be wise to cancel CHECKDB jobs on the production server completely. Are there any recommendations what minimum level of CHECKDB should we should still use on the […]
SQL Server 2019 - Development
How not to aggregate on numeric fields -   Hey everyone, I have this code with which I am trying not to aggregate on two columns HistoryQuantity and TOTFCST. I keep getting this error Column 'SCPOMGR.HISTWIDE_CHAIN.HistoryQuantity' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause I don't think I should group by numeric columns. […]
Alternative method for Maintenance Plan for backups in SQL Server Express 2019 - Hi there We are currently using SQL Server Express 2019 which is limited in aspects including the Maintenance Plan Wizard. I would like to set up an automatic job which runs every night and backups our daabases. I have thought of using a sqlcmd script and executing tha through windows scheduler. But has anyone done […]
Visual Studio 2022 - No SSIS/SSAS/SSRS extensions! - After downloading VS2019 last week for a new project developing against SQL 2019, my colleague has come to download VS2019 today to find that Microsoft have released VS2022 and there appears to be no choice or option to download the previous version. No problem - surely, it all just work still won't it? Except NO! […]
Azure Data Factory
Azure Data Factory - I have a need to push data down from an Azure Sql db to on premise Sql db should be using 2 separate runtimes or will on of the be sufficient? Thank you in advance.
Best approach in ADF to mimic stored procedure logic against parquet files - Current environment We use stored procedures (in Production) to query our source application tables (hourly) and load fact and dimension tables for our reporting environment Our skillsets Traditional ETL development using stored procedures, structured SQL and SSIS We do not use SSIS packages in our current environment so we do not have any packages to […]
Analysis Services
MDX Date ranges - Heloo all. Looking for help with some calculated measures. See the attached code below. It runs, but isn't returning the expected data results. What I am trying to get to with the calculated measures is this: [Measures].[Next 7 Days of POs] = day 0 (current day)  to day 7, [Measures].[Next 14 Days of POs] = […]
 

 

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

 

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