SMO is a very useful way of automating a wide range of routine database jobs, but Phil Factor laments Microsoft's apparent ambivalence towards the technology, including a lack of anything remotely resembling adequate documentation.
2011-11-28
187 reads
Today we have a guest editorial from Andy Warren that looks at stress and how it impacts your job. He offers a few ways that you might better deal with it as well.
2011-11-28
204 reads
This editorial was originally published on Jan 11, 2007 and is being re-run as Steve is on vacation. A fun poll today asking what you like to eat at work.
2011-11-25
79 reads
Today we have a guest editorial from Andy Warren that looks at the relationships you have with your co-workers.
2011-11-23
453 reads
This editorial was originally published on Jan 17, 2007. It is being republished as Steve is on vacation. This one deals with data security.
2011-11-22
108 reads
This editorial was originally published on Feb 5, 2007 and is being re-run as Steve is on vacation. Is this the advice you'd give, or take, in a DR situation? Steve thinks it's not.
2011-11-21
115 reads
This week saw the release of RC2 of SQL Server 2012 and marks an important milestone towards the next release of SQL Server.
2011-11-21
94 reads
A career based poll this Friday has Steve Jones asking what your title is, or maybe what you think it should be given the work that you do.
2011-11-18
166 reads
Why are sites still being hit by SQL Injection on a large scale? Steve Jones talks about a recent large scale attack that affected over a million sites.
2011-11-17
573 reads
With the DBA in Space contest ending this week, Steve Jones has some thoughts on the contest, and what he'd do if he were to win.
2011-11-16
70 reads
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Have you ever wondered where a certain field is used in a report? Or...
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Comments posted to this topic are about the item A Strange Query
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
I am using the following script to import data from a json file. This...
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers