|
| Editorial |
| Confidence Today, I want to blog about something I have only limited knowledge of … confidence. Okay, I understand what confidence is, and I have seen it before in the real world and not just in biographical movies. In fact, I have met quite a few highly confident people. In almost every case, it was immediately evident because each of these people had this unmistakable aura about them. You could see on their face they knew what they knew, they knew what they wanted, and they generally believed that they could do anything. (Assume I mean this only positively, just for the sake of this editorial!) When I think of extremely confident people, I think of Walt Disney. October 16, 2023 is the 100th anniversary of Walt and Roy founding their Disney Brothers Studios. For many years, they failed big. But they kept at it through thick and thin and built an empire. Were they always confident they would make it huge? Who knows, but they didn't give up, and you know how it turned out. But let's be reasonable; I am not suggesting that every DBA/Data Programmer needs to have the confidence of the Disney Brothers or Steve Jobs and Steve Wozniak when starting Apple. Personally, I am absolutely not that confident personally. I'm confident with my technical skills and I know SQL Server and relational databases very well. But I question those skills every time I use them. You want to know how works? I am very sure I know but let me verify that. Many people reading this blog likely feel the same way as I do. I have found that a lack of confidence can be an incredible driver in your life to push you to build up confidence by building competency. At the very least, if you lack confidence but don't lack drive, you are likely to make sure you are right before you say or do things. Too often, in a crisis (which most DBAs know a thing or two about), a very confident person rushes headlong into a substandard solution because they believe it to be right. A person with average confidence levels tends to make sure of any solution first. This often saves a lot more time than cleaning up a mess. I admit to always testing out the concepts I believe to be true, no matter how confident I am that I know what I am talking about. Just because you don't have the confidence to go out on your own and start a movie studio, major consulting firm, or whatever should not get in your way of being confident in your ability to do great things!
Louis Davidson (@drsql) |
|
| 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 |
There is no escaping the excitement and potential ... |
| Conferences, Classes, Events, and Webinars |
We recently rounded up the top Cloud and the top P... |
| Data Privacy, Compliance, and Governance |
With data powering just about every modern business, the saying “garbage in, garbage out” is more relevant today than it’s ever been. Any data-based application, whether it’s a simple... |
| ETL/SSIS/Azure Data Factory/Biml |
In this article, learn about the evolutionary jour... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
When I started looking into using the data warehou... |
Reading Time: 3 minutes In this post I want to sh... |
Microsoft Fabric is a complete set of technologies that provide Analytics as a service. Fabric uses a logical storage layer named OneLake. In this article, we will explore what... |
You may be aware that the ALTER TABLE T-SQL command is currently not supported when working with data warehouses in Fabric. This isn’t much of a problem if the... |
This guide will walk you through the process of cr... |
| Performance Tuning SQL Server |
(SQL DM) provides superior monitoring capabilities... |
Or perhaps another way to phrase that is, Microsof... |
Takeaway: If you want to extract rows from a table periodically as part of an ETL operation and if you use Read Committed Snapshot Isolation (RCSI), be very careful... |
Introduction These are my SQL Server Diagnostic Information Queries for October 2023, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration... |
|
| PowerPivot/PowerQuery/PowerBI |
All of your analytics in Power BI are done with me... |
Ever built a table containing measures in Power BI, done a quick sanity check on your table totals and noticed they’re incorrect? Let’s explore why this may be. Here... |
| Professional Development |
Here's how IT engineers must adapt to the changes ... |
While studies show that women currently hold abou... |
Squash negative stereotypes associated with your a... |
| Security News and Issues |
Microsoft’s security experts have recently disco... |
The rapid growth of APIs creates a widening attack surface and increasing unknown cybersecurity risks. |
| T-SQL and Query Languages |
While this article is specifically geared to SQL S... |
As seen in the previous section, there are several... |
Let us learn The Intricacies of T-SQL String Comparison. In SQL, the way you compare strings can greatly impact the results of your queries. First appeared on The Intricacies of... |
Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part 2. This week in this article Common Mistakes in SQL Server - Part 3 I... The... |
| Theory and Design |
Itzik Ben-Gan lays out some fundamentals: When peo... |
THE VIDEO THE SYNOPSIS In this video, we learn wha... |
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 No 6; June 1970). Some more work followed up after that by... |
| Tools for Dev (SSMS, ADS, VS, etc.) |
In this SQL Server Management Studio tutorial (SSM... |
You may find that you need to connect remotely to ... |
|
webmaster@sqlservercentral.com
