Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Miscellaneous Rss

Search for any content tagged miscellaneous

<< Newer    Items 21 to 40 of 486    Older >>
 

Developers and DBAs

The battle between developers and DBAs can be a rough one at times. However DBAs are often outnumbered by developers and need to be sure they fit in. DBA Janet Wong brings us one of her experiences about how you can better go with the flow.   Read more...
By Janet Wong 2006/12/05 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,890 reads

Importing XML Files Into SQL Server

Have you ever received an XML file from someone to import into SQL Server? It's not as easy as you might expect, especially in SQL Server 2000. New author Steve Moore brings us an article and code on how to do just that.   Read more...
By Steve Moore 2007/11/23 (first published: 2006/02/15) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 37,454 reads

Date and Time in SQL Server 2008

SQL Server 2008 is well on its way to being complete and released with the release of the second CTP recently. There aren't a tremendous number of changes, but one of the more interesting ones is the changes to date and time handling in this new platform. The time and date datatypes have been separated and longtime SQL Server author Vincent Rainardi brings us a short look at how there can be used.  Read more...
By Vincent Rainardi 2007/10/24 | Source: SQLServerCentral.com | Category: news
Rating: |  Discuss |   Briefcase | 12,115 reads

Survive A SQL Server DBA Technical Interview

Another little bit of career advice, this time from longtime author Jeffrey Yao who gives you some pointeres on what you should know for your next job interview.   Read more...
By Jeffrey Yao 2007/10/12 (first published: 2006/07/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 35,566 reads

Partitioning - Part 2

Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques.   Read more...
By Andy Warren 2007/10/08 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,779 reads

The Troubleshooting List

SQL Server guru Andy Warren brings us a list of things that he considers when things go wrong. Read about some of the common sense approaches to solving performance and other problems.   Read more...
By Andy Warren 2007/10/03 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,544 reads

Working Your SOX Off

The Sarbanes-Oxley act has drastically changed the jobs of many DBAs with the audit and reporting requirements this act entails. Brandie Tarvin brings us some hints about how you can go about complying with the new requirements.   Read more...
By Brandie Tarvin 2007/10/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,618 reads

Beginning Professional Development

Continuing with his series on professional development, Andy Warren takes a look at funding some of your career growth and why it pays to invest in yourself.   Read more...
By Andy Warren 2006/09/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,596 reads

A Cynic's Top Ten Tips for IT Contractors

As autumn approaches, Patrick Index produces his ten hot chestnuts for IT Contractors like himself, with a jaundiced 'contractor's-eye view'.   Read more...
By Additional Articles 2007/09/26 | Source: SimpleTalk | Category: miscellaneous
Rating:  Rate this |   Briefcase | 5,060 reads

The Socialization of Knowledge

This article is an excerpt from the forthcoming book, Business Metadata, to be published on or about September, 2007, co-authored by Bill Inmon, Bonnie O’Neil and Lowell Fryman, published by Morgan Kaufman.  Read more...
By Additional Articles 2007/09/25 | Source: TDAN | Category: miscellaneous
Rating: (not yet rated)  Rate this |   Briefcase | 1,677 reads

Strategies for Testing Data Warehouse Applications

This article presents a strategy for testing ETL applications that perform data movement and populate data warehouses. It is useful information for the testing community as well as designers and managers charged with planning a data warehousing implementation.  Read more...
By Additional Articles 2007/09/21 | Source: Datawarehouse.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,101 reads

Making the Most of Operational Analytics with Enterprise Decision Mana

EDM solutions are a logical and often necessary complement to operational analytics.  Read more...
By Additional Articles 2007/09/11 | Source: Datawarehouse.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 963 reads

What Specification Server Should I Buy?

Simon Sabin is always cagey about giving advice on the sort of hardware to run SQL Server on, but admits to some general rules.   Read more...
By Additional Articles 2007/09/10 | Source: SimpleTalk | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,226 reads

Do Alpacas Dream of farming DBAs?

When IT starts to stand for 'Implement This', even the keenest DBA begins to dream of farming Alpacas as a career-change...and we ask our readers how they would have solved the DBA's dilemma.   Read more...
By Additional Articles 2007/09/07 | Source: SimpleTalk | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,023 reads

The Importance of Fraud Analytics

Organizations with mature business intelligence environments can integrate fraud analytics within their current environment to take advantage of processes and architecture that are already in place.   Read more...
By Additional Articles 2007/09/03 | Source: Datawarehouse.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,207 reads

Reverse Engineering Alias Data Types in SQL Server 2000 - Part II

Continuing with his series on Alias Data Types, Yakov Shlafman shows us how to work wtih ADTs when constriaints are involved.   Read more...
By Yakov Shlafman 2007/09/03 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,658 reads

Enums in SQL Server

SQL Server MVP Simon Sabin brings us a very interesting article on a possibilltyfor using enumerated values instead of integer or other coded foreign keys. It is an interesting idea that could go a long way towards making code easier to read.   Read more...
By Simon Sabin 2007/08/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,685 reads

An Auditing Solution with XML And XSL

Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application.   Read more...
By David McKinney 2007/08/20 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,988 reads

10 things you can do to give old servers a second life

To run with the pack in terms of performance, productivity, and competition, servers that are long in the tooth have to be put out to pasture regularly. But there might be (and usually is) some life left in these early retirees, and they can still be put to good use.  Read more...
By Additional Articles 2007/08/17 | Source: Builder.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,757 reads

How Much Scalability Do You Have or Need?

How many cores (or hardware threads) can your code harness to get its answers faster?  Read more...
By Additional Articles 2007/08/16 | Source: Dr. Dobbs | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,743 reads
<< Newer    Items 21 to 40 of 486    Older >>