Email Alerts
-
In 2011, SQL Server market trending toward cloud, virtualization
Higher SQL Server cloud adoption with more competition and SQL Server virtualization will get top billing in the SQL Server market in 2011, experts predict. Plus, self-service BI is on the up and up, along with solid-state devices.News | 13 Jan 2011
-
Warned about table changes in SSMS? Here’s a workaround
Editing tables in SQL Server Management Studio and getting this warning, “Saving changes is not permitted”? It happens when the table needs to be re-created. But don’t fret. This change in SQL Server 2008 R2 can be undone with a simple tweak.Tip
-
Microsoft releases new parallel data warehouse, previews Denali
Microsoft detailed its new parallel data warehouse capabilities and a cloud-based support offering, and also provided a glimpse of what's to come in the next SQL Server release.News | 09 Nov 2010
-
SQL Server merge replication using IIS
In older versions of SQL Server, securely replicating data between sites or companies was not easy to do. Microsoft SQL Server merge replication simplifies the process using Internet Information Services (IIS).Tip
-
Where to look next for BI applications? Try the cloud
PowerPivot, SQL Azure and ‘Dallas’ combine to create BI applications in the cloud. Is that integration seamless and is it even for you?Tip
-
Microsoft Visual Studio 2010 spotlight
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.IT SPOTLIGHT
-
Microsoft brings PHP integration to SQL Server Reporting Services
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.Tip
-
New tool puts Oracle in the hands of SQL Server developers
Microsoft and Quest have banded together to help put development for SQL Server and Oracle databases under the same umbrella.Article | 08 Apr 2010
-
New tool puts Oracle in the hands of SQL Server developers
Microsoft and Quest have banded together to help put development for SQL Server and Oracle databases under the same umbrella.News | 08 Apr 2010
-
Open source tool simplifies database synchronization for SQL Server
A free tool for Microsoft SQL Server could help take the time out of syncing up public and development databases.Tip
- VIEW MORE ON : Database Design and Modeling
-
VB.NET timing out when backup changed to hourly
After changing transaction log backups from daily to hourly, one ITKnowledge Exchange member noticed that VB.NET was timing out. Find out what advice his peers have to offer.ITKnowledge Exchange Memb
-
SQL Server consolidation pros and cons
See if SQL server consolidation is right for you with this checklist, taken from Chapter 1 of our e-book, Consolidate SQL Servers for availability, scalability and cost savings.Checklist
-
Chapter 1: The case for SQL Server consolidation
This SearchSQLServer.com expert e-book, Consolidate SQL Servers for availability, scalability and cost savings by SQL Server MVP Hilary Cotter, will introduce you to the worlds of server and storage consolidation. In Chapter 1, Hilary will give you an overview of the causes and pitfalls of SQL Server sprawl, provide avenues for addressing such problems and help you identify exactly what may or may not need to be consolidated in your SQL Server environment. He includes a list of questions to help you decide if consolidation will meet you needs.Chapter Download
-
Permissions error when connecting .NET
Greg Low helps troubleshoot an error message from trying to connect a project developed in .NET.Ask the Expert
-
Developing a table-like structure in Visual Basic
Expert Greg Low explains how to create table-like structures in Visual Basic, so they are not connected to any database.Ask the Expert
-
Using DISTINCT in a SQL query
Development expert Greg Low explains the purpose of DISTINCT and how to send a query to SQL Server from VBA.Ask the Expert
-
Changing date format of a flat file using VB.NET
Development expert Greg Low explains how to use VB.NET to format a flat file into the datetime SQL datatype format.Ask the Expert
-
Retrieving Excel data for an application
Development expert Greg Low offers an approach for querying an MS Excel database.Ask the Expert
-
Face-off: Oracle vs. SQL Server
Two site editors square off on the topic of SQL Server versus Oracle, a debate with equally loud fans on either side of the issue.Article | 14 Sep 2005
-
Connecting Visual Basic to SQL Server
If you've had trouble connecting Visual Basic to SQL Server, let expert Andrew Novick offer some basic advice to get you started.Ask the Expert
- VIEW MORE ON : .Net Development
-
Date defends relational model
Chris Date, a renowned proponent of the relational model, takes on SQL, XML and all things object-oriented in a fiesty keynote address at the DAMA symposium this week.Article | 02 Mar 2005
-
Try the XML View Mapper
What it gives you, what it can do.Tip
-
SQL Server support for XML
New clause that allows easy data manipulation.Tip
-
SQL Server 2000 and XML
A look at some of SQL Server 2000's integrated XML support.Tip
-
Get SQL Server table structure in XML format
Here is a quick stored procedure in SQL Server 2000 that returns the table structure in XML format.Tip
-
Retrieving newly-inserted primary keys in SQL Server 2000
How to use @@IDENTITY, SCOPE_IDENTITY and IDENT_CURRENT to retrieve newly-inserted primary keys in SQL Server 2000.Tip
-
Inside look at SQLXML technologies
This chapter describes how SQL Server's XML technologies are designed and how they fit together from an architectural standpoint.Tip
-
Transferring SQL Server data into XML format
Ask the Expert
-
Return all values in a comma-delimited string
This script will return one big string where the rows are separated by a comma.Tip
-
Returning a result set in random order
At times you might need to return the SQL Server data to the client in a random order. Here's how.Tip
- VIEW MORE ON : XML