May 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check

SQL SERVER – Trivia – Days in a Year

March 21, 2015
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL DateTime
Every time I wrote a blog, I tend to get back to most of them via the search. Most of you ask me questions and I do few simple search back to make sure I am able to address them. Yesterday as I was searching for an interesting question, Now…
Read More

SQL SERVER – Add Node in Cluster – Rule “Node and cluster edition match” failed

March 20, 2015
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Every day I get many emails and blog comment with at least one new problem every day. Recently, one of my blog readers sent an email asking assistance. She already had two node Windows Cluster. Let us call them Node1 and Node2. SQL Server Clustered instance, was successfully installed on…
Read More

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

March 19, 2015
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
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…
Read More

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…
Read More

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…
Read More

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…
Read More

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…
Read More
Previous 1 … 136 137 138 139 140 141 142 … 536 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version