SQL Server Archives - Page 64 of 393 - SQL Authority with Pinal Dave

SQL Authority News – Play by Play with Pinal Dave – A Birthday Gift

July 30, 2014

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Today is my birthday. Personal Note When I was young, I was always looking forward to my birthday as on this day, I used to get gifts from everybody. Now when I am getting old on each of my birthday, I have almost same feeling but the direction is different.…

Developer – Cross-Platform: Fact or Fiction?

July 29, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

This is a guest blog post by Jeff McVeigh. Jeff McVeigh is the general manager of Performance Client and Visual Computing within Intel’s Developer Products Division. His team is responsible for the development and delivery of leading software products for performance-centric application developers spanning Android*, Windows*, and OS* X operating…

SQL SERVER – SSMS: Top Queries by CPU and IO

July 29, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Reports, SQL Server Management Studio

Let me start this blog post with a personal story. Personal Story – Dad and I My fascination for computers started way back when I was about to get into highschool. My father once took me to his office (was for some family day if I remember correctly) and it…

SQL SERVER – SSMS: Top Transaction Reports

July 28, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Reports, SQL Server, SQL Server Management Studio

Let us start with a personal story. Personal Story – My Daughter and I My day has its own part of long meetings and my daughter tries to pull a string here and there to get my attention almost every other day. And recently I was made to watch one…

SQL SERVER – Andy Defines Basic RDBMS: Isolation in Processes – Notes from the Field #038

July 24, 2014

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 Authority News – Webinar: SQL Server 2014 In-Memory OLTP and SafePeak In-Memory Caching

July 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

In the past couple of months many of us heard about the new SQL Server 2014 and its In-Memory technologies, such as In-Memory OLTP for high-transactional application and the ColumnStore INDEX’s for BI apps. This comes in addition to various in-memory technologies outside of the SQL Server world, such as…

SQL SERVER – Finding Object Dependencies in SSMS – SQL in Sixty Seconds #071

July 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

SQL Server Management Studio

While we are doing development, we create and drop objects. We build new things and we need to understand the relationships between database objects when we are doing various activities in SQL Server. Well, it is indeed very hard to know all, the relationship between various objects in SQL Server.…