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

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

Post has attachment
A New Achievement
To celebrate a recent achievement, I have decided to create a whole new section to my blog that will be dedicated to the subject. Please follow the link to learn more. Continue reading...

Post has attachment
Speaking at SQL Saturday #452 - Charlotte, NC - October 17
In case you missed it last week, there will be another SQL Saturday this weekend in Charlotte, NC. If you are in the area, please come out to this free training event to hear a bunch of great professionals talk about SQL Server. You can register for the eve...

Post has attachment
Speaking at SQL Saturday #445 - Raleigh, NC - October 10
I will be speaking this weekend at SQL Saturday #445 - Raleigh, NC. If you are in the area, please come out to this free training event to hear a bunch of great professionals talk about SQL Server. You can register for the event here:  http://www.sqlsaturda...

Post has attachment
PSSDiag Configuration Manager – A Companion for SQLNexus
Have you ever called Microsoft Customer Support for help with a SQL Server performance issue? The engineer will typically send you a self-extracting exe file with instructions to unzip the file on the server and run the pssdiag.cmd file to collect data whil...
Wait while more posts are being loaded