The 2004 premier SQL Server event, the PASS Summit is coming to Orlando in September. Once again we'er working with PASS to sponsor and promote this event. Read Steve Jones' take on this event and why it's worth your time and your company's money.
2004-08-06
3,514 reads
The second part of the series by Darren Fuller on SQL Server change management, version control, and ways that you can automate this approach. If you do any type of SQL Server development, having a version control system is key to ensuring stability and keeping to your deadlines. Whether you agree with this approach or not, it's good information to have.
2004-08-04
10,104 reads
Developing applications for SQL Server usually results in a variety of access methods that the programmers use. A data access layer class, given to the developers, is usually seen as the best practice, but one that isn't usually implemented. In fact, in most software I've built, each developer uses his own method, or may cut and paste from another, but rarely is there a central access class. New Author Patryk Nowakowski brings us his solution using ADO.NET.
2004-08-03
13,843 reads
Automating SQL Server tasks is the sign of an experienced DBA. One who doesn't waste time on repetitive tasks that can be easily setup in a job, task, or some other scheduling process to run when they need to run. Haidong Ji has written a number of articles on how to perform automation and brings us yet another technique. This time he looks at managing your backup files, something that we all need to do, but all too often forget to do.
2004-08-02
17,415 reads
Murphy's law has struck us all, as evidenced by the disaster entries we've received in the past. Imceda software, makers of Litespeed are sponsoring a new contest, looking for your nightmares.
2004-07-30
4,146 reads
NGS Software is in the security business and have been very successful in finding vulnerabilities in many products, notable SQL Server. They have used their expertise to build products to help you better secure your systems. Dale Corey looks at one of those products, NGSSquirrel, which does vulnerability assessment.
2004-07-30
10,667 reads
What do your programmers do with nulls? Do they know nullif, isnull, what about the powerful coalesce function? Do they think DBA's look at the world differently? Why, it's all code isn't it?
2004-07-29
10,994 reads
SQL Server change management is tough. The tools don't integrate with version control systems, there isn't good administrative controls to enforce control, and often you need to buy a third party tool to make this work. New Author Darren Fuller takes a look at the various ways in which you can implement version control in SQL Server. This is part one of a four part series on version control in SQL Server.
2004-07-28
13,730 reads
Designing a SQL Server database is a challenging task. Making decisions about how to build tables, their relations, etc. can be a full time job for any DBA helping to build an application. Lookup tables are a part of just about every application that you work with or build a back end for. Leo Peysakhovich brings us an article on database design that deals specifically with lookup tables.
2004-07-27
30,643 reads
The highly anticipated Beta 2 of SQL Server 2005 aka Yukon, was released today (Monday, July 26).
2004-07-26
7,684 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Comments posted to this topic are about the item Going Native with Fabric Spark...
Which of these are valid OPENQUERY() uses?
See possible answers