SQL Tips and Tricks Archives - Page 123 of 536 - SQL Authority with Pinal Dave

SQL SERVER – FIX – Property IsLocked is Not Available for Login

July 24, 2015

I play and experiment with SQL Server to the max. Sometimes I am not sure what I did and I land into something undesired. Then the reason to troubleshoot starts and I get to learn something new. Sometimes these learnings are based on error messages that you folks send me.…

SQL SERVER – What are T-SQL Median? – Notes from the Field #090

July 23, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Function

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about T-SQL Median. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I love SQL Server because her writing has instigated love for this technology…

SQL SERVER – FIX – Server principal ‘Login Name’ has granted one or more permission(s). Revoke the permission(s) before dropping the server principal

July 21, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server Security

There are parts of SQL Server where I always like to take expert advice. Sometimes a quick call to a friend can save you tons of time. When I see topics around AlwaysOn, though I know what the basic steps are to building and working with AlwaysOn, the hardcore troubleshooting…

SQL SERVER – Fix – Error: Msg 468, Level 16, State 9, Line 1

July 20, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Ever since I have started writing about Error Messages a number of you ping me from time to time to understand why you are getting an error. As I always say, Error messages are a great way to learn concepts and we become better if we understand the reason behind…

Interview Question of the Week #028 – Few SQL Best Practices

July 19, 2015

Pinal Dave

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

Best Practices

Just last week, I moderated a SQL Server interview and I heard very interesting conversation. Question – What are the best practices are you following for SQL Server? When I heard this question – I thought candidate will answer many different things, but he was stunned and had nothing much to…

PowerShell: How to Find Logical and Physical Processors on SQL Server?

July 18, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell

Working on PowerShell scripts have been an interesting journey. I have written a couple of posts before on using WMI events. Was pondering on this thought and this blog is inspired by combining using of WMI with PowerShell. So what are we trying to solve? When SQL Server changed its…

SQL SERVER – Puzzle – DISTINCT Values in NVARCHAR

July 17, 2015

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

The technique used in this blog is explained in earlier blog SQL SERVER – Creating Dataset Using VALUES Clause Without Creating Table. To read more about Collation and Unicode refer to MSDN. This topic in general is very deep and complicated sometimes that you get to learn something every single…