The SQL in the City US Tour
If you haven’t heard yet, Red Gate Software is sponsoring a six city tour of the United States of its...
2012-06-01 (first published: 2012-05-29)
1,799 reads
Oracle Date issues with PowerPivot
This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the...
2012-05-29
1,288 reads
Building a SQL Server Inventory – Part 1
Ok folks, you asked for it. Well, a few of you did, anyway. So today I’m going to share with...
2012-05-31 (first published: 2012-05-29)
5,947 reads
The Rules of Gibbs
It’s been interesting to watch the characters evolve on NCIS over the years, something that can only happen with time...
2012-05-29
856 reads
Detecting Database Option Changes with DDL Triggers
One of the keys to managing a large production SQL Server environment is being aware of changes that are taking...
2012-06-05 (first published: 2012-05-29)
5,052 reads
Denali – Day 29: Resource Governor Enhancements (Database Engine)
Denali – Day 29: Resource Governor Enhancements (Database Engine) Introduction to Resource Governor: Resource Governor is a feature introduced in sql...
2012-05-29
1,668 reads
Books for Learning Transact SQL
I got asked a question recently about what books I would recommend for learning T-SQL. I posted a couple months...
2012-05-29
1,132 reads
DBCC CHECKDB
Quite often when I see a new SQL Server setup, a CHECKDB has never been run on the databases. It’s...
2012-05-31 (first published: 2012-05-29)
118,751 reads
NVARCHAR(n) Vrs NVARCHAR(max)
These datatypes particularly NVARCHAR(n), have been with us for some time now but having seen some of the confusion around...
2012-05-28
7,973 reads
On my way to DevTeach in Vancouver
Just stepping out the door on on my way to the DevTeach / SQL Teach conference in Vancouver, BC, Canada. The...
2012-05-28
976 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
How have you encouraged communication at work?
I do have a question. At work, some groups of people have an inordinate...
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
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers