SQL Server – Transaction Log File is Full; How to Shrink the Transaction Log
Here is a typical scenario every SQL Server DBA faces: Transaction Log grows unexpectedly or becomes full!! So, do I need to increase...
2012-10-12
481 reads
Lost in Translation – Deprecated System Tables – sysfiles
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-12
1,154 reads
Dallas, TX to Pittsburgh, PA A #sqlsat171 Story!
First SQL Saturday in Pittsburgh
It was an honor to speak at the first SQL Saturday in Pittsburgh. The company I
We...
2012-10-12
636 reads
24 Hours of PASS videos online
All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free. Check the session schedule for...
2012-10-12
746 reads
Reblog: October 5 to October 11
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-12
489 reads
24 Hours of PASS Recordings Available
If you missed any of the great 24 hour of PASS sessions from September you
can now watch the recordings.
http://www.sqlpass.org/UserLogin.aspx?returnurl=%2fLearningCenter%2fSessionRecordings%2f24HoursFall2012.aspx
Details...
2012-10-12
1,077 reads
I’m Not Attending #sqlpass Summit 2012 and I’m Sorry For Myself
I really wanted to attent PASS Summit this year, I’ve never attended before. I was preparing myself mentally since the...
2012-10-12
691 reads
How to move the FullText catalog with SQL Server 2005 ?
4 simple steps to move FullText catalog with SQL Server 2005 :-
1. Detach the database which contains the FullText Catalog....
2012-10-12
1,072 reads
Introduction to SQL Server 2008
There are still some seats left on the SQL Server 2008 A Comprehensive Hands-On Introduction that I will be presenting...
2012-10-12
571 reads
24 Hours of PASS Recordings Online
This just in… the 24 Hours of PASS sessions are in and available for streaming. If you missed an hour...
2012-10-11
1,030 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers