Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Popular Content

Predicates With Subqueries

The ALL, SOME and ANY predicates aren't much used in SQL Server, but they are there. You can use the Exists() predicate instead but the logic is more contorted and difficult to read at a glance. Set-oriented predicates can greatly simplify the answering of many real-life business questions, so it is worth getting familiar with them. Joe Celko explains.  Read more...
By Additional Articles 2016/10/03 | Source: SimpleTalk | Category: predicates
Rating:  Rate this |   Briefcase | 6,361 reads

SQL Server Access Control: The Basics

No technology yet invented can in any way allow us to neglect the task of ensuring the security of the database by controlling access. Security must be applied in depth, and the database is designed provide a system that will thwart even the most determined external attack. If it seems a bit complicated at first, that is no longer an excuse now that Rob Sheldon has provided this simple guide for getting started.  Read more...
By Additional Articles 2016/08/25 | Source: SimpleTalk | Category: simple talk
Rating:  Rate this |   Briefcase | 6,456 reads

SQL Server for Linux

Although SQL Server for Linux removes the concern that adopting SQL Server forces you to also adopt the Windows platform, it could also provide a useful alternative platform, and a more obvious alternative to Oracle. There are, however, several obvious concerns as to how such a product could ever achieve parity with the existing Windows-based product. Microsoft have made an interesting move with several ramifications, as Robert Sheldon explains.  Read more...
By Additional Articles 2016/09/30 | Source: SimpleTalk | Category: linux
Rating:  Rate this |   Briefcase | 5,349 reads

New Drop If Exists Syntax in SQL Server 2016

When writing T-SQL code, we often write code to check if the database object exists first and then take some action. In this tip John Miner covers the new and easier way to do this in SQL Server 2016.  Read more...
By Additional Articles 2016/09/01 | Source: | Category: sql server 2016
Rating:  Rate this |   Briefcase | 5,892 reads

Understanding the OVER clause

Having a solid knowledge of the window functions if vital to high performance T-SQL Code. The key to these functions is how the OVER clause is used. This article will dive into how to use the OVER clause.  Read more...
By Wayne Sheffield 2016/09/30 (first published: 2015/10/14) | Source: | Category: over clause
Rating: |  Discuss |   Briefcase | 21,586 reads

Formatting SQL Code - Part the Second

When you're formatting SQL Code, your objective is to make the code as easy to read with understanding as is possible, in a way that errors stand out. The extra time it takes to write code in an accessible way is far less than the time saved by the poor soul in the future, possibly yourself, when maintaining or enhancing the code. There isn't a single 'best practice, but the general principles, such as being consistent, are well-established. Joe Celko gives his take on a controversial topic.  Read more...
By Additional Articles 2016/08/30 | Source: SimpleTalk | Category: simple talk
Rating:  Rate this |   Briefcase | 7,376 reads

Import data from Azure SQL to Tabular Databases

Daniel Calbimonte shows how to create an Azure SQL Database with the AdventureworksLT data, and how to import the information into a SQL Server Analysis Services Tabular Model Database.  Read more...
By Additional Articles 2016/08/26 | Source: | Category: azure sql database
Rating:  Rate this |   Briefcase | 4,914 reads

Creating PowerShell Stacks and Expression Evaluators

To demonstrate that dynamic modules in PowerShell can be used to easily create objects with methods and properties, Phil Factor implements an expression analyser written in PowerShell, using a variation of Dijstra's Shunting Algorithm.  Read more...
By Additional Articles 2016/09/16 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,732 reads

Going Interactive with C#

For some time now, C# programmers have gazed enviously at the interactive capabilities of F#, Python and PowerShell. For rapid prototyping work and interactive debugging, dynamic languages are hard to beat. C# Interactive slipped into view quietly, without razzmatazz, in Visual Studio 2015 Update 1. It's good, it's worth knowing about; and Tom Fischer is intent on convincing you of that.  Read more...
By Additional Articles 2016/10/11 | Source: SimpleTalk | Category: .net
Rating:  Rate this |   Briefcase | 4,162 reads

