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

SQL SERVER – Starting / Stopping SQL Server Agent Services using PowerShell

January 15, 2016

Writing utility scripts are one way to become smarter when working with computers. From time to time I get asked about some tasks folks use repetitively and are being counterproductive. On this note, I wanted to paint a scenario which I saw one of the DBA’s doing on their environment…

SQL SERVER – Live Query Statistics in 2016 … and More! – Notes from the Field #111

January 14, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Function, SQL Server

[Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell explains about Live Query Statistics in SQL Server 2016. Statistics are heart of SQL Server. They play a very powerful role when SQL Server Engine needs help to build a new execution plan for a query. In earlier version of SQL Server we had the only privilege to see statistics after the query is executed. However, with the advancement of SQL Server 2016, the scenario has been changed. Here is a very interesting new feature of SQL Server 2016 which can help every performance tuning expert. Read the experience of Mike in his own words.

SQL SERVER – System.IO.FileNotFoundException: Could not load file or assembly

January 13, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

In a recent R&D operation, I was trying to use some SQLCLR assembly as part of the installation process. It was not easy but it got me into a mess that I thought was worth debugging. One of the interesting issues which I faced recently was to deploy a .net…

SQL SERVER – Working with Event Viewer and PowerShell

January 11, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell

Sometimes I go into these simple explorations that make me learn something new that gets me off the routine. SQL Server is always on the agenda and that passion will never die. This exploration was based on the fact when I was talking to someone about some of the super…

Interview Question of the Week #053 – What is the Difference Between Deterministic Functions and Nondeterministic Functions?

January 10, 2016

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Function

Some questions are so theoretical that I believe they really do not add too much value if users know that question or not. Here is one such question I am very confident that you agree with my point of view. Questions: What is the Difference Between Deterministic Functions and Nondeterministic Functions?…

It’s a New Year, Take Advantage of It – Notes from the Field #110

January 7, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Milestone

[Note from Pinal]: This is the first episode of Notes from the Field series in the year 2016 and 110th overall. There is one place where I see the maximum crowd in the new year – fitness center (gym). It is indeed a good thing that we all want to…

SQL SERVER – Monitoring and Troubleshooting SQL Server Got Easy with Diagnostics Tool

January 6, 2016

Pinal Dave

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

Idera

Blogging has never been an easy task. With close to 9 years of non-stop learning and sharing has got me into a rhythm that I rarely miss a single day without writing one. Over these years, there is one topic area that gets most number of hits based on subject.…