We all know the value of information in our lives. Whether it’s a personal decision or a business initiated one, people need it. But the question is: who is to make the distinction between data and information? We all come across a whole lot of data daily, that may be significant or not. We filter what’s required and forget about the rest. Information is filtered and distilled data. Filtering and distillation can also alter its actual meaning and natural state. Therefore, in this blog we discover some ways to ensure that we’re using business intelligence derived from the right information for making critical management decisions.
SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 4
This is the fourth post in the series of finding previous row and next row value in SELECT Statement. Read all the blog post before continuing reading this blog post for complete idea.
In the very first part I discussed that performance with the help of CTE is very poor and I encouraged users to use LEAD and LAG function of SQL Server 2012. My friend and SQL Server Expert Szymon Wojcik have written a fantastic post about this subject. I encourage everyone to read that blog post. He has demonstrated that with the help of numbers table, we can further improve the performance of the query.
SQL SERVER – UDF, UPDATE and More – Memory Lane – #047
This is the 47th episode of Memory Lane. Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. My favorite blog posts are about UDF and the difference between UPDATE and UPDATE (). Let me know which one of the following is your favorite article from memory lane.
SQL SERVER – Memory Lane – Scrum, SQL Reboot and More – #046
Let me know which one of the following is your favorite article from memory lane. My favorite article is about Scrum and SQL Reboot.
SQL – Solution – Crossword Puzzle Based on Course Building Successful High Traffic Profitable Blog
Earlier this month we were running a contest for solving the crossword based on my Blogging courses – Course 1, Course 2. Here are the details of the contest. The winner of the contest was to win Melting Clock (Do not confuse this as a dummy or not working clock. This looks like melting, but it always shows accurate time and it is perfectly balanced to hang off of any flat surface). Let us see Crossword Puzzle.
SQL SERVER – Online Index Operations, NEWID and More – Memory Lane #042
This is the 42nd edition of Memory Lane weekly series. Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. My favorite article is about Online Index Operations and NEWID. Let me know which one of the following is your favorite article from memory lane.
SQL SERVER – SQL Basics: SQL 2012 Certification Path – Day 10 of 10
This is the 10th post out of my 10 post series of my 10th book – SQL Basics. Today will show the importance of data and information. Let us see SQL 2012 Certification Path.
You can get that in Paperback (USA) and Kindle (Worldwide).
In training hundreds of people over that last decade to get their Microsoft certification, to my surprise the biggest benefit you get is something else. The most common benefit my students tell me about is that they get invited to far more job openings after getting certified than they did before. When the stack or resumes gets sorted down, they need a proven reason to keep yours on the short list.