Kill That Target!
Having trouble with a target server (TSX)? Steve Jones did in his environment. Read about how he worked around the issue to restore administrative capabilities.
2002-09-16
7,235 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
The Dot Com Bust - Part 2
It's been a year since Steve Jones last wrote about the state of the DBA job market after the economy soured. Here's an update of the last year.
2002-09-09
4,488 reads
ANSI Options Part 4 - ANSI_WARNINGS
Part 4 examines more ANSI options that are available in SQL Server. A simple setting with some unexpected (for the author) results.
2002-09-03
4,746 reads
SQL-DMO for Beginners
How many of you are VB programmers? How many of you have never worked with DMO? This is the article if you don't work with VB or DMO, but want to get started. One of the more powerful tools that you can add to your arsenal.
2002-08-29
12,884 reads
Review: MSSQLCrack
A new SQL Authentication password cracker you should be aware of. It can crack your SQL passwords and give you an idea of how secure you are.
2002-08-20
18,040 reads
Sort of Unique
Recently Steve Jones noticed that someone wanted to use a UDF to enforce uniqueness. No big deal, right? Well this person wanted to enforce uniqueness based on some other column value. A bit of a challenge, but this article presents a couple ways to handle this.
2002-08-12
4,256 reads
Ansi Options Part 3 - ANSI_NULL_DFLT_ON
The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server.
2002-08-07
3,902 reads
Review: Microsoft Baseline Security Analyzer
A look at a new security tool from Microsoft for analyzing your SQL (and other) servers.
2002-07-30
5,000 reads
The Vision Series
From News.com, this series contains a bunch of interviews and surveys of a number of CTOs from large US corporations. Worth a read to see what the heavy spenders think.
2002-07-25
2,548 reads
Ansi Options Part 2 - ANSI_NULLS
The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server.
2002-07-15
4,664 reads
Blogs
Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report...
Capturing Ideas for Blogs
By Steve Jones
As we close out the year, I decided to drop this post here and...
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Forums
Page break in multi column paginated report
Hi, I have created a multicolumn paginated report, which includes a subreport that I...
create multiple output files based on query
I have this script that puts all of the output from query to a...
what if my last resort on extracting excel is at the cell level?
Hi, after i copy in ssis my excel file to a secured folder, its...
Question of the Day
What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers