scandalz.net
 
 
 
BETA (Google AJAX Search)

Databases

This is the template.

Featured Article(s) Building Simple Reports with Reporting Services (Part 1 of 5) We're going to show how to create both simple reports and reports with variables. We will discuss how to manage those reports once you’ve created them including how to secure your reports. And finally we will...(more)

We're going to show how to create both simple reports and reports with variables. We will discuss how to manage those reports once you�ve created them including how to secure your reports. And finally we will discuss how to allow your users to access those reports. Throughout the session we will be doing demos of nearly every feature of Reporting Services.

(Mahesh Chand) A RadioButton control provides a round interface to select one option from a number of options. Radio buttons are usually placed in a group on a container control such as a Panel or a GroupBox and one of them is selected.

(Sheryl M. Larsen) Few things do well without proper care. Houses, cars, pets, friends, and family all need our attention to stay happy and healthy, and database management systems are no different.

(Deanna Dicken) As enterprises add systems and acquire companies, they will most likely find themselves faced with a growing inconsistency amongst core data utilized by their key systems. This leads to an inability to provide quality data to management. Master Data Services for SQL Server provides a means to centrally manage and serve up this critical enterprise data.

(Scott Mitchell) Last week's article, Implementing the Store Locator Application Using ASP.NET MVC (Part 1), started a two-part article series that walked through converting my ASP.NET store locator application from WebForms to ASP.NET MVC. Last week's article stepped through the first tasks in porting the store locator application to ASP.NET MVC, including: creating the new project; copying over stylesheets, the database, scripts, and other shared content from the WebForms application; building the HomeController; and coding the Index and StoreLocator actions and views.

(Malcolm Sheridan) In the last couple of weeks, we've been able to see what the future holds for ASP.NET MVC with the release of ASP.NET MVC 3 Preview 1. This is the first public release of MVC 3 and there are some notable additions to the framework. The biggest in my opinion is the new Razor view engine. You've always had the ability to plug in thrid party view engines such as Spark, but now out of the box, Microsoft has introduced the new Razor view engine. What this engine aims to do is simplify the HTML and readability of your view. Another bonus is less code to write because of the new syntax. This article will go through how to setup a new project, and a future article will outline the new Razor syntax.

(Darla Ferrara) XML Linking Language (XLink) is the standard for creating a hyperlink in XML. It allows you to integrate links into your XML code much the same way the tag does in HTML. You must establish the namespace before the XLink then connect a hyperlink to an element that serves as a bridge to a seperate object.

(Willie Favero) On September 21, IBM will be presenting a no-charge Webcast "TCO news: Optimizer in DB2 10 for z/OS Beta" featuring optimization expert Terry Purcell. Here's an opportunity to find out what the enhancements and additions to DB2's optimizer in DB2 10 will do for you.

(Michael Sansoterra) It eventually happens to every developer. You write a stored procedure to return one or more sophisticated result sets to a Java or .NET client. Everyone is (temporarily) happy. Eventually, a need arises for an RPG or COBOL program to execute this stored procedure and process the result set(s). But, alas, high level language programs have no way to open and process a result set (except when using the cumbersome CLI API).

(Pinalkumar Dave) Let�s see another reason why I do not like Views. Regular queries or Stored Procedures give us flexibility when we need another column; we can add a column to regular queries right away.

(Ged Mead) One of the great advantages of WPF is that you can place a wide variety of different content in or on its controls. Buttons are no exception, and you can create more interesting looking buttons by combining some of WPF�s graphics features.

(Henrik Loeser) In two posts in the past, I explained how to say no to invalid data and how to find out what data was wrong and causing errors. With the REJECT INVALID VALUES clause during CREATE INDEX it is possible to reject XML documents that have values in the specified XPath location not compliant with the specified data type. Now the question I got is: What is better, to reject invalid values or to ignore them?

