Parsing SQL for Table Names
Visual Studio Team System 2008 Database Edition (VSDB) ships with a .NET class for parsing T-SQL. I’ve previously blogged about...
2010-04-04
2,186 reads
Service Broker Solutions - Don't Forget the Basics
After finally getting a Service Broker solution implemented successfully, I'm really impressed with the technology, and frustrated how difficult it...
2010-04-03
915 reads
A T-SQL Holiday Message
Totally pointless, but fun. Run it to decode the message.
DECLARE @Message varchar(20)
SET @Message = '????????????'
DECLARE @Decode Table(
DSeq tinyint,
DKey smallint
)
INSERT INTO...
2010-04-03
727 reads
A DMV a Day – Day 3
The DMV for Day 3 is sys.dm_os_sys_info, which is described by BOL as:
Returns a miscellaneous set of useful information about...
2010-04-03
1,076 reads
The Web 3.0 has finally arrived… It’s The Cloud
The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year,...
2010-04-02
81 reads
The Web 3.0 has finally arrived… It’s The Cloud
The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year, Amazon EC2 dropped the Beta label and the story accelerated: Less...
2010-04-02
36 reads
Winner of the March SQL Aloha Contest
The March SQL Aloha contest had a total of 25 entries, and all of them were great responses to this...
2010-04-02
423 reads
What happens when Windows is the step-child? Adventures in Ruby on Rails.
Like many of you I’ve heard the developer community going on about Rails for quite a while now. It wasn’t...
2010-04-02
1,470 reads
Speaking Seven Times in April
April will be a busy month for me as I will be speaking seven different times, on seven different topics,...
2010-04-02
448 reads
The Best vs. The Good Enough
When you ask a question on the forums, you'll often get responses that certain ways of doing things are inefficient...
2010-04-02
469 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers