I’ve been skipping on posting technical blogs for a couple months. I’m planning to put that issue to rest with some aggressive blogging over the next couple months to make up for lost time. After reading SQL Fool’s post on her reasons for change, I figured I’d do the same. Not because anyone has noticed … Continue reading Missing Blogger
Tag: SQL Server
SQL Server Certification Discounts
I like discounts. Paying full price when I don’t have to sucks. It’s a waste of resources, and as a person who’s had to tune databases in the past I’ve grown quite fond of resource management. And the best resource ever to manage is dollars. Because you can buy stuff. What About 2nd Chance? I … Continue reading SQL Server Certification Discounts
Checking EXISTS – What’s Your Practice?
Michael Swart (Database Whisperer) posted a great write up and interview with Brad Schulz that is worth checking out. Michael’s post links to a post from Brad on the use of EXIST and what is required for the SELECT portion of the statement. Hope you are still with me. Definitely worth the read and +1 … Continue reading Checking EXISTS – What’s Your Practice?
To Be Or Not To Be In the Memory Buffer
Sometimes when I get pulled in to look at a database, I’ll sit down with the developers or database administrators working on the database and get some background on the database. This usually includes pointing on the important tables, an explanation of why some design decisions were made, and some pre-conceived notions about where to … Continue reading To Be Or Not To Be In the Memory Buffer
Free SQL Server Security Book
I saw this post a few weeks back and got around to downloading it myself tonight. If you don’t know what it is. It’s a free SQL Server security book. Best of both Worlds There are two things I like about this e-book. The first, it is free. And the second, it’s a book on … Continue reading Free SQL Server Security Book
Check out the Ultimate Virtual Conference from SSWUG
In less than a month SSWUG will be hosting the Ultimate Virtual Conference on October 21-24. This is an excellent opportunity to get the benefits of heading to a conference full of Rock Star speakers while be able to view the content from the comforts of home or your desk. Reasons to Attend Some of … Continue reading Check out the Ultimate Virtual Conference from SSWUG
This Week Only PASSMN Meeting (August 18)
Well… until next month of course. If you’re in Minnesota and reading this… and don’t mind sharing some snacks with other like minded SQL professional… then come down and join us for this month’s SQL Server user group meeting. We’ll be in a different location for this month – across the skyway from the normal … Continue reading This Week Only PASSMN Meeting (August 18)
Psst… It’s Free!
The PASS Summit is coming up in just a few short months. Have you had a chance to make your arrangement? If you are like many, the down economy may be cutting into the budget that typically goes towards these events. If you hadn’t heard, the screaming baby on the side wants you to know … Continue reading Psst… It’s Free!
Analyzing Report Execution Time
One of the reasons I was digging around to find out how many reports were being executed for each folder the other day was that there were some subscription issues at the client. The goal was to get a break down of when reports were being executed and generally who’s reports they were. With that … Continue reading Analyzing Report Execution Time
Finding Number of Reports Executed By Folder
While working with a client a couple weeks back, I was asked to determine the count of reports that were being executed under each folder off the root directory on the Reporting Services instance. Each of the folders off the root directory represented a department at the client. For the output, I decided that I … Continue reading Finding Number of Reports Executed By Folder
Strate SQL 