Profile cover photo
Profile photo
Patrick Keisler
125 followers
125 followers
About
Posts

Post has attachment
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 up on all the details. Are you required to have xp_cmdshell enabled on one of your servers? If so, then setup a SQL Audit now to track its u...
Add a comment...

Post has attachment
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. One such occasion happened just recently when I was asked to help find a way to automate the daily checks the DBA had to perform every morning. The result was ...
Add a comment...

Post has attachment
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 received a bit of feedback that it was not working as designed. My apologies for taking so long, but I believe I have come up with a fix. The main issu...
Add a comment...

Post has attachment
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 the entire buffer pool each morning around 8AM. See the error below. Not only was this causing some serious performance issues, but it was also affecti...
Add a comment...

Post has attachment
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 before in Azure, this is a huge leap forward, especially in having more granular control over what audit records a...
Add a comment...

Post has attachment
AzureRM Module Version
When working with the AzureRM PowerShell module, remember the module is constantly being updated to take advantage of new features added to Azure. Continue reading...
Add a comment...

Post has attachment
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 of goals, but none of them involved SQL Server. I really had no idea of where I wanted my career to go other than working in IT. Finally in 2000, I s...
Add a comment...

Post has attachment
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 planned updates from Mike Shepard. The Future of SQLPSX https://powershellstation.com/2016/07/13/the-future-of-sqlpsx/ SQLPSX Update https://pow...
Add a comment...

Post has attachment
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 the new release of SQL Server 2016. This past weekend I attended the  SQL Server 2016 Launch Discovery Day in Raleigh, NC. I have attended several SQL Se...
Add a comment...

Post has attachment
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, State 4, Line 1 The backup set holds a backup of a database other than the existing 'AdventureWorks2012' database. Msg 3013, Level 16, ...
Add a comment...
Wait while more posts are being loaded