MCSA/MCSE SQL SERVER 2016 Explained

Hey guys,its become apparent that since Microsoft has changed their certification path that there is lots of confusion.   “MCSA: SQL Server 2016”: You need to obtain either of the following certifications: 1. MCSA: SQL 2016 Database Development certification – Exam [70-761], Querying Data with Transact-SQL – Exam [70-762], Developing SQL Databases 2. MCSA: SQL 2016 …

Creating A FileStream Enabled Database

USE master GO EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE; GO EXEC sp_configure 'xp_cmdshell', 1; GO RECONFIGURE; GO EXEC xp_cmdshell 'IF NOT EXIST C:\DemoFileTable MKDIR C:\DemoFileTable'; GO IF EXISTS (SELECT 1 FROM sys.databases WHERE name = 'DemoFileTable') BEGIN ALTER DATABASE DemoFileTable SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DROP DATABASE DemoFileTable; END; CREATE DATABASE DemoFileTable WITH …

ServiceBusQueues – A simple demo to show how you can send and receive messages to the Windows Azure Service Bus.

Start by creating a console application. Next reference the nuget package for Windows Azure ServiceBus. AppIf you are using Visual Studio 2012 then you will use the quick find dialog box at the top right corner of your ide and look for Package Manager Console. App.Config <!-- Service Bus specific app setings for messaging connections …

AzureUploadApp- A simple app to upload pics to an Azure Storage Account.

If you are new to Azure and haven't created an account before i have covered the steps in a previous post.Creating an azure account.  You start by creating a windows console application. Give it a name of AzureUploadApp. Next create a storage account and copy the key.As you can see from the navigation ,i first …