Get All Database Snapshots and Their Parent Databases On A SQL Server
This is going to be a quick post but this morning I was asked the question, ‘how can I get the name of all the database snapshots on a...
2019-08-15
220 reads
Using Azure Automation to Shut Down a VM only if a SQL Agent Job is Not Running.
I have a client who uses MDS (Master Data Services) and SSIS (Integration Services) in an Azure VM. Since we only need to execute the SQL Agent job that...
2019-08-27 (first published: 2019-08-15)
250 reads
Jenkins in a Container
One of the things I needed to do recently was get Jenkins running as a demo for a customer. We have some pre-built VMs to do this, but I...
2019-08-26 (first published: 2019-08-14)
499 reads
Power BI Monthly Digest – August 2019
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI
2019-08-14
146 reads
Big fall conference – PASS Summit schedule is up!
PASS Summit 2019 now has a schedule and learning tracks, and a letter to convince your boss you should go!
The post Big fall conference – PASS Summit schedule is...
2019-08-14
61 reads
Power BI, Dataflows, CDM, and Dynamics 365 – My Journey
My company, Pragmatic Works, is working through a Dynamics 365 migration. As part of that migration, we need reports. We have made the decision, seemingly obvious given who we...
2019-08-14
132 reads
How to really store a password in a database
Recently I wrote: Don’t store passwords in a database. I stand by this statement. I expected a lot of flak because I didn’t explain myself. This post goes into...
2019-08-14
304 reads
SQL Server Management Studio is as Relevant as Ever
After almost fifteen years of heavy usage by developers and database administrators (DBAs), it might seem like Microsoft’s free tool, SQL Server Management Studio (SSMS), is about to go...
2019-08-14
27 reads
See you Saturday in Baton Rouge!
See you in Baton Rouge this weekend! We have 13 tracks of professional development and training, from entry-level to expert, for SQL Server Administrators, Business Intelligence Developers, Data Analysts,...
2019-08-14
30 reads
Allow SQL Server Agent jobs management for non sysadmins
I don’t know about your experience when it comes to SQL Server Agent jobs but often I receive requests to grant permission so that clients can handle their jobs...
2019-08-22 (first published: 2019-08-13)
4,006 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
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models