Common SQL Server Mistakes - SELECT *
I’ve been trying to work on some new presentations so that I have a variety, including some spares, when I...
2010-09-01
4,404 reads
Creating a PerformancePoint 2010 Data Source
In a previous post I wrote about getting started with PerformancePoint 2010.In that post you learned about what PerformancePoint is...
2010-09-01
907 reads
Using WITH NOLOCK
A colleague of mine and I were recently talking about some scripts that they had seen containing the WITH NOLOCK...
2010-09-01
551 reads
Interview with SQL Server MVP Glenn Berry
This is a first of a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections...
2010-08-31
2,513 reads
Project Phoenix: Late August Awards Announced
Two more eligible developers and deserving projects have been selected. Any proposals submitted but not selected this time will be...
2010-08-31
1,490 reads
A PASSionate Community
Much has voiced about the Professional Association for SQL Server (PASS) Nominating Committee’s decision to not put Steve Jones (blog,...
2010-08-31
1,557 reads
SELECT, Deconstructed
Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing...
2010-08-31
2,567 reads
Replication Gotcha - Including An Article In Multiple Publications
When administering replication topologies it's common to group articles into publications based on roles that subscribers fulfill. Often you'll have...
2010-08-31
10,724 reads
Unique and non-unique non-clustered indexes on a unique clustered index
In the last weblog
post I have talked about the difference of unique and non-unique clustered indexes.
As you have seen SQL...
2010-08-31
9,815 reads
SQLRally Pre-Con Selection Process – Draft for Comment
Hopefully you’ve heard by now that PASS is launching a new event format called SQLRally in May 2011 in Orlando....
2010-08-31
1,899 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