SQL Archives - Page 157 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Using the SSIS Term Extraction for Data Exploration – Notes from the Field #046

September 18, 2014

[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 the SSIS Term Extraction for Data Exploration. Linchpin People are database coaches and wellness experts for a data driven world. In…

SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention

September 16, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

In-Memory OLTP, SQL Memory

Yesterday I wrote about SQL SERVER – Beginning In-Memory OLTP with Sample Example. One of the questions I received right after I published a blog post was why do I call stored procedure natively coded stored procedure when the entire code is in T-SQL. Indeed a very good question. The…

SQL SERVER – Beginning In-Memory OLTP with Sample Example

September 15, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

In-Memory OLTP, SQL Memory

In-Memory OLTP is a wonderful new feature introduced in SQL Server 2014. My friend Balmukund Lakhani has written amazing series on A-Z of In-Memory on his blog. All serious learner should study it for deep understanding of the same subject. I will try to cover a few of the concepts…

Google Drive Trick – Google Spreadsheet Formatting Dates to String

September 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, Software Development

I have been using google drive and google spreadsheet for a while. I work with experts around the world and we all use different date format. The biggest confusion which often happens when we are sharing data is a timestamp. For some people it is natural to have dates time…

SQL SERVER – Flushing Transaction Log to Disk for Current Database

September 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I have written quite a while on Delayed Durability and every blog post when I think it will be the last post on this subject, I always get some question in an email and I end up writing a new blog post. Here are a few blog posts which I…

SQL Authority News – Discount Code for for SQL Live! 360 in November

September 12, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I thought you might be interested to know that I’ll be speaking at Live! 360, November 17 – 21 in Orlando, FL. Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. More info: As a speaker,…

Hey DBA – Go Make a Proactive Investment Today! – Notes from the Field #045

September 11, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

[Note from Pinal]: This is a 45th episode of Notes from the Field series. If you know Mike Walsh, he 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. Last time when…