(Edmond Woychowsky) I really like Altova�s MapForce for generating XSLT, but it shares something with every tool that generates XSLT: the warnings in the generated code (Listing A). These warnings essentially say that if you modify the generated code, you can kiss your code goodbye when you regenerate, because your code will be overlaid. While this might sound like Project Genesis to some, there is a way to modify the generated code and survive.

(Luc Bors) A little over two years ago I wrote a post on drag and drop in an adf tree component. That post was based on ADF only. In the following post I show that you can have JHeadstart generate a tree for you that supports drag and drop.

(Kellyn Pedersen) A common initial resolution to reporting requirements without a reporting database is to utilize materialized views. Unfortunately, the cost to refresh these views can be extremely expensive on a database, especially if it's an OLTP that rarely has a lull in activity.

(Charles Hooper) As I am sure that you are aware, there are compatibility problems between Oracle Databases and Oracle Clients that are from different releases. The Oracle Database 11.1 documentation states the following:

(Tim Ford) I make no attempt to hide my dislike for Performance Monitor. Don't get me wrong - it is a good product, but I'm a Transact-SQL kind of guy and I'm at the point after this many years as a SQL Server Professional where I expect to get all my information at the bottom of a white screen in tabular format. Queries, performance information, kids' report cards, letters from my wife... Yes, I'm a SQL Server Management Studio Junkie and I will not change any time soon. What is a guy like me supposed to do when it comes to getting performance information - specifically performance counters that I would expect to see in Performance Monitor (aka PerfMon) - in SSMS?

Featured Article(s) SQL Server 2008 Temporary Tables Optimization Tips In this article, you can find some tips to use SQL Server 2008 temporary tables. Bit Mapping Rewind So I've been playing with Bit Maps and had a few things to share as a follow up of the editorial of 8/20/2010. Like mo...(more)

Microsoft’s new Silverlight-based app provides database management from a browser, a convenience that could be extended to non-cloud databases in time.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft - Houston - SQL Server Management Studio - Economic - Monopolies and Oligopolies

Last Day to Register for the SSIS class... 12 sessions a month of learning, lots of help from SQL Server MVP Eric Johnson, all about SSIS.  You can't go wrong!   Check it out here to get more information - class starts Sept 1! Is There a Shortage of SQL Server Experts? I came ...(more)

New selecTViews Video Posted Today Ben Miller joins me on selecTViews.  We talked about how companies work with developer and DBA teams, what works, what doesn't and a lot more. [Check out the show here] Free Webcast Available Now:  Get Your Implementation Organized When it comes ...(more)

New selecTViews Video Posted Today Ben Miller joins me on selecTViews.  We talked about how companies work with developer and DBA teams, what works, what doesn't and a lot more. [Check out the show here] Featured Article(s) Importing Geospatial data from MS Excel 2010 to SQL Server 2008...(more)

Without the correct table indexes, SQL Server performance will quickly suffer. Here are a few tricks every DBA should know.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - FAQs Help and Tutorials - Programming

Get the basics on working with various system functions in T-SQL to help assess the finer details of your data.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Programming - Microsoft SQL Server - Transact-SQL - Languages - Database

Learn how system functions can be used in T-SQL to view general session and system information along with other types of data in Microsoft SQL Server.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - SQL - Database - Data - FAQs Help and Tutorials

Small companies looking to get started with BI can ensure a successful implementation by following a few important tips.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Business - Business intelligence - Databases - Data Warehousing - Consultants

A Windows staple for years, the Sysprep tool has finally made its way over to the SQL Server world with the release of R2.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Sysprep - Microsoft SQL Server - Windows Server 2008 - FAQs Help and Tutorials - Windows

The use of SQL Server Management Objects streamlines the process of scripting database objects, allowing DBAs and developers to customize code using basic SMO scripting know-how.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database - SQL - Database administrator - Microsoft SQL Server - FAQs Help and Tutorials

Are you a SQL Server 2008 R2 guru? Take the quiz to test your know-how on R2's new and improved BI capabilities.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Database - SQL - FAQs Help and Tutorials

