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

SQL SERVER – Script: Finding queries without JOIN Predicates

August 26, 2015

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

I have been in developer’s shoes for close to 5+ years before reinventing myself to do things that made me even better in coding. It is a tough challenge these days being a developer. The life around you and the technology is changing so rapidly that we seldom get time…

SQL SERVER – Fix @@ServerName Property Value When Incorrect

August 24, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Function

Our software systems are funny and sometimes give us strange values. I don’t quite venture out trying to fiddle around with system level properties on my servers, but having said that, this query had come from one of my colleagues who was working on his SQL Server instance and he…

SQL Authority News – 100 Million Views and Onwards

August 22, 2015

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Milestone

I will always remember August 20, 2015 as a landmark milestone for SQLAuthority.com. On August 20th, this blog crossed 100 Million Views. When I started this journey on November 1, 2006, I had no idea that there will be over 100 Million Views on this blog. I am indeed very proud…

SQL SERVER – DBCC CHECKDB errors – Msg 2520 during executions

August 21, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Some of the simplest recommendations can lead you to some bizarre output that we never anticipated. I always recommend running DBCC CHECKDB on mission critical databases because we need to be 200% sure that the database disk system is healthy from time to time. During one of my sessions, I…

SQL SERVER – Rewriting Database History – Notes from the Field #094

August 20, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

[Note from Pinal]: This is a 94th episode of Notes from the Field series. When I read the title of this article – I was extremely intrigued with it – Rewriting Database History! When I was a kid, history was my favorite subject and till today when I have to deal…

SQL SERVER – How to Migrate Existing Database to Contained Databases

August 18, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Most of the queries that land into my inbox are based on something I have already written or something people want to explore more on. When it comes to learning and exploring the skills, there is no better way compared to people asking me some tough questions. This blog is…

SQL SERVER – PowerShell – Knowing SQL Server Information

August 17, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell

If you search this blog, there are a number of PowerShell scripts that I have shared in the recent past. Some of them include: Using PowerShell and Native Client to run queries in SQL Server Identify Disk Latency on SQL Server Box Using PowerShell How to Find Logical and Physical…