Your Password has Failed the Test
Your data is in the public domain and as a DBA you need to be very familiar with what it is possible for the sinner to do with a handy password, and how easily that sinner can get hold of it.
2012-10-08
145 reads
Editorial
Fragmentation Fear
Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?
2012-10-01
387 reads
Challenge Yourself
Challenge yourself to find new tools and use them in your work. That's today's message from Steve Jones. (This editorial was originally published on Aug 5, 2007. It is being re-run as Steve is away on the SQL in the City US 2012 tour.)
2012-10-01
299 reads
Outsourcing Security
Companies may look to outsource security in order to take advantage of experts' skills at a lower price. What will that mean for data professionals?
2012-09-27
109 reads
Pair Programming
Today Steve Jones talks about pair programming and when it might make sense for data professionals.
2012-09-26
181 reads
Trade-offs
When working on a project, you have to make trade-offs. Unfortunately, some managers don't realize this. Steve Jones says we need to help them understand that doing things the right way, and working with trade-offs, makes for better systems.
2012-09-25
131 reads
Rewrite the Coding Rules
If we rewrite the coding rules, will software be more secure? Steve Jones thinks it might and that we should be constantly looking to change the techniques, patterns, and skills we have.
2012-09-24
206 reads
IT is Looking Good
The forecast for IT work is growing. That's good for those of us working in the field.
2012-09-24
163 reads
Teammates
This Friday Steve Jones wants you to have some fun and compare yourself to an athlete or media figure, or even a fictional character.
2012-09-21
134 reads
Data Worms
Worms have been around a long time in computer systems. However changes in the global policies of governments and the possible retaliation for cyber warfare should have DBAs concerned.
2012-09-20
150 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