Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News
Hand-picked content to sharpen your professional edge
Editorial
 

Stories to Engage Us

I've always been fascinated by history. For a long time growing up, my plan was to become a history teacher. While that didn't work out, I've continued to read quite a lot of history, both popular and scholarly works. One of the things about it that I find most fascinating are the stories. History is simply filled with fascinating events & people that tell an amazing story.

Interestingly enough, how I get roped into some of my readings on history is through other stories. I also like to read speculative (or science) fiction and even just traditional fiction sometimes. For example, I started reading a series of books called Sharpe's. Prior to that, my knowledge of the Napoleonic wars could be summarized as "Napoleon won until he invaded Russia. He lost. Then lost a second time at Waterloo for some reason." Yeah, not even remotely accurate. However, back to Sharpe's. The more I read these fun stories, the more I wanted to know the real history. So, I started reading about the Napoleonic Wars and the Spanish Ulcer. Come to find out, the real stories are actually every bit as good as the fictional ones. Better sometimes. Like the church where Spanish & French troops literally fired at one another from opposite ends over a couple of days during a siege. Amazing stuff.

I hear you: "Very nice Grant. What does this have to do with tech?"

I was recently talking to a client about SQL Monitor. They were happy with it, but not excited about it. They mentioned how it was nice that it spotted old or missing backups and then proceeded on. I stopped them right there. Instead of emphasizing how important knowing whether or not your databases are backed up, how old those backups are, etc., I told a story. We had an incident at a former employer where we thought we had all our backups running. Come to find out, right after someone dropped the database, on one server, our backups had been failing and we didn't know. Yeah, we lost about four months of data in this one database. It was just gone. After telling this story, suddenly, the client was much more interested in what SQL Monitor could do to help them out.

Stories help to get our attention. Just knowing that we should do something or that there are negative repercussions is frequently not enough. Instead, we need that "There I was, in the stuff, with the grunts..." story to grab our attention. You can use this knowledge. When you're trying to convince your boss to increase security/tune a query/upgrade a server/whatever, find a story, preferably a true one, that helps to set the scene. You'll find that you can be much more persuasive if you can engage the people you're trying to sway. A story will help to engage them.

Grant Fritchey

Join the debate, and respond to the editorial on the forums

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

Reusing Query Results in SSMS

Every time you need to reuse the query results from SSMS, for example to populate another table, or to search for matching rows in another table, it will inevitably mean a lot of manual tweaking to the get the results into the right format. Louis Davidson uncovers three SQL Prompt gems that can remove all this pain.

What is the state of Database DevOps in 2021?

The latest State of Database DevOps report has been published and it’s packed with data from over 3000 IT professionals. You’ll learn about the latest DevOps trends, industry insights, and tips from contributors such as Pramod Sadalage and Kendra Little. Get your free copy

AI/Machine Learning/Cognitive Services

How do we practice responsible AI?

A key component to make sure that we develop respo...

Meet the AI algorithms that judge how beautiful you are

I first came across Qoves Studio through its popul...

Administration of SQL Server

Disabling Non-Clustered Indexes For Fun and Profit

One of the frequently quoted ETL best practices is...

The Logging Costs of DROP TABLE and TRUNCATE

Paul Randal explains that DROP TABLE and TRUNCATE ...

Which configuration changes in SQL Server require a restart?

SQL Server is a complex beast, with many configura...

Understanding DROP TABLE Statement in SQL Server

Total: 0 Average: 0The SQL Server DROP TABLE state...

Translating Index/Key Errors from Graph Tables in SQL Server

As I am working with graph tables, I find some qui...

Conferences, Classes, Events, and Webinars

Catch-up on Redgate Summit

Did you miss the excellent presentations from DevOps experts Pramod Sadalage, Kellyn Pot’Vin Gorman, Samir Behara, and Kendra Little? Good news – all Redgate Summit sessions are available on-demand now. Choose from ‘the future of database DevOps’ keynote, latest DevOps trends, Q&A discussion, and demos.

Data Mining / Data Analysis

Data-driven humanitarianism

It’s one of the most beautiful places on Earth, ...

Cloud-native solutions are solving today’s forecasting and planning challenges

Thanks to COVID-19, companies have experienced how...

Data Science

Why Data Democratization Is Critical to a Successful Data Strategy

Click to learn more about author Mathias Golombek....

DevOps and Continuous Delivery (CI/CD)

A New Git Default Branch

I learned a new trick from Andrew Pruski. In a blo...

Using Flyway Output in PowerShell

How to send Flyway logging and error output to JSO...

How SQL Server synonyms help database DevOps

Synonyms inside SQL Server are one of those useful...

Microsoft News

Microsoft Ignite Announcements 2021

Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and... The...

Performance Tuning SQL Server

Parameter Sniffing or not sniffing: The Mindset change for new technologies

Parameter sniffing is a common challenge for query...

Queries Go Faster When They Don’t Touch Disk

A Rears GitHub scripts Thanks for watching! The po...

PostgreSQL

HOW CAN SQL SERVER DEVELOPERS GET STARTED WITH POSTGRE SQL?

WHAT IS SQL SERVER? SQL server is a relational dat...

PowerPivot/PowerQuery/PowerBI

Power BI Design Tip: Disable the Auto-Detect Relationship

Relationships are the heart of Power BI modeling, ...

Day of Year and Day of Quarter – DAX calculations for Power BI

Power BI has some built-in, easy-to-use DAX functi...

Product Reviews and Articles

Chairs Technica: We review two new models from Anda Seat

We liked the Anda Fnatic so much, we're reviewing two new models as well.

Product Upgrades and Releases

Hotfix: JDBC Driver 9.2.1 for SQL Server Released

We recently released an update to Microsoft JDBC Driver for SQL Server, version 9.2.1. The update addresses an issue with the new Azure Service Principal authentication option.

SQL

SQL Server authentication methods, logins, and database users

Understanding SQL Server security is a critical skill. Greg Larsen explains SQL Server authentication methods, logins, and database users in this article.

SQL Server Security and Auditing

I’ve an allergic reaction to SQL Injections

A few days ago I posted about looking at GitHub pr...

Security News and Issues

Rookie coding mistake prior to Gab hack came from site’s CTO

Site executive introduces, then removes, insecure ...

Microsoft issues emergency patches for 4 exploited 0-days in Exchange

Attacks are limited for now but may ramp up as oth...

Software Development

A data transformation problem in SQL and Scala: Dovetailing declarative solutions

This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a SQL execution plan for software design.

Tech News

Archaeologists discover “Lamborghini” of chariots near ruins of Pompeii

The ornately decorated pilentum was likely used fo...

Shadow IT: Not a Problem or Worse Than Ever?

Click to learn more about author Jay Chapel. Shado...

SpaceX’s Starship has finally stuck the landing on its third high-altitude flight

On March 3, SpaceX’s Starship pulled off a succe...

On choosing names for new technologies

A name is important. The right name is important. ...

 
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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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