| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| What Counts For a DBA: Manners When most people were young, they had someone telling them to "Mind your manners." Such classics as: "Keep your elbows off of the table," "Use a fork," "Put on deodorant," as well as "Don't chew with your mouth open" were bandied about like there were laws of nature. However, manners differ significantly from laws in one crucial way: manners are optional. Laws have to be followed, or there are consequences. Drive too fast, and lose your right to drive. Jump off a building, and the law of gravity will teach you a lesson. Conversely, manners are there to help you get along with others. You won't die a horrible, toothless death if you eat your dinner smelling of the day's work with your elbows dug into the table, scooping creamed corn up with your hands into your mouth that you don't close for an entire dinner party (quite an image, right?). You will, however, probably only share one meal with your host. Manners are those things that are instilled in us as soon as possible in life for us to get along with society. Interestingly, as a computer scientist, it will turn out that manners play a far more significant role in our work than laws ever will. The compiler will generally enforce laws, giving you error messages like every SQL Server programmer's favorite "syntax error near 'a'." For the DBA/SQL programmer, we have patterns of development based on engine suitability and working well with other human programmers. The following items all fall under manners, and if you have never seen a seemingly successful database that doesn't mind its manners, then you have led a very sheltered life. Following known database design patterns - No matter the RDBMS you choose, they share a common design pattern set called Normalization that will make life easier when working with data. Other database types have their own patterns. Managing concurrent and isolated execution - it is quite rude to overwrite someone else's data just because you can. Well-mannered programmers make sure their operations are never lossy unless they can be. Formatting code - Most programming languages let you format your code in any way you want, even all on one line. We don't do this because we have the manners not to. Reducing super complex code - Getting carried away as a programmer and trying to be clever is far too easy. Code needs to be only as complicated as it needs to be. Too often, people who think they are clever write code that they can't read 10 minutes later. I know I have! Writing reasonable comments - No one likes to write comments, but good programmers realize they are love notes to the next person to touch the code. Often yourself. So mind your p's and q's, and work like you are not alone. Someone else may want to work with your database creation and don't leave them a mess. Especially when that next person turns out to be you. Louis Davidson (@drsql) 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. |
| AI/Machine Learning/Cognitive Services |
| This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. AI language models are rife with different... |
| Administration of SQL Server |
| On August 10, 2023, Microsoft released SQL Server ... |
| Microsoft has officially supported running SQL Ser... |
| In this blog post, I'll share a real-life success story of how instance hiding significantly strengthened SQL Server security for one of my clients. First appeared on SQL SERVER –... |
| Reading Time: 6 minutes In this post I want to cover how you can prepare Azure DevOps for Microsoft Fabric Git integration. To help you avoid any issues.... |
| Azure Premium SSD v2 Disk Storage is now available in more regions and offers the most advanced general-purpose block storage solution with the best price performance. |
| We have several cases where our customers are looking for ways to stop an Azure SQL Database. Some common scenarios where our customers request this option are when they... |
| Computing in the Cloud (Azure, Google, AWS) |
| Cloud technology has revolutionized how businesses operate, offering scalable, flexible, and cost-effective solutions to everyday tasks. And further progress is on the horizon – by 2024, Gartner estimates the cloud... |
| Maximize savings from the start by following these strategies for cost-effective cloud migration and management. |
| Conferences, Classes, Events, and Webinars |
| The start of learning at the 2023 PASS Data Commun... |
| ETL/SSIS/Azure Data Factory/Biml |
| We’ve all generally heard that data quality issues can be catastrophic. But what does that look like for data teams, in terms of dollars and cents? And who is... |
| The database landscape is constantly evolving, from migrating to the cloud to introducing continuous delivery with DevOps, and from incorporating Platform Engineering approaches to using Generative AI. The pace... |
| I have been answering some questions on the Power BI (Or is it now Fabric?) community forum, and I have found recently that there are some people asking how... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
| Copy Activity is one of the most commonly used activities in Microsoft Fabric’s Data Factory Pipeline. The Copy Activity copies the data from a source to a destination. However,... |
| Data lakes typically have three layers: raw, cleaned, and presentation (also called bronze, silver, and gold if using the medallion architecture popularized by Databricks). I talk about this is... The... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| In the last blog (When PostgreSQL Parameter Tuning... |
| Performance Tuning SQL Server |
| Introduction These are my SQL Server Diagnostic In... |
| In the world of database management, achieving optimal query performance is a crucial goal.As data volumes grow and applications become more complex, understanding how queries are executed and optimized... |
| PowerPivot/PowerQuery/PowerBI |
| Lately, I’ve been having to create items in Powe... |
| In this article, I will demonstrate how you can tu... |
| Workplace wellbeing needs a reboot to cope with th... |
| Reading Time: 3 minutes For this months T-SQL Tuesday contribution I want to share why I think database job titles are in the eye of the beholder. At... |
| My dear friend Josephine Bush a.k.a HelloSQLKitty hosts this month’s T-SQL Tuesday. Josephine’s call to us is to share our understanding of the multitude of job titles available out... |
| It’s another T-SQL Tuesday! This month, Josephine Bush (b | t) hosts our T-SQL Tuesday discussion. Her invitation is about the data platform job titles. I wrote a post... |
| While my family and friends know what I do, I’m not sure how well they know “what I do.” While I can explain the details, for those with little... |
| This T-SQL Tuesday is from a new host, Josephine Bush, leader of the Boulder group just North of me. It’s an interesting invitation, asking what our job titles really... The... |
| Microsoft has released today the August 2023 Patch Tuesday updates for Windows 11 and Windows 10. This month, Microsoft fixed 86 vulnerabilities in Windows, Office, and other components, and... |
| (The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something... |
| T-SQL and Query Languages |
| In this article, we look at how to use T-SQL to perform statistical calculations on data within SQL Server tables, specifically using stock data for the examples. |
| Learn to use logical operators when writing SQL co... |
| Fun With KQL Windowing Functions - Row_Rank_Min |
| I had a client ask about how to deal with encrypted stored procedures in their database. This post looks at how to find them and I’ll have future posts... The... |
| Microsoft has announced the public preview of its Windows 365 Switch service. The new offering allows users to switch between their Windows 365 Cloud PC and physical device on... |
| In this article, we are going to learn the basics ... |
| I can't tell you how many times lately, that I've ... |
| aubadoir – n. the outworldly atmosphere just bef... |
| This email has been sent to newsletter@newslettercollector.com. 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. |
|
|
