Presenting at ONETUG on July 10, 2014
I’ll be presenting SQL Performance for Developers to the members of ONETUG on July 10, 2014. I’m going to hit...
2014-05-20
411 reads
SQLAndy
Password Cracking–Part 2
Two days felt like a long time, so we found a cloud server with 16 cores we could use. We...
2014-05-19
598 reads
Building The SQLSaturday Orlando Marketing Plan–Part 8
One of things I wish PASS provided was at least one template for an event flyer, something that is basically...
2014-05-18
500 reads
BASIC
It might or might not surprise you that I learned to code in Basic. I suppose my first real attempt...
2014-05-16
692 reads
Statistics Parser
A quick plug today for Statistics Parser by Richie Rump, a free web site that takes the output from “set...
2014-05-16
1,063 reads
Password Cracking–Part 1
I’ve run into the not uncommon situation where there is a SQL login and no one seems to have the...
2014-05-15
1,009 reads
Peace Officers Memorial Day and Half Staff
Today is Peace Officers Memorial Day and that’s why the flag is at half staff (Had to search, I didn’t...
2014-05-15
309 reads
Drop Me? No, I Don’t Think So–Question of the Day
Drop Me? No, I Don’t Think So is my latest question of the day and has to do with dropping...
2014-05-14
397 reads
Building the SQLSaturday Orlando Marketing Plan-Part 7
Just spent some time re-reading my notes far and my ideas from before – glad I wrote them down, lots and...
2014-05-14
529 reads
Smart As A Bear?
I got this at Hobby Lobby for $7 on sale, it’s about the width of a license plate and a...
2014-05-14
311 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