Latest Blog Posts
I have the pleasure and privilege to announce that I was awarded with the “Author of the Year” award at the MSSQLTips.com website!
I am humbled by the recognition of my fellow peers in the SQL Server community and I’d like to thank all of you, the #sqlfamily, for voting. Read more
Today: Tuesday, January 13, 2015 is the 62nd entry and first T-SQL Tuesday of the year 2015, and I am honored to be this month’s host to kick of the New Year! Last week, I made the announcement, and invited everyone to the blog party started many quantum… Read more
There are many methods to find next business day. One common way is to use of calendar table. This post is to get an output using T-SQL Or UDF function.
Download T-SQL NextBusinessDay
The details are given below
The script can be executed by feeding Input values to SQL. In… Read more
A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals who have impacted my career. I do this as a tribute to my father-in-law, Ed Jankowski who passed away five years ago this past December (2014). Check out my original… Read more
I showcased a demo recently that looked at a potential issue with an application where a user used a simple update statement to gain privileged access to a system. That’s scary, and it’s a potential issue for many applications that handle their own authentication.
The problem with this type of… Read more
Want to get out of the winter blues and into some warmer weather for some deep SQL Server training? Join me on the next SQL Cruise to the Caribbean this February! This is my first SQL Cruise, and I’m really excited to go. This trip sets sail to three different… Read more
Awhile back I did a post on my Fab Five – was one of my favorite ones I’ve done to date because it dealt with individuals who have made a tremendous impact in my professional career in some form or fashion. I am not ashamed to admit I am a… Read more
Configure Search Topology in ScaleOut Mode in SharePoint 2013 || Configure Search Service in SharePoint 2013
With a New Year and my earlier commitments. Below is the way to configure Search Service 2013 in Scale out mode.
Search Service configuration 2013 in Standalone mode can be viewed at: “How to Configure Search in SharePoint 2013”
As described earlier, Microsoft is focusing more and more…
I have been working with SQL Server for the past 17 years, and in the past few years I have been also very involved in the SQL Server community in Israel and around the world. I love SQL Server, and I also love the community around SQL Server, which is… Read more
Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I ever wrote was security related. A brief explanation and solution for the Double Hop problem on SQL Server Central. Well continuing that theme I had an all to brief, but… Read more
Here’s a real-world story: Data collection and analysis is, ironically, for a data management profession, one of the toughest parts of my job. I regularly pull data from our various databases and packaged application reporting systems for CRM, licensing, and user information.
If you’ve ever worked with a packaged product,… Read more
I have been chosen to speak at SQL Saturday in Vienna, Austria on 28th February.
The organisers have just moved the event to a larger venue to cope with the expected demand.
My talk is entitled Putting Your head in the Cloud– A Beginner’s Guide to SQL…
T-SQL Random Numbers using RAND()
SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1 of float datatype. To create a random number execute Select Rand(), in my example it returned .0131039082850364. If I wanted to always return the same number I can… Read more
As is our want, we must look back over the past year to see what happened. While I normally focus on work related items, this year was a crazy year for our family as well as my career. So let’s have a look at what happened this year.
In part 1 of the In-memory OLTP articles we gave you an introduction into In-memory OLTP, showing what the requirements are, the limitations and a quick look at the Advisors.
In this article we are going to dive a little deeper into a large portion of In-memory OLTP: Memory-Optimized (or… Read more
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2 of them are on Friday May 29th and we have had many submissions so far. We are taking submissions until 1/15/2015 so just under a week left to email them… Read more
If learning SQL is in your New Year Resolution, then you will be happy to read this post.
We all make resolutions that we fail to keep. What I am suggesting here will give that failure minimum chance.
Here is what I am suggesting:
- Get a copy of the SQL…
The requirement is to convert the delimited column into rows
Input data and required output details are given below