Database refactoring is a difficult proposition at the best of times, but is rendered more or less impossible if the database is close-coupled to the application's other components. In a guest editorial, Mladen Prajdic stresses the importance of a native SQL Server abstraction layer.
2010-11-22
2,686 reads
Today we have an editorial reprint from Aug 23, 2005 as Steve is on vacation. Does security through obscurity work? Steve Jones thinks it can help in a limited sense, providing another layer of protection.
2010-11-22
115 reads
This Friday Steve Jones asks if you think that your job could be done with smaller devices. Is there a chance that a mobile phone, a tablet or something else could help you be more productive?
2010-11-19
150 reads
It seems that there is a disconnect between how technical people view security and how business people see it. Steve Jones talks about the problems that we have in trying to secure the systems we manage.
2010-11-18
167 reads
Are you truly an expert in SQL Server? Would you claim to be a 10 on a scale of 1 to 10? Steve Jones notes that the product is so wide and deep that it's unlikely any of us will be an expert in most of SQL Server, and that's OK.
2010-11-17
299 reads
Not many of us work at Google scale, where every little thing you do can matter. However Steve Jones thinks that the little things still matter when you are building software.
2010-11-16
222 reads
We have to provide security for our data, and to some extent that means verifying who has access. SQL Server has limited means for doing this other than relying on the OS, but Steve Jones has some ideas on how to make this more secure.
2010-11-15
131 reads
This past week saw the next version of SQL Server, code named Denali, released as a public CTP. Steve Jones comments on the new version.
2010-11-15
317 reads
This Friday Steve Jones talks about database design and specifically asks how you prefer to design triggers.
2010-11-12
874 reads
You can get a look into how SQLServerCentral handles the load of it's database servers with a new tool, and release of reports.
2010-11-11
341 reads
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)...
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Finding skilled and reliable Painters and Decorators Twickenham, Painters and Decorators Isleworth, Painter &...
I am using the following script to import data from a json file. This...
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Which of these inputs is the smaller input to a hash join?
See possible answers