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

Daily Coping Tip

Set an intention to be kind to others and yourself this week

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.

Look Beyond What You See

One of the sales managers at Redgate Software posted an origin story about how he came to work at Redgate Software. It's an interesting story, and while I don't work in sales or have the same origin story, I don't know that I could have seen the place I'm in now early in my career.

When I saw the video, it made me think of this movie scene, where Rafiki asks us to look beyond what we see. I think this is a hard thing for many of us, especially when many of us have been leaning on our skills in the past. What we know and what we are good at doing has led us to this place. Picking a new direction, or thinking in a new way might be hard.

For lots of us, we might be concerned about the cloud, and what we should learn or where this might lead us.  Azure or AWS? Some might be concerned about moving into management. Will I be good at it? Will it be a better career for me? Others can wonder about specific technologies. Power BI or Tableau?

I wouldn't recommend a specific thing for anyone without knowing more about their situation, but I do advise people to be open to opportunities, investigate and ask questions, and embrace possibilities. Look for what might be slightly out of focus or uncomfortable for you. Look beyond what you see and consider what you haven't seen before.

My origin story is getting an electrical engineering internship. Finding that the group needed help with Lotus 1-2-3 macros. Realizing I liked working with computers more than walking around a power plant and working with electricians to follow designs. I then realized that I didn't love programming or network support, but I saw an opportunity in 1991 to work with SQL Server, and I took it. I looked far beyond what I had thought about as a teenager, as a college student, and even as a young person in my career. I embraced an opportunity to write an article and that led me to SQL Server Central and now Redgate Software.

Think about the directions you could take in any situation and open your eyes to the possibilities. You might find an opportunity that changes your life.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Business Analytics from Application Logs and SQL Server Database using Splunk

roopesh.uniyal@gmail.com from SQLServerCentral

Learn how Splunk can be used to get information from application logs or a SQL Server database.

Technical Article

SQL Server vs Oracle: Data Masking

Additional Articles from SQLServerCentral

In this article, we look at how to mask/hide data for users using Dynamic Data Masking in SQL Server and Data Redaction in Oracle

External Article

Building a Database with Flyway

Additional Articles from Redgate

Flyway, especially Flyway Teams edition, can be used in several different ways to accommodate a database development that was originally based on builds rather than migrations. This article explores four different ways to use Flyway to build a particular version of a database, from the ground up, using a single migration script. It should help teams select the best way to incorporate Flyway into an existing database build system, during development, while benefitting from use of Flyway's versioned migration system for deployments and releases.

Blog Post

From the SQL Server Central Blogs - [How-To] SSRS migration

gbargsley from GarryBargsley

Good evening. Today’s episode is coming to you from my home office, where I feel motivated to write a blog in the comfort of my home. Today we will...

Blog Post

From the SQL Server Central Blogs - Questions to ask when designing a data architecture

James Serra from James Serra's Blog

When I’m leading a full-day architecture design session (ADS) with a customer and the goal is to come up with a data architecture for them, I first start doing...

 

 Question of the Day

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

 

DATETRUNC

In SQL Server 2022, there is a new T-SQL function, called DATETRUNC(). What does this do?

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)

Performance Monitor Data

I want to check some performance counters on a remote SQL Server. I have a query window open to the database. What is the easiest way to query a performance monitor counter, such as the Logins/sec from the SQLServer:General Statistics object?

Answer: Query sys.dm_os_performance_counters

