TSQL Tuesday #4: IO
“IO IO, It’s off to disk we go!” was in Mike Walsh’s blog post that introduced this TSQL Tuesday and...
2010-03-09
575 reads
Blog Posts
Using a CTE with a T-SQL Pivot Statement
During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a...
2010-03-09
9,603 reads
A Swing and a Miss by PASS
On Saturday my son had his second baseball game. When it was his turn to hit I reminded him to...
2010-03-08
572 reads
It’s Like the MVP Summit
I missed the 2010 MVP Summit, which is disappointing. There were a lot of SQL 11 talks and I was...
2010-03-08
421 reads
MacGyver?
Who the heck is MacGyver? Television program you say? Hang on. I need to visit imdb.com…
Oh, the late eighties… Yeah,...
2010-03-08
678 reads
Notes from SQLSaturday #33
I did the relatively quick flight to Charlotte on Friday afternoon, arriving just before 2 pm, grabbed lunch to go...
2010-03-08
301 reads
OPASS March Meeting with David Pless
March 9 6-8:30pm
This month's meeting sponsored by
Live Meeting: https://www.livemeeting.com/cc/usergroups/join?id=QFG3GW&role=attend
Speaker: David Pless
David has been a Senior Premier Field Engineer with...
2010-03-08
1,388 reads
Powershell- Is it easy as everyone claims?
Where ever you read, people claim that power shell is so easy that even a dummy can do it. Really?...
2010-03-08
622 reads
SQL Server Locking & Block Scripts
A couple of weeks ago, I gave a presentation to the PASS DBA Virtual Chapter on SQL Server Locking & Blocking...
2010-03-08
551 reads
T-SQL Tuesday #004 Hosted by Mike Walsh
I just wanted to remind people to participate in T-SQL Tuesday #004 on the subject of IO. You just need...
2010-03-08
557 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers