Skip to main content

Posts

Showing posts from 2017

SOS - Save Our Souls or SQL Operations Manager

On Wednesday Microsoft Announced the release in preview of SQL Operations Studio (SOS)... What is that I hear you cry! Well I asked myself the same question and did some digging.



SQL Operations Studio a client tool for working with SQL Server... It was announced at the PASS summit last week and it hit public preview on Wednesday.

"ARE THEY GETTING RID OF MANAGEMENT STUDIO?????" I hear you scream, well  that was my initial thought too.

Fear not though, Management Studio is hear to stay, at least for now, according to this interview  in visual studio magazine of Microsoft executive  Rohan Kumar.

https://visualstudiomagazine.com/blogs/data-driver/2017/11/sql-operations-studio.aspx

Q: Will this tool replace SSMS?
A: It is not in our roadmap.

It's not a No. So not necessarily conclusive. "It is not in our roadmap" - I keep adding a "yet" to the end of that sentence. Road-maps do change overtime but I think we can assume that SQL Operations Manager will be aro…

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database?
If you work in a hybrid environment with some databases stored on your on premises SQL Server instances and you also have deployed some databases to Azure SQL Database, maybe you have archived a bunch of data up to the cloud to free some space on your on premises servers but you still want to query that data.  You might want to query the azure SQL Server databases from your on-premises SQL Server instances for a whole bunch of other reasons too. Then you might want to create a Linked Server to your Azure SQL Database

In this short video David talks you through the process of creating a linked server to an Azure SQL databases


You can download the free ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database

If you have any questions, please leave them in the comments

Connecting to an Azure SQL Databases

Connecting to an Azure SQL Databases is pretty simple and straight forward,as long as you know what you need in order to safely and securly establish a connection.

In this short introductory video david shows you what you need to do,such as

Setting firewall rules Finding the connection string needed to connect to your Azure SQL database from SQL Server management Studio. 

It also shows at how to create and configure an Azure SQL database from SSMS.





You can download the free ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database

Feel free to leave a comment if you have any questions

Configuring Azure Data Sync

In this video David demonstrates how to configure Azure Data Sync 2.0 to synchronise an Azure SQL database with an "On premises" SQL server.

As the name suggests the Azure Data Sync tool allows you to synchronise data between Azure SQL databases and other databases both on Premises and in the Azure cloud.

If you are looking to manage a 'hybrid' environment where you have data and on premises data then this might be a useful tool for you.



You can download the free ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database

Any questions feel free to ask them in the comments

Ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database

David is delivering his Microsoft Azure for the SQL DBA talk this weekend in SQL Saturday Denmark. Go and see him if you attending the event - you can find his session in the schedule

David has updated his eBook Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database. This is the third edition Its free to download just click the link.



If you have any feedback on the book please do leave a comment below.

Kerberos Explained - Taming the Beast: Kerberos for the SQL Server DBA

David has a talk that he delivers at SQL Saturdays, all about Kerberos authentication.  What it is, how it works and the impact it can have on databases administrators if things sometime go awry with what is needed for it function correctly.

The talk  is called  “Taming the Beast: Kerberos for the SQL Server DBA” if you have ever encountered the Kerberos double hop issue –David’s talk provides a great explanation about the cause – missing or duplicate service principal names (SPNs).  David’s talks explains how Kerberos works and what you need to do to fix any SPN issues.

David introduces a great tool to help the SQL Server DBA work with SPNs. The tool is called Microsoft Kerberos Configuration Manager for SQL Server. This is really useful tool for helping you identify if you have the correct SPNs created. David explains how to use it in his talk.

David records a lot of his SQL Saturday presentations and he has recorded this one too. You can watch it here. When he first the YouTube vid…

New in SQL Server 2017: Graph Databases

David has recorded and published a video of his presentation on SQL Server Graph Database. In his video which you can watch below, David provides an excellent introduction into SQL Server 2017 Graph Databases. In his presentation he looks at Tennis results at tournaments for  his favourite player "The Fed"  Rodger Federer.