SSIS in SSDT: The Basics

SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially. Rob Sheldon provides a beginner's guide to get you started with using SSIS with Visual Studio and SQL Server Data Tools (SSDT).  Read more...
By Additional Articles 2016/08/11 | Source: SimpleTalk | Category: integration services (ssis)
Rating:  Rate this |   Briefcase | 5,116 reads

Software Animism

Have you ever accused an application of deliberately trying to make your life a misery? Simple Talk's Tony Davis talks animism in this week's editorial, and wants to hear your stories in the comments for the chance to win a $50 Amazon gift card.  Read more...
By Additional Articles 2016/08/22 | Source: SimpleTalk | Category: simple talk
Rating:  Rate this |   Briefcase | 4,417 reads

Strengthening the Foundations of Software Architecture

The term 'Architecture' seems to imply a plan that you can't easily subsequently deviate from. It's true that, if you abandon software architecture, you end up with a big ball of mud, but maybe the art of software is to make change much easier by planning how to implement each feature, tackling dependency issues, splitting functionality into small discrete components and considering how they should interact with each other.  Read more...
By Additional Articles 2016/08/02 | Source: SimpleTalk | Category: architecture
Rating:  Rate this |   Briefcase | 4,785 reads

Datetime vs. Datetime2

Read a short comparison of datetime and datetime2 types. Learn about their structure, as well as the advantages and disadvantages of each.  Read more...
By Robert Hartmann 2016/01/05 | Source: | Category: datetime
Rating: |  Discuss |   Briefcase | 12,836 reads

An Introduction to In-Memory OLTP Database Objects

In-memory OLTP was introduced in SQL Server 2014, but greatly improved in SQL Server 2016. If you have a heavily-used transaction-processing that is processing a lot of data, it is definitely worth considering the new 'In-Memory' features of SQL Server 2016. Grant Fritchey explains why.  Read more...
By Additional Articles 2016/09/19 | Source: SimpleTalk | Category: in-memory oltp
Rating:  Rate this |   Briefcase | 4,107 reads

DBA Salary Survey

We're running a salary survey to find out what database professionals earn in the real world. The survey is completely anonymous, and the results will be published here in a few weeks time.  Read more...
By 2016/08/11 | Source:
Rating:  Rate this |   Briefcase | 4,078 reads

Bones of SQL - The Calendar Table

This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.  Read more...
By Bob Hovious 2016/09/08 | Source: | Category: calendar
Rating: |  Discuss |   Briefcase | 4,173 reads

Direct Query with Power BI

Power BI allows you to connect directly to the data just as if it were a “standard” connection, and modify and extend the data to support analytics. By using DirectQuery, you can build reports based on extremely large datasets where re-importing data not a practical solution. It also allows you to do data aggregations on the server. There are, of course, restrictions as well but it is nevertheless a worthwhile technique to use where appropriate. Adam Aspin explains all.  Read more...
By Additional Articles 2016/09/13 | Source: SimpleTalk | Category: bi
Rating:  Rate this |   Briefcase | 3,590 reads

The Top 4 Job Tasks DBAs Forget

It’s easy to get caught up in daily incidents, tickets, and special projects. Like a good scout, though, a core task in a DBA’s job is to be prepared.  Read more...
Rating:  Rate this |   Briefcase | 7,111 reads


Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.  Read more...
By Additional Articles 2016/02/17 | Source: | Category: cross apply
Rating:  Rate this |   Briefcase | 7,015 reads

Planning for a Successful Database Lifecycle

Although it is well-known that the best efforts of a development team can be derailed by mistakes in the architecture, design and general governance of a development project, few attempts have been made to describe what needs to be done to increase the chances of success in the development of a database application. William Brewer steps into the breach to itemise what a delivery team needs to succeed.  Read more...
Rating:  Rate this |   Briefcase | 4,416 reads