SQL Server Sequence Numbers
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
Additional Articles
DevOps as a bludgeon
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
Getting Started with MLflow in Azure Databricks
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
Finding Dependencies in SQL Server Databases using SQL Dependency Tracker
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
Insurance price prediction using Machine Learning (ML.NET)
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
How to Generate Fake Test Data for SQL Server
How to use a SQL random data generator to fill SQL Server tables with realistic test data, to shift left database unit testing, integration testing and performance testing so that it is performed during the early stages of database development.
2021-05-03
SQL Server Memory Usage Query
Check out this SQL Server function that can return memory usage information for a SQL Server instance such as the amount of memory SQL Server is using and available memory on the machine.
2021-05-03
Power BI for Business Intelligence
Power BI is becoming widely used for reporting and data analysis. There are many different versions of Power BI and the features that are offered and this article provides an overview of what is available.
2021-04-30
Running SQL Code Analysis during Flyway Migrations
A set of PowerShell automation script tasks for running database build and migrations tasks. This article describes the SQL code analysis task, which will check the syntax of the SQL code in your databases and your migration scripts for 'code smells'.
2021-04-30
Building a SQL Server data dictionary
In this article, Edward Pollack explains the benefits of a SQL Server data dictionary and how to build one.
2021-04-29
Blogs
A Small LLM Fail
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
Unused Indexes in SQL Server: Find them, vet them, and drop them safely
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
T-SQL Tuesday #191 Round Up
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQL Newbie HELP: The query references an object that is not supported in distr..
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
Are topic notifications working?
This is a topic to test whether reply notifications are working or not.
Question of the Day
Slip Streaming Installs
What does a slipstream installation mean?
See possible answers