David  shows how to set up graph database and work with them in SQL Server 2017.

Graph Database is not new. Other vendors have had graph database capabilities for some time so Microsoft are quite late to the market. In David presentation it appears that Microsoft have done a reasonable job of implementing some of the graph database features but he does point some of the limitations of the Microsoft product too and suggests that it is not ready for production yet but Microsoft seem serious about this feature.

Please watch the video and feel free to leave a comment or feedback - David is delivering a version of this talk on Graph databases in SQL Saturday Ka…

SQL Server Express v SQL Server Developer Edition

SQL Server Express v  SQL Server Developer Edition
Over the weekend I received the following in an email from Ali Ahmad who asked me some questions about learning SQL Server. We exchanged a couple of emails so I have boiled this down to the most salient points.

Question:
Goal: I want to learn SQL Server inside out… for career progression as DBA/BI/data mining. I'm a data analyst and want to learn inside out about data warehousing.
•I understand relational database concepts...
•I have SQL Server 2014 express installed…
•I need to download the adventure works sample in order to play with it.
•So much knowledge on Microsoft website it's easy to get lost… where do I begin?

SQL Server Express v SQL Server Developer
This is interesting. If you want to learn SQL Server inside out including the Business Intelligence suite of applications I would suggest downloading the developer edition of SQL Server which since 2016 has been made available free of charge. Prior to that there was a f…

Video Tutorial: Creating a SQL Server Databases

In this Video tutorial we will look at creating a SQL Server database using both Management Studio and TSQL. We’ll also discuss some of the database options you can set when creating a database. We will look at creating database objects such as tables, indexes and stored procedures in a later video this tutorial focuses on the database itself.



If you have a SQL Server problem that we can help with please check out or SQL Server Consulting Page and do feel free to contact us

SQL Server Management Studio: Video Tutorial

SQL Server Management Studio is the all in one tool for developers and DBAs alike to work with SQL Server. In this short tutorial we look at how you can download install and connect to a SQL Server instance and have a quick look at object explorer and some of the server and database objects you can view and work in Management Studio



If you have a SQL Server problem that we can help with please check out or SQL Server Consulting Page and do feel free to contact us

Installing SQL Server: Video Tutorial

In this video I talk you through installing SQL Server 2017 RC1 on Windows Server 2016 virtual machine. It’s a nice simple process.

If you need help with SQL Server check out our SQL Server Consulting page

Building Always On Availability Groups - Part 1

Introduction By David Postlethwaite
Ensuring that your databases can survive a major outage such as a server failure and can continue to work is an important task of being a DBA.
Database Mirroring was introduced in SQL 2005 and was quite straight forward to setup.
Mirroring only allowed for one secondary server and there was no way of grouping databases to failover together.

In SQL Server 2012 mirroring was replaced with Always On Availability Groups (AOAG). It can have multiple secondary servers and databases could be grouped to failover together along with other feature making it much more resilient and reliable.

SQL Server 2014 increased support for up to eight secondary replicas that are still available for read-only workloads even when the primary has gone down. It also gave support for In-Memory OLTP databases.

SQL 2016 made improvements by allowing failover not just on server failure but optionally also at the database level. So if the server is still running but a database h…

Dynamic Data Masking

By David Postlethwaite

Introduction
Dynamic data masking is a really useful new tool in SQL Server 2016. Keeping data safe is one of the most important tasks that a company has; this goes further than just making sure that users can only see their own data and hackers can’t get access. One case that will be familiar to many is where a copy of production data is required by developers for testing or for production support issues. In this case it is often important that the data is obfuscated so that real personal data is protected. With large data sets running an obfuscation script can take a long time and hold up support or testing. What would be really useful is a way of masking the data without having to run these long obfuscation scripts. Introducing Dynamic Data Masking.
Microsoft has introduced a solution to this in SQL Server 2016 and Azure SQL database called Dynamic Data Masking. With DDM, whenever a SELECT statement is run a mask is placed over the data that is returned so th…