Service Accounts � Web Applications � Application Pools � File Locations � Database Names� when it comes to SharePoint environments, if you don�t plan ahead, your environment can quickly become a disorganized mess of IIS, SQL & SharePoint components. Suddenly you don�t know what web application maps to what application pool in IIS, or even worse, you don�t know what service accounts perform what functions! This session will cover strategies and provide recommendations on ways that SharePoint administrators can reign in their farm � and make sure that no matter who is managing it, everyone is on the same page. Organization is key � and this session will help get you one step closer to organization nirvana. Presented by: Christopher Regan Sponsored by: AvePoint (www.avepoint.com)

With so many possible options and extensions, translating complex SELECT statements can be a challenge. DBAs can clear the air by breaking them down piece by piece.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database administrator - Database - Select - Microsoft SQL Server

Microsoft’s Mark Kromer offers his thoughts on the current state of cloud-based BI and what technologies like SQL Azure and PowerPivot can do for organizations.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft’s Mark Kromer offers his thoughts on the current state of cloud-based BI and what technologies like SQL Azure and PowerPivot can do for organizations.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft - SQL Azure - Microsoft SQL Server - SQL - Business intelligence

Not all certs are created equal, but changes to Microsoft’s certification track over the past few years have left some database professionals curious about what to pursue.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database - SQL - Microsoft - Microsoft SQL Server - FAQs Help and Tutorials

Many database pros dread the hassle of SQL documentation. Fortunately, the right tool can speed up and simplify the process considerably.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database - SQL - Microsoft SQL Server - FAQs Help and Tutorials - Programming

Cool new features may not impress management, but return on investment always will. Speak an executive’s language when making the hard pitch for a SQL Server 2008 R2 upgrade.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Database - FAQs Help and Tutorials - SQL

While the right indexes can boost readability, the wrong ones can really slow down write operations. DBAs need to strike the proper balance to ensure peak performance.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database administrator - Microsoft SQL Server - Database - FAQs Help and Tutorials

Using subqueries with different operators allows admins to collect even more information from T-SQL statement. Learn the basics of each and how to implement them here.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - FAQs Help and Tutorials - Programming

Subqueries in T-SQL give admins flexibility when it comes to analyzing the inner details of subsets of data. Learn how to apply subqueries with this comprehensive rundown.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - FAQs Help and Tutorials - Programming

You have a sponsor for SharePoint development, you have a budget, now where are all the users? Online Collaboration powered by SharePoint is not only a new technology, but a new culture of doing work. In this session we'll explore change management (the fluffy kind) strategies that can be tailored to your user base. Attract users, and keep your budget! Presented by: Adam Levithan Sponsored by: AvePoint (www.AvePoint.com)

With careful planning, DBAs can get similar functionality to Microsoft’s MDS feature -- without migrating to R2 -- by taking advantage of older SQL Server technologies.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Microsoft - Database - Database administrator

Visual Studio 2010 is the latest version of Microsoft’s application development platform, equipped with a slew of add-ons and new features. Learn more about what’s new here.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft Visual Studio - Microsoft - Programming - Languages - Tools

SQL Server Management Objects can be very helpful when used with (or even instead of) T-SQL, particularly when it comes to monitoring database backups and space utilization.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database - SQL - Microsoft SQL Server - FAQs Help and Tutorials - Programming

SQL Server Management Objects can be very helpful when used with (or even instead of) T-SQL, particularly when it comes to monitoring database backups and space utilization.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database - SQL - Microsoft SQL Server - FAQs Help and Tutorials - Programming

Although a pivot table is one component of Microsoft’s BI stack, it takes a lot more to create a full-fledged business intelligence solution.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Business intelligence - Microsoft - Database - Pivot table - Data Warehousing

Log Shipping has been around in one form or another since SQL Server 2000 and many �homegrown� and third-party solutions have recently become available. This session will cover all you need to know about log shipping to use it effectively for high availability. We will look at set up, maintenance, monitoring, and failover. In addition, we will look at other SQL Server objects that you need to account for when using Log Shipping for HA. This session is for beginning to advanced SQL Server DBAs with little or no Log Shipping experience. Presented by: Eric Johnson Sponsored by: Idera (www.idera.com)

Expand even more on T-SQL mathematical functions with this breakdown of algebraic and numeric functions, including details on how they can be used to retrieve data.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - SQL - Database - FAQs Help and Tutorials - Function (mathematics)

Mathematical functions in SQL Server 2008 can connect admins to system information that they may not know exists. Learn to apply these functions in this in-depth breakdown.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - SQL - Database - Function (mathematics) - FAQs Help and Tutorials

Expand even more on T-SQL mathematical functions with this breakdown of algebraic and numeric functions, including details on how they can be used to retrieve data.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - SQL - Database - FAQs Help and Tutorials - Function (mathematics)

Mathematical functions in SQL Server 2008 can connect admins to system information that they may not know exists. Learn to apply these functions in this in-depth breakdown.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - SQL - Database - FAQs Help and Tutorials - Programming

When a database outgrows its server, DBAs have the option of either scaling it out across multiple systems or moving to a more powerful server. Here are the factors to consider.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database - SQL - Microsoft SQL Server - Database administrator - FAQs Help and Tutorials

Midmarket organizations may look to SQL Server 2008 R2 and Microsoft PowerPivot for upcoming BI investments.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Databases - Microsoft - FAQs Help and Tutorials

It’s true, Microsoft has put out a number of new BI technologies for SQL Server 2008 R2, but changes to existing tools like Reporting Services may hold the most value initially.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Microsoft - Windows Server 2008 - Databases - Business intelligence

It’s true, Microsoft has put out a number of new BI technologies for SQL Server 2008 R2, but changes to existing tools like Reporting Services may hold the most value initially.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Microsoft - Business intelligence - Windows Server 2008 - Database

MVPs Brent Ozar and Kevin Kline discuss the implications of Microsoft’s latest cloud computing efforts and what they mean to SQL Server BI, virtualization and more.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft - SQL - Microsoft SQL Server - Database - Cloud computing

MVPs Brent Ozar and Kevin Kline discuss the implications of Microsoft’s latest cloud computing efforts and what they mean to SQL Server BI, virtualization and more.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft - SQL - Cloud computing - Microsoft SQL Server - Database

This session takes you on a end-to-end tour of management features for Analysis Services. Along the way, you�ll learn important best practices direct from the product team about how to configure, optimize and manage your Analysis Server. We expect this to be an essential session for new and experienced Analysis Services administrators alike. Presented by: Donald Farmer Sponsored by: SQL Sentry (www.sqlsentry.net)

Searching databases for specific objects can be frustrating – especially when you can’t recall exactly where said objects are. Fortunately, there are tools out there that can help.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database - SQL - Microsoft SQL Server - FAQs Help and Tutorials - Tools

A business intelligence solution can present data in a variety of ways, such as dashboards, scorecards and reports, but each form has a little something different to offer.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Business intelligence - Database - Business - SQL - Data Warehousing

The power of aggregate functions goes well beyond the basics. This tip demonstrates how to work with grouped data, verify checksums, and retrieve detailed statistics.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Transact-SQL - Aggregate function - Programming

Understanding how to work with aggregate functions can open new doors to the types of information retrieved from your database -- and it may not be as tricky as you think.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database - Microsoft SQL Server - SQL - FAQs Help and Tutorials - Programming

Data-tier applications are among SQL Server 2008 R2’s most talked-about new features, though version-one limitations could minimize their impact in the short term.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Databases - FAQs Help and Tutorials - SQL

PHP isn’t just a Linux language anymore. With the help of a new SDK, developers can incorporate the scripting language with SQL Server reports.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

PHP - Microsoft SQL Server - Microsoft - SQL Server Reporting Services - Database

The company has put the kibosh on unlimited virtualization rights with SQL Server 2008 R2 Enterprise Edition.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Microsoft - Databases - FAQs Help and Tutorials

With the promise of providing simple, self-service BI analysis for users, the time has come to put Microsoft’s new PowerPivot technology through its paces.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Microsoft - Windows Server 2008 - Databases - FAQs Help and Tutorials

Not sure what to make of R2? Here you’ll find answers to some of the most common questions involving the latest database server release from Microsoft.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Databases - Microsoft - Database server

Maintaining a successful BI strategy isn’t always smooth sailing. The best way to avoid big mistakes is to know where others have gone wrong.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Business intelligence - Databases - Business - datawarehousing - Decision Support Tools

Maintaining a successful BI strategy isn’t always smooth sailing. The best way to avoid big mistakes is to know where others have gone wrong.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Business intelligence - Databases - Business - datawarehousing - Decision Support Tools

String functions offer flexibility to your T-SQL statements – once you understand how they work. As you might expect, the best place to start is with the functions themselves.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - Transact-SQL - FAQs Help and Tutorials

There’s plenty more to learn about string functions beyond the basics. Here you’ll find details on more advanced practices, like performing a SOUNDEX analysis.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Transact-SQL - SQL - Database - Programming - language

String functions offer flexibility to your T-SQL statements – once you understand how they work. As you might expect, the best place to start is with the functions themselves.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - Transact-SQL - FAQs Help and Tutorials

There’s plenty more to learn about string functions beyond the basics. Here you’ll find details on more advanced practices, like performing a SOUNDEX analysis.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Transact-SQL - SQL - Database - Programming - language

Stay one step ahead of attackers by testing your SQL Server systems against some of the most common hacking techniques.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Hacker (computer security) - Microsoft SQL Server - Database - FAQs Help and Tutorials

The company’s new database release aims to free up information for non-DBAs while also enforcing compliance.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Database administrator - Databases - Microsoft

The company’s new database release aims to free up information for non-DBAs while also enforcing compliance.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Microsoft - Databases - Database administrator

Configuration is an important first step for setting up Master Data Services. But what about loading the data? Here is the step-by-step process for R2.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Master Data Management - Articles - Database - Business - Data Warehousing

Configuration is an important first step for setting up Master Data Services. But what about loading the data? Here is the step-by-step process for R2.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Master Data Management - Articles - Database - Business - Data Warehousing

When it comes to performance, the most basic techniques can make all the difference. Learn which PerfMon counters to be on the lookout for when tuning your SQL Server environment.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - FAQs Help and Tutorials - Tools

Microsoft has shipped the final technology preview of its new scale-out data warehousing software. The actual launch, however, has been pushed out.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft - Data warehouse - Data Warehousing - Databases - Companies

Don't let the value of BI get lost in technical jargon. This tip explains the purpose and components of a business intelligence system -- in plain English.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Business intelligence - Databases - Data Warehousing - Plain English - Jargon

Don't let the value of BI get lost in technical jargon. This tip explains the purpose and components of a business intelligence system -- in plain English.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Business intelligence - Databases - Data Warehousing - Plain English - Jargon

SQL Server 2008's data collector feature automates the collection of critical performance data, which DBAs can then analyze using brand new SSMS reports.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - SQL Server Management Studio - Database - Database administrator - SQL

A free tool for Microsoft SQL Server could help take the time out of syncing up public and development databases.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Database - Open source - Microsoft - Tools

A free tool for Microsoft SQL Server could help take the time out of syncing up public and development databases.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Database - Open source - Microsoft - Tools

With the launch of Microsoft's SQL Azure Database, it may only be a matter of time before more organizations start putting their data in the cloud.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft - SQL Azure - SQL - Microsoft SQL Server - Databases

With the launch of Microsoft's SQL Azure Database, it may only be a matter of time before more organizations start putting their data in the cloud.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft - SQL Azure - SQL - Microsoft SQL Server - Databases

Matrix tables display data similar to pivot tables, but setting them up for SQL Server requires an understanding of the basic components.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - PivotTable - Data

