Quick tip: WMI alerts and SQL Server Agent permissions.
I came across an issue today while trying to create a WMI alert for a mirroring state change. The error...
2013-08-15
1,601 reads
Join me for the 2013 Biml Workshop
Of the many emerging technologies I’m currently using, there’s nothing that excites me more than Biml. If you’re not familiar...
2013-08-21 (first published: 2013-08-14)
1,259 reads
Configuring BIDS 2008 / 2008 R2 and Visual Studio 2008 to work with Database & Business Intelligence Projects and Team Foundation Server (TFS)
Working with the SSIS, SSAS, and SSRS Business Intelligence projects along with Database projects in the same Visual Studio 2008...
2013-08-14
2,660 reads
It’s the small things that count
Sometimes it’s the small things that count.
I just noticed two small enhancements to SQL Server 2014's BOL, and I can...
2013-08-14
1,536 reads
Setting My Course for Adventure and You Can Too
I’m setting my course for a new adventure, my mind on a new … undertaking. My apologies if you thought this...
2013-08-14
937 reads
PowerShell – Invoke Commands,Batch files & Executable file – Dynamically passing Parameters
I’ve recently got a request to invoke an executable file from Powershell. Different ways of executing a executable file is given...
2013-08-14
1,145 reads
Social Media as News (and why it thrills me)
The other day I found myself in a discussion about media – print, broadcast, and social – and having to explain why...
2013-08-14
872 reads
Be The Connector
Few things are more satisfying than to introduce two people when you think they have common interests. Often it’s driven...
2013-08-14
847 reads
sp_DBPermissions
Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last...
2013-08-14
1,516 reads
Whitepaper: Building Self-Service BI Solutions with Power Query
Through Self-Service BI, business units can personalize Business Intelligence to their needs and solve problems at a much faster rate...
2013-08-14
1,066 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers