Email Alerts
-
Speed up execution times in Microsoft SQL Azure
Compare the time cost of database calls to SQL Azure versus calls to a local server and get recommendations for improving the speed of database calls to SQL Azure.Tip
-
SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing
With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are.News | 14 Mar 2012
-
Microsoft SQL Server 2012 pricing, licensing packed with changes
SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing.Tip
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
SQL Server stored procedures supercharged in recent, upcoming versions
Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release.Tip
-
Microsoft StreamInsight charts course in unfamiliar waters
Microsoft StreamInsight, a complex event processing product, is a stab at a whole new space for the company, and not a bad one at that, experts say.News | 20 Oct 2011
-
SQL Server 2008 R2 SP1 not earth-shaking, but useful
SQL Server 2008 R2 Service Pack 1 has a number of new features, including a query hint, new system objects and support for up to 15,000 partitions.Tip
-
Parallel Data Warehouse has speed, space, special requirements
Microsoft Parallel Data Warehouse is not like other software. The appliance for SQL Server 2008 R2 allows for mammoth workloads; it also has some specific data loading procedures.Tip
-
Putting the data to work: How to create a chart in PowerPivot
Importing Microsoft SQL Server data into PowerPivot is the first step; now you’re ready to do some reporting. Get instructions on how to populate and refine charts in PowerPivot.Feature
-
Putting SQL Server catalog views to work
SQL Server catalog views are system views that provide an interface to a wide range of catalog metadata, including information about security objects, full-text search, database mirroring, partitions and more. Read on for an in-depth look at several subcategories of catalog views.Tip
- VIEW MORE ON : SQL Server 2008 R2
-
Five things in SQL Server not in SQL Azure
With the excitement over the cloud, it’s easy to forget that Microsoft’s cloud database, SQL Azure, is not for everyone. Learn the five major differences between SQL Azure and SQL Server.Tip
-
SQL Server stored procedures supercharged in recent, upcoming versions
Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release.Tip
-
Getting the most out of SQL Server information schema views
SQL Server information schema views let you access metadata about database objects such tables and columns. Learn how you can access the views to retrieve relevant information.Tip
-
On the server level with SQL Server dynamic management views
The pantheon of dynamic management views (DMVs) extends beyond the database-related views covered in the first of two articles focusing on this SQL Server feature. Learn about DMVs that operate at the server level and provide information about a SQL Server instance and the system supporting it.Tip
-
Gain insight with SQL Server dynamic management views
Dynamic management views, a feature in SQL Server 2005 and newer, let users say goodbye to complex queries for retrieving database information. In the first of this two-part series, have a look at a sampling of SQL Server DMVs and the database info they call up.Tip
-
Microsoft gives tour of new release of SQL Server
Microsoft gave PASS Summit 2010 attendees a walk-through of its Denali SQL Server release, demoing its AlwaysOn, FileTable and expanded SQL Server Integration Services features.News | 11 Nov 2010
-
Latest SQL Server 2008 service pack beefs up R2 support
In addition to the usual updates and hotfixes, SQL Server 2008 SP2 will take better advantage of R2’s multi-server management and DAC capabilities.News | 16 Jul 2010
-
Seizing stats and grouped data with T-SQL aggregate functions
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.Tip
-
The nuts and bolts of T-SQL aggregate functions in SQL Server 2008
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.Tip
-
Data collection the automated way in SQL Server 2008
SQL Server 2008's data collector feature automates the collection of critical performance data, which DBAs can then analyze using brand new SSMS reports.Tip
- VIEW MORE ON : SQL Server 2008
-
SQL Server Service Broker Tutorial and Reference Guide
Discover the basics of the SQL Server Service Broker, including a general overview on how this addition to SQL Server works.Learning Guide
-
Microsoft reiterates promise of SQL Server 2005 SP3
SQL Server 2005 database administrators and managers will be happy to know that a third service pack will be here shortly.Article | 21 Oct 2008
-
SQL Server consolidation: Why it's an optimization technique
SQL Server consolidation -- a.k.a., the fix for SQL Server sprawl -- provides ease of management, improved availability and lower licensing costs.Tip
-
Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
Retrieving a hierarchy with recursive relationships in SQL can get difficult to manage -- very quickly. Learn how to easily implement this type of relationship with a parent-child dimension using Microsoft's Analysis Services MDX.Tip
-
Troubleshoot Web service issues in SQL Server 2005 Reporting Services
Learn why your Web service in SQL Server 2005 Reporting Services (SSRS) is not responding. You could be missing Reporting Services configurations.Ask the Expert
-
SSIS error message due to installation problem on SQL Server 2005
If you are receiving an error message in SQL Server Integration Services (SSIS), your problem might be with the installation of the SQL Server 2005 client tools.Ask the Expert
-
Should you upgrade to SQL Server 2005 or SQL Server 2008?
Even though SQL Server 2005 was released almost three years ago, many companies haven't upgraded yet. With last week's release of SQL Server 2008, it's time to put some serious thought into an upgrade. SQL Server expert Roman Rehak examines the options: to follow the sequential upgrade path or skip SQL Server 2005 altogether. Considerations include licensing costs, database size, benefits of the new features and confidence – or lack thereof – in the newest version.Tip
-
Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
Understanding date/time data types in SQL Server can be difficult, especially when you add TIMESTAMP into the mix. In this tip, you'll learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as it's often confused with these two primary date/time data types.Tip
-
How to configure Database Mail in SQL Server 2005 to send mail
Sending mail via SQL Server has become a much more reliable process. Here, SQL Server expert Roman Rehak explains how to configure Profiles and Accounts within the Database Mail architecture for sending and monitoring email.Tip
-
How to use rank function in SQL Server 2005
SQL Server 2005 T-SQL includes a set of functions that let you rank the rows in your result set. SQL Server expert Robert Sheldon defines and gives examples of how to use the four ranking functions: ROW_NUMBER, RANK, DENSE_RANK and NTILE. Include one or more of these functions in your query SELECT clause and automatically assign a rank to each row in your result.Tip
- VIEW MORE ON : SQL Server 2005
-
Track changes to SQL Server 2000 and 2005 with one simple utility
As a DBA, you need to be aware of what's happening within your SQL Servers. But if you have dozens of SQL Servers -- both 2000 and 2005 models -- and permissions are shared, you'll have to go beyond the limits of triggers.Tip
-
Is it possible to find disabled indexes in SQL Server 2000?
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know.Ask the Expert
-
Q&A;: Create and tune indexes in SQL Server 2000
DBAs can build a SQL Server index best designed for their database environments by learning about columns, clustered indexes, and more.Tip | 23 Oct 2007
-
Quiz: Database Basics
Directions: - After reading the question, click on the answer that you think is correct.Quiz
-
FAQ: Creating and altering SQL Server tables
Whether you want to select rows, move records, track activity or perform various other table-related tasks, this collection of frequently asked questions offers expert insights to help.FAQ
-
flat file
A flat file is a file containing records that have no structured interrelationship.Definition
-
OLE DB (OLEDB or Object Linking and Embedding Database)
OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources.Definition
-
comma-separated values file (CSV)
In computers, a CSV (comma-separated values) file contains the values in a table as a series of ASCII text lines organized so that each column value is separated by a comma from the next column's value and each row starts a new line.Definition
-
Fast Guide: SQL Server 2000 commands
Here are ten commands you need to know!Definition
-
relational database
A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.Definition
- VIEW MORE ON : SQL Server 2000