Intrusion Detection Systems are a great tool for security, but they have suffered from information overload with security professionals struggling to dig through the data. New author Yaroslav Pentsarskyy brings us a look at how SQL Server helped him find security issues.
2006-08-15
4,779 reads
So, you're a Microsoft SQL Server administrator flirting with open source, but you're not sure how far you should go on the first migration? Don't worry, there won't be much peer pressure to go "all the way." Look around and you'll find that most businesses making the switch are going only as far as their Web applications.
2006-08-04
3,016 reads
Here's a sample script to help you get some generic mode, median, and mean statistics for something. In my example, I'm getting the number of days something takes to start and stop some task. The idea is that I'd have a fairly short list of jobs, and record would record the job id, and start/stop […]
2006-08-17 (first published: 2006-08-02)
1,090 reads
Inspired in the script submited by ramesh_kondaparthy , this is a set oriented solution for the same problem.Parameters: 1) @InputString varchar(25)Accepts the string, which we need to validate 2) @Type int = 0 validate the string for only alphanumeric charactersi.e Allows characters between [A-Z] ,[a-z] and [0-9] = 1 validate the string for alphanumeric and […]
2006-08-22 (first published: 2006-08-01)
4,059 reads
One of the responsibilities of the Microsoft.com operations team is to manage the infrastructure that supports the Windows Update and Microsoft Update services, which have client bases in the hundreds of millions and growing. The Windows Update site provides critical updates, security fixes, software downloads, and device drivers for Windows operating systems. Microsoft Update is the service that brings you all the features and benefits of Windows Update.
2006-07-28
1,321 reads
This is an algorithm from the september 1986 issue of Byte Magazine, in an article called Abstract Mathematical Art. It borrows from Tim Conways Game of Life to represent an algorithm by which a series of numerical values can attempt to replicate itself. It is deeply steeped in the philosophy of Caos Theory and Evolution, […]
2006-08-28 (first published: 2006-07-27)
341 reads
Not many people enjoy using Globally Unique Identifiers (GUIDs), partly because they are cumbersome to type and work with for humans. However they fill a need and can provide some interesting benefits. SQL Server expert Andy Warren takes us through what a GUID is and how you can use it easily in your code.
2006-07-27
16,348 reads
The use of XML is growing all the time and if you listen to the media, XML is a technology you cannot do without. New author Stephen Hirsch brings us a look at XML from more of a skeptic's point of view.
2006-07-24
11,033 reads
SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of copying the database in an automated and highly parallelized way.
2006-07-17
2,156 reads
This script cycles through a chosen selection of databases, and grants permissions to all tables, views and stored procedures to a user or role.To use, change the ###text### to control which databases, permissions and the user/role concerned.
2007-02-02 (first published: 2006-07-14)
915 reads
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
By Steve Jones
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Comments posted to this topic are about the item Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers