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

SQL SERVER – Adding a Master Data Services to your Enterprise – Notes from the Field #072

March 19, 2015

BIML, Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 72th episode of Notes from the Field series. Master Data Services is one of the most important but very little explored feature of SQL Server. If you have been reading this blog, when it is about BI, I always take help from LinchPin People who are BI…

SQL SERVER – Backup on mapped drive failing with error – Error 3201, Level 16, State 1

March 18, 2015

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server

We are so used to taking backups and it can sometimes give us new experiences. One of the common messages I see are around taking backups on a share. If you have found this blog while searching for error message then you may want to look at below blogs as well if you are NOT dealing with mapped drive.

SQL SERVER – Marking Filegroup as ReadOnly with SQL Server

March 17, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

My love for writing about ReadOnly databases have pushed me to explore more about this topic. Based on previous blogs, few readers did ask me that they heard about marking filegroups as ReadOnly and they wanted to know how this can be done. This blog post is in continuation to…

SQL SERVER – Interesting Observation with Currency Symbols

March 16, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

The currency symbols like $ and £ are implicitly treated as money value in SQL Server If you run the following code SELECT $ SELECT £ You can see that both of the above statements return the value 0.00 It is also possible to use them in arithmetic calculations SELECT $+5 returns 5.00…

Interview Question of the Week #011 – Script to Convert List to Table and Table to List

March 15, 2015

Pinal Dave

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

Now today’s interview question is really more of daily routine task for many of the developer. 11 years ago, when I went to my very first interview call. My interview was scheduled at 6 PM in one of the very well known corporation. The corporation was known for its first…

SQL SERVER – SCRIPT – SQL Listening on Dynamic Port?

March 14, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

With every release of SQL Server, sometimes I need to revisit some of the old blogs to see how they have enhanced. This learning experience is an ongoing process and the best way I learn is by doing a search on the blog from time to time. Long ago I…

SQL SERVER – Interesting Function AGENT_DATETIME

March 13, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function

One in a while I come across such interesting side of SQL Server that it even surprises me. Just the other day I came across function AGENT_DATETIME. I had never used it before and now I just found usage example of the same. There can be several methods to convert…