Some SQL Server features are good, some are great -- and some are great only in the right situations and in the right hands. In a preview of what's coming in her Live!360 session, Lopez recently ...

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

Code Focused Generating .NET POCO Classes for SQL Query Results A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO ...

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.

A query designer for Microsoft SQL Server data sources. Enhancements to the Report Builder 2.0 ribbon. The following operating systems are supported: Server 2003, Server 2008, Vista SP1, XP SP3.

SQL Server 2016 offers a new tool for performance tuning called Query Store. This holds metrics that let you quickly see when an execution plan change has negatively impacted the database.

I'm not sure if that's the right term, but how do I list records that are not matched to records in another table? I am joining 2 tables right now, tblPerson and tblHat, which are designed and ...

This is really driving me crazy.I'm putting together a very basic report and I have my text boxes spaced out on the page which I am using to label my fields.TextBox :NAME then the next thing is ...

Here's a look at different ways to query Hadoop via SQL, some of which are part of the latest edition of MapR's Hadoop distribution ...