Another month, another meeting. Time really is flying. And now with more Holidays fast approaching, I am sure that time will warp on us. The Las Vegas user group is happy to announce that we […]
Category: SQLServerPedia Syndication
Haunting a Database Near You
Today, we have a special Halloween edition. For me, Halloween and computer geek go quite well together. And thinking about it, I wanted to try to better understand if there was a correlation. As a […]
An Interesting Sort
I just came across a pretty peculiar sort requirement. The requirement made me sit and think a bit. Since it was somewhat peculiar, I decided I would share the solution. So, let’s start with a […]
October 2011 LV UG Meeting
Boo! OK, so it really isn’t that scary. But it is that time of year and we happen to have something that could fix something that might be scary. It is time once again for […]
Stored Procedures – Common Security Practice
In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at the document available in that link. To further this practice, one may create a database […]
Performance Tuning – Over the Top Biz Logic
This month, Robert Pearl is helping to host a Performance Story contest. The contest is being sponsored by Safe Peak, and you can see more about it – here. The timing on this contest actually […]
T-SQL Tuesday #22 – Data Presentation
Data Presentation is not just about the look of a report. Data Presentation involves performance, accuracy, display and the business requirements. By giving proper attention to each of these facets, the Data presented will be both remarkable and acceptable to the end-user.
Hustle and Bustle to Kick off September
September is kicking off with a boom for me. In one week, it seems I will be here, there and everywhere. Between SQL, PASS, Family, and User Group – this is shaping up to be […]
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else. In SQL, we should be well aware of Precision and Scale of certain datatypes. The […]
Bitwise Operations
Some time ago, I wrote an introductory post about bitwise operations in SQL Server. I had fully intended on writing a follow-up to that. Alas the opportunity has passed for the idea I was working […]