Notes from the Field Archives - Page 10 of 20 - SQL Authority with Pinal Dave

SQL SERVER – Adding a Master Data Services to your Enterprise – Notes from the Field #072

March 19, 2015

BIML, Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 72th episode of Notes from the Field series. Master Data Services is one of the most important but very little explored feature of SQL Server. If you have been reading this blog, when it is about BI, I always take help from LinchPin People who are BI…

SQL SERVER – The Basics of the File System Task, Part 1 – Notes from the Field #071

March 12, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. Every time I give an introductory note, however, this time there is no need of intro note. This note is from Andy and as we all know he is amazing person when we have to understand the fundamentals. He…

SQL SERVER – Using Raw Files in SSIS – Notes from the Field #070

March 5, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SSIS

[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Using Raw Files in SSIS. Linchpin People are database coaches and wellness experts for a data driven world. In this 70th episode…

Hey DBA – Protecting a Proactive Attitude – Notes from the Field #069

February 26, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

[Note from Pinal]: This is a 69th episode of Notes from the Field series. Mike Walsh is an amazing person to meet and know. I am fortunate to be his friend. Every single time I meet him, I learn something as a human. He is always looking for an opportunity…

SQL SERVER – Finding Top Offenders in SQL Server 2012 – Notes from the Field #068

February 19, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Azure, SQL Backup and Restore

[Note from Pinal]: This is a 68th episode of Notes from the Fields series. Performance tuning gets easier with SQL Server 2012. For the first time, you can capture a workload and find your top offenders inside of Management Studio without having to write a single line of T-SQL or…

SQL SERVER – The Basics of the Execute Package Task – Notes from the Field #067

February 12, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. In this episode of the Notes from the…

SQL SERVER – Invoking a Stored Procedure from Azure Mobile Services – Notes from the Field #066

February 5, 2015

Pinal Dave

SQL Tips and Tricks

Notes from the Field, SQL Server, SQL Server Security

[Note from Pinal]: This is a 66th episode of Notes from the Field series. Azure Mobile Services is a very critical aspect and not many people know about it. When I read this article, I find it humorous at points and some of the examples also reminded me of my past experience. If you are in data security, you will have a great time reading these notes, but if you are not, you will still love it.