In SQL Server, there is a good set of preloaded reports to help you monitor the Instance. These reports can be found under the Standard Reports and can be reached via context menu. To find […]
Month: March 2011
March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good news – we had just about as many person attending online as we did in […]
DB Benchmarking
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking, it is preferable to get a baseline and then run the same benchmark tests on […]
SQL Bitwise Operations
How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a single value in the database represent more than one data value? Have you ever had […]
Database Maintenance
I often see a request for some scripts to help with database maintenance. Sometimes those questions come in the form of recommendation requests for maintenance plans. As many already know, there are some really good […]
T-SQL Tuesday #016: Aggregates and Statistics
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
March SSSOLV Reminder
This is just a quick reminder about the meeting coming up on March 10, 2011 at 6:30 PST. You can find more information about the event from here. I am looking forward to this presentation. […]
Having Cake and Eating it Two
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes. There was a lot of good feedback from that. You can go back and read […]
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the comparison of some methods and MS provided stored procs that could help you in the […]
S3OLV March 2011
The Ides of March are upon us and that means that we have another opportunity to learn some stuff about SQL Server. We have that opportunity because it is time for the monthly S3OLV User […]