Running A Basic DMX Query - SQL School Video
This SQL School video introduces us to the data mining queries that you can run from BIDS in an Analysis Services project.
The February 2009 Energy Update
In this month's energy update Steve Jones takes a look at more efficient building practices to increase energy efficiency.
How to move a SQL Server database within the same instance without losing settings
I want to move my database on my SQL Server 2005 system to a new drive, but I have database options, like cross-database ownership chaining, that I don't want to lose or have to remember to re-apply. How can I do this?
Service Broker Transactional Support in SQL Server 2005 Express Edition
This article provides an overview and presents an example illustrating the role of transactions in processing Service Broker dialogs usage.
You Must Trust Someone
After some recent talks with security folks and auditors, one of the things I have had a hard time getting across is that you must trust those folks responsible for account and server management when it comes to securing your data. Yes, you can put in...
Chargeback
Should IT charge other departments for the use of its resources? Is that good for the business? Steve Jones comments on what this could mean for SQL Server DBAs.
XML Workshop XXIII - A TSQL ATOM Library
MVP Jacob Sebastian has written a great series on working with XML in SQL Server and we have the latest installment today. This time he presents a library of functions that can produce an RSS ATOM compliant feed of data.
Creating packages in code - Flat File Source to OLE-DB Destination
This code sample programmatically creates a package that imports a text file into SQL Server, with a Flat File Source and the OLE-DB Destination. This shows how you can leverage the SSIS engine to write your own data import tool for example, but beware importing files is not as simple as it may seem
Networking - Part 6
You can read the previous posts here. To finish up (I think), I want to share a networking technique I stumbled on a few years ago, and talk about one more good reason to network.
Pruning
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Dancing Robot Goes Rogue
Comments posted to this topic are about the item Dancing Robot Goes Rogue
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers