We are reaching out to all people that enjoyed SQL Saturday in LA 2017, 2018, 2019, and 2020 events to let you know that the 2021 event is fast approaching. Only 30+ days remain until the June 12 Virtual Data.SQL.Saturday.LA event. Please register soon to reserve your spot by using http://2021sqlsatla.eventbrite.com/ hyperlink, register using a form below or just use a QR code.
2021-05-12 (first published: 2021-05-05)
Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the desired rows and changes them while synchronously writing to the transaction log […]
2021-05-10
2,497 reads
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.
2021-05-10
In this tip we look at the Sequence Number feature in SQL Server and compare it to the use of identity columns.
2021-05-10
As SQL developers, we tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar and table valued functions, and analyzing query plans (among other things). But sometimes going back to the spec and applying some properties of elementary math can be the best way to begin to improve performance of SQL queries which implement mathematical formulas. This article is a case study of how I used this technique to optimize my SQL implementation of the Inverse Simpson Index.
2021-05-07 (first published: 2019-09-12)
4,706 reads
With both personal experience and the real world evidence to back it up, Grant Fritchey says, unequivocally, a well-implemented DevOps process helps the organization. But it's not always easy to bridge a siloed organization, and sometimes organizations adopt DevOps for the wrong reasons.
2021-05-07
In this article we cover how to get started with MLflow using Azure Databricks which manages the end-to-end machine learning lifecycle.
2021-05-07
Before you alter a database object, you need to understand what other objects will be affected. This article shows how to generate a simple dependency diagram that reveals both those objects that reference the target object, and those referenced by it, and includes foreign key references, column references and all the other details you need.
2021-05-05
In this article, Chandra Kudumula shows how to use ML.NET to train a model for predicting costs from an insurance dataset.
2021-05-05
In this article, we examine how data changes are made against heaps.
2021-05-03
2,215 reads
For one reason or another data security and encryption has been coming up quite...
By Steve Jones
As we try to get through these strange times in the world, I am...
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
Hello, How can I import a CSV file in SSIS (2016) at the same...
Recently we experienced a sudden surge in disk I/O every twenty minutes or so....
We use group managed service accounts for running the SQL Server 2017/2019 sqlserver.exe processes...
Ask SSC