Tour de Career: Prologue
Tour de Career
It’s July and for some that means baseball and bar-b-ques. For me it means my birthday and Tour...
2010-07-16
633 reads
sqlchicken
T-SQL Tuesday #008: Gettin’ Schooled
Here we go again with another round of T-SQL Tuesday fun this time brought to you by recent SQL Certified...
2010-07-13
625 reads
Exceptional DBA of the Year 2010 Finalist!
This post is a tad overdue as the public announcement was a few weeks back but it’s been a topsy-turvy...
2010-07-12
439 reads
T-SQL Tuesday #007 – Roundup
New hotness
First of all I apologize for this roundup taking more time than usual to appear. This last week was...
2010-06-14
659 reads
PowerShell I Heart You
PowerShell = Giggity Giggity Goo
Ok so in the last 48 hours I think I’ve fallen madly in love with PowerShell. My...
2010-06-10
902 reads
Professional Development Event:Taking Control of Your Career
This is just a reminder that this month’s Professional Development virtual chapter meeting we have MVP, PASS Board member, and...
2010-06-07
401 reads
T-SQL Tuesday #007: Summertime in the SQL
Invitation for T-SQL Tuesday #007
New hotness
Welcome back to the blog party known as T-SQL Tuesday. I’m honored to be hosting...
2010-06-01
590 reads
Mea Culpa: TweetRandomizer-gate
If you’ve ever read Spider-Man or spent any sort of time around the Marvel Universe (movies included) you’ll have no...
2010-05-15
647 reads
PASS Professional Development VC Reboot!
This is just a quick post to let everyone know that this week marks the return of the PASS Professional...
2010-05-10
466 reads
The PowerShell and XML Corollary
Girl Property Surrounded by Geek Objects
I’ve just started watching The Big Bang Theory so I figured I’d borrow a naming...
2010-04-27
795 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Collecting active node hostname at centralized location
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Beginner in sql server
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers