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
Blog Posts
SQL Server 2014: AlwaysOn
AlwaysOn was introduced in SQL Server 2012, and there are some enhancements in SQL Server 2014:
Now support up to 8 secondary...
2013-08-15
2,147 reads
Workload Tuning: Finding Top Offenders in SQL Server 2012
I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance...
2013-08-15 (first published: 2013-08-07)
2,576 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
846 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,645 reads
Get the Backup History in your Central Management Server for SQL Server
I have a setup of Central Management Servers in my SQL Server and it’s been a big help to me...
2013-08-14
698 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,535 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,144 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
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
870 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers