SQL Server Essentials for beginners
SQL is the essential part of SQL Administration and SQL Development. A quick overview of basics can take you a...
2018-12-10
246 reads
Data Warehousing Tip #1 – Store fact data at the leaf level
My first data warehousing tip is to store fact data at the leaf level. If you aggregate your fact data...
2018-12-10
326 reads
Privacy and Protection in the Age of the GDPR
We’re seeing more and more GDPR-style laws coming out from various governments. With the GDPR starting to do enforcement at...
2018-12-10
242 reads
Moving SSISDB is not as easy as it sounds
We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016...
2018-12-10
238 reads
The Mystery of Missing Backup Files
Managing database backups is a critical role of the successful DBA. Understanding what the backup plan is and ensuring backups occur on schedule is not always transparent to the...
2018-12-10
7 reads
The Mystery of Missing Backup Files
Yoink – Backups Gone
Not only is this mystery of missing backup files worth discussing now, but has been a mystery worth...
2018-12-10
326 reads
How To Restore Database in SQL Server 2014 From .bak - Step By Step
Due to threats of data loss, human errors, scam attempts, hardware damage, or natural disasters, it is imperative for IT administrators to ensure the security of data. In order...
2018-12-10
47 reads
How To Restore Database in SQL Server 2014 From .bak - Step By Step
Due to threats of data loss, human errors, scam attempts, hardware damage, or natural disasters, it is imperative for IT...
2018-12-10
5,986 reads
Setup Ola Hallengren SQL server Maintenance script
Ola Hallengren Maintenance Plan Deployment Many...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2018-12-10
15 reads
SQL Server Adventures In Reducing IO
In the interests of curiosity I’m going to take a query that runs a relatively simple aggregation over a large...
2018-12-10
302 reads
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