 | | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
Joining a Community In the last week I've been actively trying to join the PostgreSQL community. It's been an interesting experience. I suspect it's going to stay interesting for a while. As part of what I'm doing, I saw this excellent video from Ryan Booz, talking about joining a new community. It got me to thinking. You have a community at work too. Your teammates, of course, but those people over on the SAN team, the network admins, and those developers, all are part of your community. So the question quickly becomes, like Ryan talks about, what kind of community is it? How are you treating those within the community? What's it like to be a new person in the community? Is it easy to join & understand what's going on? Or, are there all sorts of shibboleths you need to navigate the community (you'll have to look that up, it is a shibboleth after all). We always have to strive to build the kind of community that we want to be involved in. And, it's not easy. However, when you've been involved in a successful community, you see how it helps everyone involved. Clearly, it's worth the effort. 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 |
SQL Prompt's new command palette provides a fast way to navigate the tool's functionality via a single keyboard shortcut: ALT+S. Phil Factor explains how you can use the command palette to find and execute SQL Prompt functionality and common SSMS commands, as well as search for database objects. |
In a total 180° turn, find out which Redgate product Grant Fritchey wanted to get rid of a few years ago, why he changed his mind and why it's now one of the reasons he is so proud to work at Redgate! |
In case you missed it: How to extend the range of SQL code analysis, during database development, to include dynamic analysis of the database metadata. This will allow regular checks for problems with the design of your tables and indexes ("table smells") that can affect database performance and data integrity. |
| AI/Machine Learning/Cognitive Services |
Artificial intelligence will shape so much across ... |
This is part five in a series on getting beyond th... |
The waves of disruption just keep coming. Retailer... |
In the field of machine learning, regression algor... |
| Administration of SQL Server |
Moved from: bobsql.com SNITrace, formally BIDT... |
Move from: bobsql.com If you are new to Kubern... |
Move from: bobsql.com I was troubleshooting�... |
Moved from: bobsql.com The Grafana and Kiba... |
Moved from: bobsql.com The dbcc clonedatabase i... |
Moved from: bobsql.com I can’t take credi... |
This is one of those things that when I look back ... |
In this article we look at some of the similaritie... |
This blog post was co-authored by Eric Hudson, Se... |
Some typical corruption scenarios we see: After st... |
So you have a backup for your SQL Server but are y... |
Reading Time: 3 minutes For this months T-SQL Tue... |
As you start to have responsibility for more than ... |
In this article we walk through the steps on how t... |
Azure Data Explorer has a data type called dynamic... |
This article explores the process of table partiti... |
Azure SQL Database has been around for over ten ye... |
Public preview enhancements and updates released f... |
| Azure Synapse (SQL Data Warehouse and Data Lake) |
In today’s post, we will look at the newest Azur... |
This article will focus on the consumption layer o... |
I’ve been slacking. I know. I have not published... |
Code of Conduct for group leaders As event and ... |
It has been over two years since we have had the o... |
| Computing in the Cloud (Azure, Google, AWS) |
Compared to the previous generation, today’s gen... |
Microsoft has announced the public preview of cros... |
In this Data Exposed episode, Aditya Badramraju, P... |
| Conferences, Classes, Events, and Webinars |
What is DevOps and what does it mean for you and your organization? Join Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover the what, who, why and how of DevOps. |
Introduction Over the last few articles we’ve be... |
Learn about using variables in PowerShell scripts ... |
| Data Mining / Data Analysis |
In the era of globalized markets, burgeoning inter... |
| DevOps and Continuous Delivery (CI/CD) |
What Is NoOps? From IT Pro - Microsoft Windows Information, Solutions, Tools |
Total NoOps – the idea of attaining fully automa... |
Some companies go too fast when it comes to SaaS, ... |
| DocumentDB/Key-Value/Graph/other NoSQL Databases |
Simple problem with a simple solution. Solution Us... |
| HA/DR/Always On/Clustering |
Creating a disaster recovery and business continui... |
ISEMPTY: Returns true if the specified table or ta... |
ROUND: Rounds a number to a specified number of di... |
This is part four in a series on getting beyond th... |
This is part three in a series on getting beyond t... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
If you have used MySQL before you will know about ... |
We have Extended Events and Profiler in SQL Server... |
The first step when getting started with MySQL is to get it installed and running. In this article, Robert Sheldon explains how to install it on Windows and create the first database and table. |
| Performance Tuning SQL Server |
Move from: bobsql.com I received a question... |
I was really surprised, but also honoured, when I ... |
I needed to add a Unique Constraint today to a tab... |
We’ve always been able to look at statistics wit... |
In this article, we will learn how to create a tab... |
You can perform PostgreSQL backups with the pg_dum... |
This is just a quick note to talk about the future... |
| PowerPivot/PowerQuery/PowerBI |
When should we use Power BI vs Paginated Reports f... |
Struggling getting images in your Power BI Report?... |
In this article learn about how to use the new dia... |
In this article, we will take a walk-through of th... |
Parsing code Parsing R files Parsing markdown fil... |
As companies shift more operations to the cloud, a... |
Password-guessing became last year's weapon of cho... |
Of the four bot marketplaces Cognyte analyzed, the... |
Recent attacks involving so-called "right-to-left ... |
Introduction This month’s T-SQL Tuesday is being... |
Move from: bobsql.com If I would have simply r... |
In this article we take a look at the SQL WHERE cl... |
I haven’t been blogging as much recently as I’... |
After more than 60 years of use, the COBOL program... |
Introduction I admit it. I am a “driver seeker”. That means that I proactively seek out new drivers and firmware updates for the devices that I own. This applies... |
Five Ways Time Makes Unit Tests Flaky I explore di... |
| Virtualization and Containers/Kubernetes |
With containers, you can build once, run anywhere ... |
  | 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. |
|
|
