DBA's Need (and Deserve!) a Large Monitor, and Preferably Two of Them
With all the options we have for viewing query plans I still prefer the graphical view. Combined with tooltips and...
2008-08-12
523 reads
Blog Posts
Installing RTM (SQL Server 2008)
I had to install the RTM version of SQL Server 2008 a few days ago since I'm tech reviewing a...
2008-08-12
733 reads
Argentina Code Camp
My friend Jonas Stawski just sent me a note about the upcoming Code Camp in Argentina on October 24, 2008....
2008-08-11
599 reads
Minutes of the Aug 2008 oPASS Meeting
I've just posted minutes of the August 2008 user group meeting. We had two great presentations, a short one from...
2008-08-10
684 reads
SSWUG SQL Server Virtual Conference III
There are many technical conferences available for SQL Server professionals, such as PASS. I have been lucky enough to go...
2008-08-10
1,032 reads
Changing jobs -- Pros and Cons
I read Andy's post Changing Jobs - Should You? today with great interest. I think it is good topic in the...
2008-08-08
1,298 reads
Changing Jobs - Should You?
I think most people fall into two groups, the ones that change jobs every year/every time they can make another...
2008-08-07
556 reads
Check Authentication Scheme (Kerberos) on SQL Server 2005
I had to redo SPNs today because we swapped out service accounts on some of our non-production SQL Servers. I...
2008-08-07
3,756 reads
SQL Server 2008 RTM - Community Thoughts & Resources
As has widely been announced in the SQL Server community, SQL Server 2008 has RTM'ed. It's now available for download...
2008-08-07
898 reads
Negotiating - It's Not All About Winning
More and more I see business people adopt the mindset that any negotiation is raw combat with the goal of...
2008-08-05
601 reads
Blogs
Modifying a Trigger to Capture More Info: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
SQL Server Agent Jobs: Set It and Forget It?
By Kevin3NF
Useful tips to make your jobs more stable Too many IT teams treat SQL...
From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences
After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling...
Forums
One big server with multiple instances, or multiple smaller servers...
We're currently on SQL 2019 and will likely be looking to migrate to a...
Transitioning AlwaysOn Availability Group to Synchronous Commit Mode
Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...
CDC & Azure Managed Instances - Performance degredation
Anyone got any good advice for performance tuning CDC on a Managed Instance? We...
Question of the Day
The Trigger Updated Column(s)
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers