T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?
T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?
This blog entry is participating in T-SQL Tuesday #004, hosted this month...
2010-03-09
1,466 reads
Blog Posts
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
576 reads
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,615 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
574 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
422 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
684 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
303 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,390 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
626 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
558 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers