It’s Time to End Password Reuse
Last week Ebay announced that some accounts were compromised, including passwords with as yet unstated encryption. Those who aren’t tech...
2014-05-26
678 reads
SQLAndy
Building The SQLSaturday Orlando Marketing Plan–Part 12
Meetup.com did refund my $19, good!
Team oPASS added SQLSaturday #318 to their calendar, you can see it here, or here’s...
2014-05-24
549 reads
Building The SQLSaturday Orlando Marketing Plan–Part 11
Just received the first flyer design – thoughts?
2014-05-24
543 reads
Wishing For Error Messages That Are Good Search Terms
Here’s a SQL error you might get:
not able to access the database “SomeDB” under the current security context.
If you don’t...
2014-05-23
518 reads
Building The SQLSaturday Orlando Marketing Plan–Part 10
My experiment with Meetup.com hasn’t worked out well so far. I set up the event site and sent it around...
2014-05-23
527 reads
Writing A Question Of the Day–More Notes
One of the things I’m trying to do now is include a link to a blog(ger) in the explanation. That...
2014-05-22
484 reads
An Sp_addrolemember Gotcha
Over the past few months there have been a handful of times when I had to fix a security problem...
2014-05-22
823 reads
Submitted My Application For the 2014 PASS Nominating Committee
I just finished up the short and not very painful application to be a candidate for the NomCom this year. ...
2014-05-21
494 reads
Building The SQLSaturday Orlando Marketing Plan–Part 9
I’ve heard more than once that Meetup.com is a good way to reach new people so we’re looking at how...
2014-05-21
697 reads
Running Out of Foreign Keys-Question of the Day
Running Out of Foreign Keys is live today. Nothing too interesting about this one, a straight forward question where you...
2014-05-20
339 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