SQL Server on Linux – new command line tools.

Posted: May 28, 2017 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2017, SQL Server on Linux, Uncategorized | Tags: , | Leave a comment

I have been playing with the new SQL Server on Linux command line tools

http://smooth1.co.uk/sqlserver2017/LINUX_CMD_TOOLS.html

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.

 

SQL Server on Linux – SQL Server 2017 goes cross platform!

Posted: May 23, 2017 | Author: | Filed under: Linux, Microsoft SQL Server, SQL Server on Linux, Uncategorized | Tags: , | Leave a comment

Here are the slides for my recent talks on SQL Server on Linux – SQL Server 2017 goes cross platform!

http://smooth1.co.uk/presents/201705_SSOL/201705_SSOL.zip

SQL Server – Changing Recovery Model from Full to Bulk Logged whilst a Tranasction is active.

Posted: May 10, 2017 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2016, Uncategorized | Tags: , , | Leave a comment

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.

http://smooth1.co.uk/sqlserver2016/RM_BL_ML.html

SQL Server 2016 – Database Scoped Configuration Parameters and Always On Availability Group failovers.

Posted: May 10, 2017 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2016, Uncategorized | Tags: , , | Leave a comment

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 ?

http://smooth1.co.uk/sqlserver2016/AA_AG_DSP.html

SQL Server – checking for Instant File Initialization Permissions

Posted: May 9, 2017 | Author: | Filed under: Microsoft SQL Server, Uncategorized | Tags: | Leave a comment

To check for Instant File Initialization Permissions:

 

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.

Setting up password-less ssh on CentOS

Posted: April 28, 2017 | Author: | Filed under: Uncategorized | Leave a comment

First set the hostname on both machines:

hostnamectl status

hostnamectl set-hostname newhostname

Add both hostnames to /etc/hosts on both machine

On source machine:

ssh-keygen

ssh-copy-id -i ~/.ssh/id_rsa.pub remote-host

On target machine:

restorecon -Rv ~/.ssh

ssh remote-host

London BI/SQL Server user groups.

Posted: February 20, 2017 | Author: | Filed under: BI and Analysis, Microsoft SQL Server, Uncategorized | Tags: , | Leave a comment

If you are BI based and want to meetup with other in London, whether technical or business based here as some contacts.

https://sqlserverfaq.com/ – General sql server (covers lots of usergroups)

http://sqllondon.pass.org/ – London SQL Pass Chapter for SQL Server but BI people do attend as well.

https://www.meetup.com/London-PUG/ London Power BI Users Group – they meet at Skills Matter, 10 South Place near Moorgate tube, big group, lots of people attend – 50+,

https://www.meetup.com/London-Business-Analytics-Group/ – London Business Analytics Group – Very power user/Business based, less technical

← Older Entries