SQL Server Audit Recipe – xp_cmdshell
This article assumes you already have a basic understanding of SQL Server Audit, but if not, use this link to catch...
2018-07-17
69 reads
SQL Server Morning Health Checks
Every now and again as a Microsoft PFE, you get a chance to make a big difference for a customer....
2018-01-08 (first published: 2018-01-02)
2,461 reads
Create a Whitelist for SQL Server - UPDATED!!!
A while back, I posted an article about creating a WhiteList for access to SQL Server. Since then I have...
2017-05-16
2,142 reads
Dear McAfee, Why are you destroying my buffer pool?
For the past few months, one my customers had been trying to diagnose an issue with SQL Server paging out...
2017-05-02
994 reads
Blob Auditing for Azure SQL Database
In February 2017, Microsoft announced the general availability of Blob Auditing for Azure SQL Database. While auditing features were available...
2017-04-18
617 reads
AzureRM Module Version
When working with the AzureRM PowerShell module, remember the module is constantly being updated to take advantage of new features...
2017-04-13
345 reads
A Goal of Speaking at PASS Summit
Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty...
2016-09-26
556 reads
SQLPSX is Finally Getting Updated
The most current code is now on Github, with the Codeplex version being depreciated. You can read all about the...
2016-08-16
503 reads
TSQL Tuesday #79 -SQL Server 2016 Launch Discovery Day (aka Hackathon)
The host for T-SQL Tuesday #79 is Michael J. Swart (b|t), and his topic of choice is to write about...
2016-06-14
611 reads
Database Restore Fails with Msg 3154
Have you ever tried to restore over an existing database only to receive the following error message?
Msg 3154, Level 16,...
2016-05-24
631 reads
Blogs
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
Bash: “command not found” in IF statement
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
The First Data Saturday is Tomorrow
By Steve Jones
Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...
Forums
Calling remote powershell script through SQL server agent
I have a powershell script in remote server. When I go to remote server...
Data Privacy Grows in California
Comments posted to this topic are about the item Data Privacy Grows in California
Grant user access to view database only
Hi I need to grant a user access to a DB on the server...
Ask SSC