Explanation: There is a DMV, sys.dm_os_performance_counters, which gets the same data as Performance Monitor from the Windows OS (or Linux OS). Ref: sys.dm_os_performance_counters - https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-performance-counters-transact-sql?view=sql-server-ver16

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
AG issue - Few databases  are not in sync  in an AG   as we did not find  any  errors on secondary  replica . any query  to check the  last log backup  on secondary  server  and databases are in huge size  (1TB).  How to resync  database with primary  with out  dropping and adding  database in  primary  by  restoring full […]
Blocking with replication monitor - Hi SQL Experts, I opened the  replication monitor. I noticed it is causing frequent blocking. When I noticed it is showing create index statements but I didn't create any indexes. What it will happen when you open the replication monitor & why it is causing blocking?
Log backup job running long time - Hi, We have log backup job running daily 5 times. One time run is taking 4-5 times longer than the other runs daily. The backup size is same for all runs. How can we identify why it is taking long time for that particular time? We have DBCC check job scheduled 2hr before that log […]
Anonymus user for existing login in SSAS profile - Hi, We have SSAS installed. It is connecting remotely and loosing connection the connection immediately. When I run the profiler when it is first connected it is using the credentials and showing the permissions as OLAPdatareader in the profiler but immediately it is showing as anonymous user in the profiler and lost the connection to […]
SQL Server 2017 - Development
Archiving big table - Hey All, We have a very big table which stores transaction data and it is SCD Type 2 table. Records are identified by ID and effective date columns, primary key on these two columns. Table has grown close to 500GB in size with 1.4billion records.  2years ago we had moved records older than 2018/03 to […]
SQL Server 2016 - Administration
Permissions for a login - We have a login with a db_datareader only permissions. However, this login cannot see stored procedures in SSMS object explorer and cannot select from sys.procedures (only built-in diagram-related sp are listed there). What extra permissions should we give to a login to be able to see all stored procedures (not to execute them) and still […]
SQL Server 2016 - Development and T-SQL
Missing Data(finding the root problem) - I have this function running(see code). I would like to select data beteen dates e.g 30-06-2022 to 31-07-2022. Specificaly for columns Eligible, Fuel Levy, Claimable and % Eligible of purchase. I am gettig zero for these columns. Is my code the reason i am getting these errors or my data missing. More of the views/tables […]
Development - SQL Server 2014
SQL Using a PIVOT to Convert row data to column - Hello, Im trying to get a Pivot to work , but its retuning a NULL . I tried various thing , like using Partition with Row_number as well , the below is the scipt but return null. Basically, I'm looking for the Meshtype  to be the column    i.e Fine, coarse and Dry to be […]
SQL 2012 - General
MS SQL Server 2012 Bible, any opinions on this book? - Hello, the book MS SQL Server 2012 Bible is on O'Reilly's daily deal and I was wondering if anyone had any opinions or thought on it. I have been learning how to work SQL queries and databases at work for a project and am trying to decide if this book is worth buying.
SQL Server 2019 - Administration
Command-line installation failure - Detail.txt in use - Hi. I'm having a problem (on 2 different servers) performing a command-line install of SQL2019 with the error: The process cannot access the file 'C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220802_031252\Detail.txt' because it is being used by another process. Any ideas what might be causing this? Thanks.
SQL Serer 2019 Mikn Worker Thread Calculations - I have looked at Max Worker Threads for SQL Server Always on Availability Group databases And AlwaysOn Availability Groups: What not to do when adding databases I'm trying to calculate minimum required worker threads on the primary using this formula: SELECT AG = D * (LCWT + (LSWT * SRC)) +MHWT Knowing that I have […]
SQL Server 2019 - Development
Count a new field in SQL statement - Hello all, I am trying to find a query that bring results like on the example. Thanks a lot all and best regards,
Calculate a new field in SQL statement - I have need calculate new field on this logic Is there way to do in SQL instead of procedure or function We have invoice id and item line item and we have credit memo which apply to line item Line Item 1 = 2098.76 Line Item 2 = 699.59 Apply CM Amount -2798.35 to both […]
SQL Azure - Administration
Password management in SQL MI for Sysadmin account - Hi, I've a requirement to provide temporary access for a sysadmin account. Each time a user requires access, temporary password needs to be created for the specific login. I've heard Password management tools like Cyberark can be used for it. Is there an inbuit tool for SQL MI password management or any open source tool […]
Amazon AWS and other cloud vendors
New to AWS - I am very new to AWS and trying to figure out how to do a few things but I am getting a bit overwhelmed. I have code that I put on an EC2 instance and it is connected to RDS. I can look up the EC2 generated url and see the data I expect to […]
 

 

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

 

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