In this post, l just want to show some cool programming skills and hopefully make it useful for any one interested in learning TSQL and use of variables and some date functions. The main purpose is to write a program that will return the day name such as Monday, Sunday etc of the first day […]
I just want to talk briefly about how we can access sql server instance running either on your personal computer or on a network. Authentication is a big issue for any server because if some successfully passed this gate, they have access to your server and can do lot of things so SQL server provides […]
Hello, I’m briefly going to discuss one topic that can easily throw you under the bridge if you did not take the time to actually practice it. Pivot and unpivot is not your regular every day TSQL term but its good to know it and use it when needed. We are going to take baby steps […]
Hello world, l hope everyone is having peace where ever you are. This week has been a tough one for the United States, I’m talking in regards of the Theater shooting in Colorado. It’s the craziest thing to happen and I extend my my prayers and condolence to the bereaved families and prayers to those […]