I have been playing with the new SQL Server on Linux command line tools
Very nice that sql-scripter has an option to limit output to a given SQL Server Version and even better Edition although did find an issue with this option and will be providing feedback to Microsoft.
Here are the slides for my recent talks on SQL Server on Linux – SQL Server 2017 goes cross platform!
If have a SQL Server database and change the Recovery Model from Full to Bulk Logged whilst a transaction is open what happens?
If the ongoing transaction which was started under Recovery Model Full does an operation which can be minimally logged what happens?
Does the operation become minimally logged which then means the VLF is tagged as a minimally logged logfile which then does not allow certain operations e.g. restores from the next log backup with STOPAT.
We test with STOPAT and also use fn_dump_dblog to see exactly what ends up in the log backup and how we can identify minimally logged operations in a log backup file.
SQL Server 2016 – Database Scoped Configuration Parameters and Always On Availability Group failovers.Posted: May 10, 2017
In SQL Server 2016 we have database scoped parameters.
With an AlwaysOn Availability Groups we can have different database scoped parameter values on the primary compare to the secondaries.
How does this work with an Always On Availability Group failover ?
To check for Instant File Initialization Permissions:
- Go to https://gallery.technet.microsoft.com/scriptcenter/Grant-Revoke-Query-user-26e259b0
- Download UserRights.ps1
- Add privilege SeDelegateSessionUserImpersonatePrivilege to the list within the script
- Download http://smooth1.co.uk/powershell/CheckSQLServerUserRights.ps1
NOTE: This script needs to be locally on the machine where you are checking for permissions.
The script assumes the SQL Servers are running under a server where the DisplayName starts with “SQL Server (“, please adapt for your own needs.
From Peter Bradford @scend we have:
#1 We made requests for enhancements (RFEs) public!
#2: DB2 Developer-C! All DB2 features, free for development, a MySQL substitute! Download 6/22
#3: The new “Download & Go” installation experience, available with Developer-C Download 6/2. Download a platform specific binary. Small download, less than 15 minutes to install. Install reduced to 3 clicks and User/Password input only.
#4: We will support DB2 V11 on Solaris Sparc later this year with our V18.104.22.168 release, by 12/15/17 (if not sooner)
#5: New “Continuous Support” offering for customers on DB2 V9.7 and V10.1!
How To and Workaround assistance, no new defect fixes
This still provides existing fixed but no new custom special builds or codes fixed
If you have questions contact
Twitter: @db2support or https://twitter.com/db2_support