Email Alerts
-
Microsoft SQL Server, PDW reach out to Hadoop for big data processing
In this Q&A;, Microsoft’s Mark Kromer discusses the company’s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access.Q&A; | 13 Sep 2011
-
Top five features in SQL Server Developer Tools
SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features.Tip
-
SQL Server Denali, R2, XP: What sizzles, what doesn’t this summer
With the latest SQL Server Denali CTP out, Microsoft exec Mark Kromer discusses updates and addresses blogosphere buzz about what Denali’s not running on.Feature
-
SQL Server Denali overshadows the Azure cloud for attendees at Microsoft TechEd
Cloud was the word at Microsoft TechEd, but attendees’ interest was rooted in SQL Server Denali, the upcoming version of the database that will be released in a CTP this summer.News | 20 May 2011
-
Top reasons to get started with SQL Server Denali
The upcoming SQL Server Denali is chock-full of new features, such as super-fast column-store indexes and a new Web-based reporting tool. But what does it mean for businesses?Feature
-
Finally, development across platforms in Microsoft Visual Studio 2010
Microsoft says Project Juneau, its toolset for Microsoft Visual Studio 2010 expected to be rolled out with the upcoming SQL Server Denali, will break new ground in development.Feature
-
multidimensional expressions (MDX)
multidimensional expressions (MDX)Definition
-
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
- VIEW MORE ON : Database Design and Modeling
-
Eight ways that SQL Server developers hurt performance
Application developers who access SQL Server can affect server performance without knowing it. Here are eight things SQL Server developers often do wrong.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
-
Creating Windows PowerShell scripts to manage SQL Server 2008 instances
Creating Windows PowerShell scripts helps manage SQL Server 2008 objects, databases and other instances. This tip covers two PowerShell snap-ins that aid the navigation of the SQL Server component hierarchy.Tip
-
Code to restore SQL Server databases in VB.NET
Learn how to restore a SQL Server database in VB.Net using this ADO.Net code sample provided by our expert.Ask the Expert
-
Retrieve images from SQL Server and store in VB.Net
Having difficulty retrieving images from a SQL Serve database to a VB.Net application? Get best practices to retrieve, store and manage SQL Server images.Ask the Expert
-
Connect to SQL Server database with Visual Basics
Find how to connect to a SQL Server database using Visual Basics 6.0.Ask the Expert
-
.NET database object security
No discussion of the new CLR features would be complete without a description of the security issues associated with using .NET assemblies and the SQL Server CLR. Find out how you can improve your CLR security.Tutorial
-
User-Defined Types
Another important new feature in SQL Server 2005 that is enabled by the integration of the .NET CLR is the ability to create true user-defined types (UDTs). Learn the best ways to utilize them in this chapter excerpt.Tutorial
-
User-Defined Functions
Creating .NET-based user-defined functions (UDFs) is another new feature that's enabled by the integration of the .NET CLR. Learn more about them in this chapter excerpt.Tutorial
-
Encryption failures when upgrading to SQL Server 2005
There are several criteria required for certificates to be properly loaded by SQL Server 2005, when upgrading. SQL Server 2005 expert Adam Machanic addresses concerns.Ask the Expert
- VIEW MORE ON : .Net Development
-
An introduction to XML shredding for SQL Server
It's critical to understand the effects XML shredding can have on your database environment before selecting a particular shredding approach.Tip
-
Processing XML files with SQL Server functions
The procedure of loading XML files onto a SQL Server database and processing them into tables is not well documented. Discover a prescribed method that uses both SQL Server functions and XPath expressions.Tip
-
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
SQL Profiler is an efficient tool for tuning and troubleshooting Microsoft Analysis Services 2005, that is, unless you're managing numerous instances. In this tip, you'll learn how to use XMLA to automate tracing to monitor MSAS. Here's what you need to know to create, alter and delete traces with ease.Tip
-
Create a computed column in SQL Server using XML data
In this tip, SQL Server expert Robert Sheldon demonstrates how to create a function that runs the XQuery expression and then use that function within your computed column definition.Tip
-
Create DDL table in SQL Server 2005 to audit DDL trigger activity
Each time DDL statements in SQL Server 2005 make changes with commands, such as CREATE TABLE and ALTER, the DDL trigger fires an event. It's possible to log these events with an audit table and custom-made DDL trigger. In this tip, SQL Server expert Robert Sheldon walks you through designing the audit table, defining the DDL trigger and then testing the auditing solution.Tip
-
Retrieve XML data values with XQuery in SQL Server 2005
When you want to access specific XML data values -- instead of XML as a single data type value -- the XQuery is the scripting language you're looking for. Microsoft designed XQuery specifically to access XML data in SQL Server 2005, allowing you to retrieve XML columns, variables and parameters. In this tip, you'll learn how to use two XQuery methods within your T-SQL statements: Value() to retrieve a single XML value and Query() to retrieve multiple XML values.Tip
-
XML data type in SQL Server 2005 vs. VARCHAR (MAX)
When choosing to use the XML data type or the VARCHAR (MAX) data type, in SQL Server 2005, DBAs and developers should know the potential performance impact of each. Here's a look at two tables, one inserted and queried with XML and the other with the VARCHAR (MAX) data type. Take a look at the CPU and I/O results and make the best data type choice for your SQL Server environment.Tip
-
XQuery
XQuery is a specification for a query language that allows a user or programmer to extract information from an Extensible Markup Language (XML) file or any collection of data that can be XML-like.Definition
-
Commerce XML (cXML or Commerce Extensible Markup Language)
Commerce XML (cXML) is a standard for the online exchange of business transaction information in common formats.Definition
-
How to display the XML result of 'Select For XML Explicit'
Ask the Expert
- VIEW MORE ON : XML