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

Popular Content

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,267 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: MSSQLTips.com | Category: sql server 2016
Rating:  Rate this |   Briefcase | 5,700 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,192 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: MSSQLTips.com | Category: azure sql database
Rating:  Rate this |   Briefcase | 4,823 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 2015/10/14 | Source: SQLServerCentral.com | Category: over clause
Rating: |  Discuss |   Briefcase | 17,753 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: ssis
Rating:  Rate this |   Briefcase | 4,968 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,265 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: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 12,802 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,670 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: SQLServerCentral.com
Rating:  Rate this |   Briefcase | 3,968 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 | 3,845 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 | 6,991 reads

SQL Server CROSS APPLY and OUTER APPLY

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: MSSQLTips.com | Category: cross apply
Rating:  Rate this |   Briefcase | 6,927 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,323 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: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 3,553 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,185 reads

Azure SQL Database – How to Choose the Right Service Tier

So you've decided to use Azure SQL Database. You head for the portal and are suddenly faced with a number of questions. Sure, the choices you make have a number of repercussions, but what are they? Murilo Miranda provides a simple guide to get started.  Read more...
By Additional Articles 2016/09/08 | Source: SimpleTalk | Category: azure sql database
Rating:  Rate this |   Briefcase | 3,149 reads

Database Lifecycle Management: Deployment and Release

So often, the unexpected delays in delivering database code are more likely to happen after the developers initiate the release process. The necessary checks and tests can turn up surprises: The handover process can expose deficiencies. With good teamwork, planning and forethought, though, the process can be made almost painless.  Read more...
By Additional Articles 2016/08/05 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 3,458 reads

Using LAST_VALUE

When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!  Read more...
By Kathi Kellenberger 2016/06/03 (first published: 2015/04/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,194 reads

Clone, Sweet Clone: Database Provisioning Made Easy?

One of the difficulties of designing a completely different type of development tool such as SQL Clone is that you have to explain what it is for, but when its use is open-ended it can be exciting to see the novel uses that come out of the early-access program.  Read more...
By 2016/08/08 | Source: SimpleTalk | Category: sql clone
Rating:  Rate this |   Briefcase | 3,287 reads