Profile cover photo
Profile photo
Patrick Keisler
119 followers
119 followers
About
Patrick's posts

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...

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...

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...

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...

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...

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...

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...

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, ...

Post has attachment
Create a Whitelist for SQL Server
In my previous post, Configuring the Azure SQL Database Firewall , I discussed how you can configure the firewall rules to manage access to the SQL Server. Today, I wanted to demonstrate how you can accomplish the same thing with your on-premise SQL Servers...

Post has attachment
Configuring the Azure SQL Database Firewall
Azure SQL Database is a Platform as a Service (PaaS) that provides a relational database for use over the internet. That sounds super cool and easy to use. But wait, there’s one word I’d like to highlight in that first sentence: “internet”. Anyone with an i...
Wait while more posts are being loaded