Delayed gratification
Call me odd, but I enjoy taking certification tests. It may be that I've always tested well, or perhaps it's...
2008-07-20
666 reads
Blog Posts
Why Are Stored Procedures Too Hard?
Recently I was going through the buy or build process on a small segment of functionality needed for a project,...
2008-07-20
854 reads
Patching
Probably the least enjoyable thing about being a DBA is patching servers. We received the bad news in the July MS...
2008-07-19
1,910 reads
Follow Up Notes on the Custom Whiteboard
A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially...
2008-07-17
512 reads
JSSUG Speaking Event: Reporting Services 2008
We had a great group of about 35 people last night at the JSSUG (Jacksonville SQL Server User Group) meeting....
2008-07-17
714 reads
Tools
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,169 reads
Comments on Dissecting SQL Server Execution Plans by Grant Fitchey
Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance...
2008-07-16
1,358 reads
Reminder - Midlands PASS Chapter Meeting - July 17 - MVP John Welch
The Midlands PASS Chapter hosts:
SQL Server MVP John Welch
July 17, 2008 at Training Concepts
The Midlands PASS chapter will hold a...
2008-07-16
630 reads
SQL Server 2008: Implementation and Maintenance, Beta Exam
I signed up for the SS2K8 beta exam, the maintenance and implementation one, and had it scheduled for this morning....
2008-07-16
860 reads
Find all views created on a table
USE ADVENTUREWORKS;-- You can use any kind of database that you have
GO
--Procedure that shows all views created on a table,...
2008-07-15
633 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers