SQL Server 2012 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-11
1,727 reads
SQL Server 2008 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-20 (first published: 2012-06-11)
3,078 reads
Slipping in a Break
I know some people like long holidays, but I tend to prefer short ones. Today is one of those breaks...
2012-06-11
861 reads
The Exceptional DBA Awards – 2012
Who will be the Exceptional DBA of 2012? I’ll be judging.
It’s hard to believe that it’s time for the Exceptional...
2012-06-21 (first published: 2012-06-11)
2,580 reads
Exceptional DBA Awards 2012
Reprinted from my editorial in the Simple-Talk Newsletter.
It’s hard to believe, but it was five years ago that Red Gate Software...
2012-06-18 (first published: 2012-06-11)
2,061 reads
Performance reviews – Self-evaluations
My annual performance review at work is coming up shortly, and this year they’ve decided to do things a bit...
2012-06-11
3,074 reads
RANKING Function in plain SQL
Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using RANK() function.DECLARE @StudentScore TABLE(StudentName VARCHAR(1),StudentScore INT)INSERT @StudentScore VALUES ('A',85),...
2012-06-11
72 reads
Interview questions
Lately, I’ve been asked by several folks about the interview questions that I use when I interview candidates for SQL...
2012-06-15 (first published: 2012-06-11)
12,019 reads
RANKING Function in plain SQL
Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using...
2012-06-11
321 reads
ORM Tools
ORM tools. They’re great. They’re evil.
In the right hands, used the proper way, they can be a very powerful, very...
2012-06-11
3,500 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