What does SQL NULL mean and how to handle NULL values
This tip will help you understand what NULL means and different ways to handle NULL values when working with SQL Server data.
Protecting Schools
Schools often lack resources and struggle to protect themselves. An interview shows one district doing well, with some lessons for those of us in other organizations.
How much Space can I expect to recover from a rebuild after dropping a column?
Check how much space you may expect to recover from a rebuild after dropping a column!
Choosing Between the Lakehouse and Warehouse in Microsoft Fabric
Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services of the existing Azure Data Platform – such as Azure Data Factory – with Power BI, while also introducing new services.
Xp_cmdshell Use Cases
Today Steve asks for the ways in which you use xp_cmdshell in your environment.
Prevent Duplicate Records in SQL using Filtered Index
In this article, I share how an SQL Server filtered index solved the problem of preventing duplicates for new rows in a table.
Getting Your DBA Teams Scripts into Git
In this article, you will learn how a team can start to better manage the scripts they use for their daily work.
The Cost of Rework
Steve notes that we're always better doing things better the first time. That takes some effort.
Concepts and Issues in Test Data Generation
Data generation is the science and art of providing data for database development work that is as realistic and controllable as possible. The skills of generating realistic data are an essential part of being a database developer. It is important: you need plenty of data of exactly the right type, size and verisimilitude
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I