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

SQL SERVER – Convert Seconds to Hour : Minute : Seconds Format

August 17, 2014

Here is another question I received via email. “Hi Pinal, I have a unique requirement. We measure time spent on any webpage in measure of seconds. I recently have to build a report over it and I did few summations based on group of web pages. Now my manager wants…

SQL SERVER – Convert Old Syntax of RAISEERROR to THROW

August 16, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I have been quite a few comments on my Facebook page and here is one of the questions which instantly caught my attention. “We have a legacy application and it has been a long time since we are using SQL Server. Recently we have upgraded to the latest version of…

SQL SERVER – Validating If Date is Last Day of the Year, Month or Day

August 15, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

Here is one more question I recently received in an email- “Pinal, is there any ready made function which will display if the given date is the last day or the year, month or day? For example, if a date is the last day of the Year and last day…

SQL SERVER – Script to Find First Day of Current Month

August 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function

Earlier I wrote a blog post about SQL SERVER – Query to Find First and Last Day of Current Month and it is a very popular post. In this post, I convert the datetime to Varchar and later on use it. However, SQL Expert Michael Usov has made a good…

SQL SERVER – Finding Out What Changed in a Deleted Database – Notes from the Field #041

August 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 41th episode of Notes from the Field series. The real world is full of challenges. When we are reading theory or book, we sometimes do not realize how real world reacts works and that is why we have the series notes from the field,…

SQL Authority News – FalafelCON 2014: 2 days with the Best Developers in the World

August 12, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

I love presenting at various forums on various technologies. I am extremely excited that I got invited to speak at Falafel Conference 2014 in San Francisco. I will present two technology sessions on SQL Server. If you are into web development or if you just want to attend a conference…

SQL SERVER – Integrate Your Data with Skyvia – Cloud ETL Solution

August 12, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Cloud Computing

In our days data integration often becomes a key aspect of business success. For business analysts it’s very important to get integrated data from various sources, such as relational databases, cloud CRMs, etc. to make correct and successful decisions. There are various data integration solutions on market, and today I…

SQL SERVER – Convert Seconds to Hour : Minute : Seconds Format

SQL SERVER – Convert Old Syntax of RAISEERROR to THROW

SQL SERVER – Validating If Date is Last Day of the Year, Month or Day

SQL SERVER – Script to Find First Day of Current Month

SQL SERVER – ​Finding Out What Changed in a Deleted Database – Notes from the Field #041

SQL Authority News – FalafelCON 2014: 2 days with the Best Developers in the World

SQL SERVER – Integrate Your Data with Skyvia – Cloud ETL Solution

SQL SERVER – Finding Out What Changed in a Deleted Database – Notes from the Field #041