Trigger Happy
This article looks at using triggers to audit and to prevent the performing of unintended actions.
Finding & Fixing Statistics Without Histograms
Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.
Collecting Data with Elastic Database Jobs in SQL Azure
In this tip we look at how to collect data for Elastic Database Jobs and easily store the data in a central location for analysis and review.
Fifty Different Ways to Enact Data Privacy Laws?
Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer explains the history of the law, what it means for companies doing business with California residents, and how it compares to the GDPR.
Normal Data
More and more people are starting to perform data analysis, including DBAs, but they should be aware of what normal means for data.
Get SQL Server Row Count and Space Used with the sp_rows
Check out this stored procedure sp_rows to get a listing of space used and rows counts for your SQL Server database tables.
Single Source of Truth
Andy Warren talks about the single source of truth for information. It could be the database, but that's not always the best choice.
SSIS Basics: Bulk-Import various text files into a table
For this post I will show you how to bulk insert multiple files in a folder to a SQL Server database, regardless the file name or extension, this with the help of the ForEach Loop Container.
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