The Hollywood DBA
I’m delighted to welcome a fellow Brit to the blog to share their story in today’s guest post. Many of you will...
2012-07-18
989 reads
John Sansom
Lunch is for Wimps
A real life DBA tale from the trenches with some awesome advice. That’s what one reader chose to share with...
2012-07-03
1,252 reads
Guest Post – DBAvolution
One of my favourite things about the SQL community is the exquisite diversity of talent of it’s members. Today for the “What’s it...
2012-06-27
2,005 reads
Get Your Ass to PASS!
This year there are to be no excuses, and I mean it.
You know what I’m talking about. There’s always some...
2012-06-20
821 reads
Guest Post – The Last Starfighter
Today I am delighted to be able to share with you a guest post from one of my all time...
2012-06-13
1,198 reads
What’s it Like to Be a DBA?
Absolutely fantastic of course!
You regular readers know that the Becoming a DBA area of the blog is one of the...
2012-06-10
799 reads
Stop Asking and Start Making Decisions Today
You’re desperately trying to get things done but it’s just not happening for you. I’m going to let you in on a little secret, you’re doing it wrong!
2012-05-16
3,432 reads
Where Have all the DBAs and DB DEVs Gone?
Last week the SQL community and in particular the blogosphere, was buzzing with interest noise following the Microsoft Learning site...
2012-04-17
876 reads
How To Live Blog an Event
As the euphoria of SQLBits X sadly begins to fade, I wanted to take a moment to share with you...
2012-04-11
1,049 reads
SQL Server Instant File Initialization (PQW)
In this article we’re going to look at instant file initialization. What it is, why it’s cool and how you can use it in your environments.
2012-04-02
5,203 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