Want to know what the matrix is? With SQL Server, just like the movie, it's best to see it for yourself.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Microsoft SQL Server - Database - FAQs Help and Tutorials - Programming

There is more to setting up a matrix table than the basics. Here are some advanced techniques for tweaking your tables to best display your data.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Shopping - Video game - Programming - Games - Massive Multiplayer Online

Matrix tables display data similar to pivot tables, but setting them up for SQL Server requires an understanding of the basic components.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - PivotTable - Data

Want to know what the matrix is? With SQL Server, just like the movie, it's best to see it for yourself.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - FAQs Help and Tutorials - Programming

There is more to setting up a matrix table than the basics. Here are some advanced techniques for tweaking your tables to best display your data.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Shopping - Video game - Programming - Games - Massive Multiplayer Online

Check out this list of custom functions for basic string manipulation – a great skill for any database professional.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - String (computer science) - FAQs Help and Tutorials

Check out this list of custom functions for basic string manipulation – a great skill for any database professional.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - String (computer science) - FAQs Help and Tutorials

One of SQL Server 2008 R2's most talked-about new features allows DBAs to monitor the performance of multiple instances with a single glance.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Database administrator - Database - FAQs Help and Tutorials

Find out exactly which database backup and recovery models you'll need for a full backup and restore of a SharePoint-associated SQL Server database.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Backup - SQL - Microsoft SharePoint - Database - Microsoft SQL Server

Manual testing for SQL injection requires a lot of effort with little guarantee that you'll find every vulnerability. Fortunately, there is a better way.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL injection - Test automation - Security - Programming - SQL

It's not uncommon for DBAs to be lulled into a false sense of security by log shipping, without realizing the negative effects it could have on disaster recovery.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database administrator - Database - Recovery time objective - Disaster recovery - Microsoft SQL Server

The first step to putting a geospatial map in an SSRS report involves creating what's known as the polygon layer. This tip explains what that means and how to get started.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL Server Reporting Services - Programming - Languages - Microsoft - SSRS

Like an onion or parfait, maps in SQL Server Report Builder have many layers. Here you'll learn how to finish off a map by adding point and tile layers in your report.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - FAQs Help and Tutorials - Programming

The new spatial and analytic mapping functionality in Microsoft Report Builder is a great way to generate more dynamic SSRS reports – once you know how to create them.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Microsoft - SQL Server Reporting Services - Databases - FAQs Help and Tutorials

The new spatial and analytic mapping functionality in Microsoft Report Builder is a great way to generate more dynamic SSRS reports – once you know how to create them.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Microsoft - SQL Server Reporting Services - Databases - FAQs Help and Tutorials

A lot's different in Microsoft's upcoming SQL Server release. Check out our list of the 10 most significant changes.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Microsoft - Windows Server 2008 - Database - SQL Server

Report Builder can be an extremely useful tool for generating reports in SSRS. This page provides resources on how to properly utilize all of its functionality.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - SQL Server Reporting Services - FAQs Help and Tutorials

We've tallied a Top 10 collection of backup and recovery tips for 2006. View the complete list where database restores of different shapes and sizes took the majority of slots.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Backup - Database - Microsoft SQL Server - Site Management - Tools


Select a random row with MySQL:

SELECT column FROM table  ORDER BY RAND()  LIMIT 1  

Select a random row with PostgreSQL:

SELECT column FROM table  ORDER BY RANDOM()  LIMIT 1  

Select a random row with Microsoft SQL Server:

SELECT TOP 1 column FROM table  ORDER BY NEWID()  

Select a random row with IBM DB2

SELECT column FROM table  ORDER BY RAND()  FETCH FIRST 1 ROWS ONLY  
2008 scandalz.net
We have only two things to worry about: That things will never get back to normal, and that they already have.
CountryUS
IP Address38.107.191.94
User AgentCCBot/1.0 (+http://www.commoncrawl.org/bot.html)