Nov 12, 2018 | DB Executor, Free Training, SQL Server 101 |
A long long time ago, I wrote a blog post showing how to create db_executor role in SQL Server. There is a reader and a writer role but no execute role. So if you wanted a role that allowed you grant execute to all stored procedures and functions in a SQL Server...
Aug 1, 2017 | SQL Server, SQL Server 101, SQL Server 2017 |
SQL Server Express v SQL Server Developer EditionOver 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...
Jul 31, 2017 | SQL Server, SQL Server 101 |
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...
Jul 25, 2017 | SQL Server, SQL Server 101, SQL Server 2017, Video Tutorials |
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...
Apr 20, 2017 | SQL Server, SQL Server 101 |
I’ve been playing around with YouTube, making some tutorial videos on SQL Server and it’s been a fun process so far. For my first video I decided to start at the beginning – This video looks at what SQL Server is? Basically what comes under the SQL Server umbrella?...
