Additional Articles

The Internet of Things: A New World Order?

by Additional Articles

SimpleTalk

Was the marketing hook 'The Internet of Things' conjured up before the technical definition? Are we being persuaded to spend money on fending off yet another fantasy tsunami of data? Already, we have televisions that listen to, and report, your conversations; so are we facing the Science Fiction future of gadgets that report where you go, who you visit and what medications you take? As Robert Sheldon says; "It's big, almost too big to get your arms around".

2015-04-10

11,037 reads

Creating a multi-option parameter report for SQL Server Reporting Services

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

If you have a reporting requirement where users want to enter report parameters by either selecting values from a dropdown list or entering To and From range values, Ghanesh Prasad explains how to accomplish this in a Reporting Services report?.

2015-04-09

9,591 reads

Painless Refactoring of SQL Server Database Objects

by Additional Articles

SimpleTalk

Database objects

Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive Database Programming with SQL Server, Alex Kuznetsov discusses several techniques that will harden your code, so that it will not break, or behave unpredictably, as a result such changes.

2015-04-08

11,414 reads

Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table

by Additional Articles

MSSQLTips.com

Deleting Data

In this tip, Daniel Farina explains an unconventional way of deleting millions of old records from a table which is accessed by a system 24x7, and without impacting that system.

2015-04-07

10,661 reads

Introduction to SQL Server Spatial Data

by Additional Articles

SimpleTalk

Spatial Data

More and more applications require the handling of geospatial data. It is easy to store spatial data, but it takes rather more thought to retrieve and manipulate it. Tasks like searching neighborhoods, and calculating distances between points is often required from databases. But how do you start? Roy and Surenda take you through the basics.

2015-04-06

9,426 reads

Azure Active Directory - Schema Extensions

by Additional Articles

Just Azure

Active Directory

The Azure Active Directory Graph API enables some interesting scenarios that you can implement in your applications by enabling you to query and manipulate directory objects in Azure AD. In this article, Rick Rainey provides a clear walkthrough of its implementation.

2015-04-03

6,836 reads

A More Versatile SQL Server Random Number Function

by Additional Articles

MSSQLTips.com

Random Numbers

Image a situation when you use the SQL Server RAND() T-SQL function as a column in a SELECT statement, and the same value is returned for every row as shown below. In this tip, Dallas Snider explains how you can get differing random values on each row.

2015-04-02

10,277 reads

Deploying the same database to many different RDBMSs

by Additional Articles

SimpleTalk

humor

With the idea of a generic Dacpac defined by international standard, comes the potential for a Visual Studio developer to use SSDT to create a generic database model to a SQL-92 compliant standard that can then be deployed to any one of the major RDBMSs. The same database model would be deployable to Oracle, MySQL, or SQL Server, for example. Professor Hugh Bin-Haad explains the reasoning and technology behind this.

2015-04-01

11,218 reads

Getting Started with Database Engine Tuning Advisor in SQL Server – Part 2

by Additional Articles

Database Journal

Database Engine Tuning Advisor

Arshad Ali demonstrates how you can use the command line interface to tune SQL queries and how you can use SQL Server Profiler to capture the workload for tuning with Database Engine Tuning Advisor.

2015-03-31

9,734 reads

Identifying and Solving Index Scan Problems

by Additional Articles

SimpleTalk

query plan

When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once you've identified the queries, what next? Dennes Torres gives some preliminary guidelines on how to find out why these index scans are being chosen for these queries and how to make the queries run faster and more efficiently.

2015-03-30

9,858 reads

All authors

Additional Articles

The Internet of Things: A New World Order?

Creating a multi-option parameter report for SQL Server Reporting Services

Painless Refactoring of SQL Server Database Objects

Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table

Introduction to SQL Server Spatial Data

Azure Active Directory - Schema Extensions

A More Versatile SQL Server Random Number Function

Deploying the same database to many different RDBMSs

Getting Started with Database Engine Tuning Advisor in SQL Server – Part 2

Identifying and Solving Index Scan Problems

Blogs

The DIY Cost of Masking Test Data For Smaller Organizations

T-SQL Tuesday #196 – Two risky career decisions I made

T-SQL Tuesday #192: What career risks have you taken?

Forums

XACT_ABORT being set to ON by web services

OPENQUERY Flexibility

A Full Shutdown

Question of the Day

OPENQUERY Flexibility