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://powershellstation.com/2016/07/31/sqlpsx-update/
Continue reading...Patrick Keisler
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 Server launch events over the years, but this one was quite different. While it wasn’t a real launch event, it was marketed as a hands-on event to learn about the newest release of SQL Server. The hands-on part for everyone to breakup into teams of five to solve a pre-determined problem. Basically, this was...
Continue reading...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, State 1, Line 1 RESTORE DATABASE is terminating abnormally. We could easily avoid this error by using the WITH REPLACE option in the RESTORE DATABASE command, but we want to know why this error occurs and how SQL Server knows they are not from the same family. The answer is the database_guid. The database_guid is a...
Continue reading...Create a Whitelist for SQL Server
UPDATED – May 16, 2017 – Please review the updated code here. 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 by creating a whitelist. So let’s start off by defining “whitelist”. According to the American Heritage Dictionary, it is “a list of people or organizations that have been approved to receive special considerations”. In our example, that “special consideration” is access to the SQL Server only if...
Continue reading...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 internet connection could access your database. Now that’s no cool. So how does Microsoft keep your database safe? The answer is a multipronged approach of using encryption, authentication, authorization, and firewalls. All connections to Azure SQL Database use SSL/TLS to protect your data while “in transit”, and you can use Transparent Data Encryption (TDE) to...
Continue reading...
