On a couple of recent webcasts, I pointed out the folks were running with the local Administrator account. To start this out, I'm not a big fan of security by obfuscation. Security by obfuscation (not code obfuscation, but security by obscurity, if...
We all make mistakes, even when we are trying to help others. What should you do about it? Steve Jones has a few thoughts on advice online.
A legal challenge to the Sarbannes-Oxley act is being heard this fall. Steve Jones doesn't necessarily think this is a bad law.
In this article I have shown a way of writing queries in which WHERE clause of the query is executed dynamically depending on values of input parameters.
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to use it. I hope to clarify in which circumstances an auto-retry works best and when not to use it also. The (disclaimer!) point is that every job has its own constraints, requirements, and has to be evaluated individually for whether an auto-retry will work. I will try and keep this summary short and crisp, but still with enough detail to understand auto retry best.
In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios.
We all make mistakes, even when we are trying to help others. What should you do about it? Steve Jones has a few thoughts on advice online.
A legal challenge to the Sarbannes-Oxley act is being heard this fall. Steve Jones doesn't necessarily think this is a bad law.
A legal challenge to the Sarbannes-Oxley act is being heard this fall. Steve Jones doesn't necessarily think this is a bad law.
A legal challenge to the Sarbannes-Oxley act is being heard this fall. Steve Jones doesn't necessarily think this is a bad law.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No. 98F & 98G,...
CSTelpon : 0853-73737551 Jl. Metro Pondok Indah No.60 & 61 UA, Pd. Pinang, Kec....
Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103, Jl. TB Simatupang...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers