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

Popular Content

A Big Deal : SQL Server 2016 Service Pack 1

Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.  Read more...
By Additional Articles 2016/12/13 | Source: SQLPerformance.com | Category: sql server 2016
Rating:  Rate this |   Briefcase | 8,645 reads

Questions About SQL Server Security and Access Control You Were Too Shy to Ask

For many developers, database security and Access control is just something that gets in the way of development work. However, several recent security breaches have had devastating consequences and have caused a change in attitude about the value to any organisation of having database applications that meet industry standards for access control and security. The problem, however is in admitting that you have a problem and finding answers to those problems you are just too shy to ask in public.  Read more...
By Additional Articles 2017/01/05 | Source: SimpleTalk | Category: sql server security
Rating:  Rate this |   Briefcase | 6,407 reads

Questions About the Use of PowerShell That you were Too Shy to Ask

Let's forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did it come from? Why did it take so long to arrive? These and many other basic questions are answered in William Brewer's latest addition to the series that answers those seemingly simple questions that you were too shy to ask in public.  Read more...
By Additional Articles 2017/02/22 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 5,643 reads

Planning for Successful Data Management

It is the data, in particular, that sets Database Lifecycle Management apart from the mainstream of application delivery. Data entities, and the way that organisations understand and deal with them, have their own lifespan. If we neglect the management of data, we risk disaster for the organisations that use it. If we take data management seriously, databases become a lot easier.  Read more...
Rating:  Rate this |   Briefcase | 4,775 reads

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 | 7,397 reads

How to Fix Ten SSDT Deployment Snags, With or Without ReadyRoll

Even a database development framework like Sql Server Data Tools (SSDT) doesn't get it right all the time, and there are ten deployment 'gotchas' in particular that can cause some head-scratching amongst developers to get right. From his unique perspective of creating a tool to make such deployments in SSDT less stressful, Dan Nolan discusses each pitfall and how to avoid it, whether you have ReadyRoll or not.  Read more...
By Additional Articles 2016/12/20 | Source: SimpleTalk | Category: ssdt
Rating:  Rate this |   Briefcase | 5,622 reads

Hyper-V and PowerShell: The Basics

Because it is important with maintaining Virtual Machine environments to be able to repeat routine tasks completely accurately, Windows PowerShell has grown in importance for the job. Now you can manage the Hyper-V environment via PowerShell without needing to use the Hyper-V Manager console. It opens up many opportunities for automation.  Read more...
By Additional Articles 2017/01/27 | Source: SimpleTalk | Category: hyper-v
Rating:  Rate this |   Briefcase | 4,921 reads

Your Professional Development and the PASS Organization

There are so many ways of keeping your technical skills and knowledge up-to-date. There are books, articles, conferences, video courses and so on, but nothing beats discussion and debate with professional people in other organisations facing a similar range of technical challenges, some of which you share, and others you maybe haven't yet. PASS is unique in providing just this vital ingredient for database professionals using the Microsoft Data Stack.  Read more...
By Additional Articles 2016/12/12 | Source: SimpleTalk | Category: pass
Rating:  Rate this |   Briefcase | 5,403 reads

How to Build Your First SQL Server Virtual Lab in Windows Azure

If you are a DBA who hasn't so far dived in head-first into using Azure, it is worth setting up an Azure 'Virtual Lab' environment the easy way, using a template. This will then allow you to experiment, try things out with SQL Azure, and get familiar with Resource Groups. Joshua shows how to build a virtual lab, from the ground up in the first of a series that aims to give you a grounding in Azure.  Read more...
By Additional Articles 2017/02/13 | Source: SimpleTalk | Category: azure
Rating:  Rate this |   Briefcase | 4,175 reads

Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data

SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very effective way of doing this. In the first in a series of articles on the theme of SQL Server Encryption, Robert Sheldon once more makes it all seem easy.  Read more...
By Additional Articles 2017/02/27 | Source: SimpleTalk | Category: encryption
Rating:  Rate this |   Briefcase | 4,139 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 | 7,322 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 | 6,269 reads

Who the Devil Wrote This SQL Code?

The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your work. It is never a good experience to see SQL Code, cry out “Who the devil wrote this code?”, and then realise that it was you. Grant gives some examples of bad formatting and explains why you should never check-in badly-formatted SQL code.  Read more...
By Additional Articles 2016/11/29 | Source: SimpleTalk | Category: formatting
Rating:  Rate this |   Briefcase | 5,561 reads

PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server

Aaron Nelson explains how you can take an existing SQL query, run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers.  Read more...
By Additional Articles 2017/02/03 | Source: MSSQLTips.com | Category: powershell
Rating:  Rate this |   Briefcase | 3,855 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 | 8,229 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 | 6,780 reads

Using SQL SERVER and Cloud Hosted Databases with OBIEE 11g

If your organisation is committed to using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g /12c as their BI solution, you aren't thereby committed to using Oracle throughout your organisation. You can use a range of data sources including SQL Server, and save a great deal of money by doing so. Sadly, Oracle will only support the use of the venerable SQL Server 2008 R2. Zafar Ali demonstrates how to connect OBIEE to the world beyond Oracle.  Read more...
By Additional Articles 2017/02/24 | Source: SimpleTalk | Category: business intelligence (bi)
Rating:  Rate this |   Briefcase | 3,647 reads

How to Get the Output of a Stored Procedure into a Table

Putting the output of a stored procedure into a table provides you multiple options for parsing and using the output with other TSQL commands. Read on to learn more.  Read more...
By Additional Articles 2016/11/30 | Source: Database Journal | Category: stored procedure
Rating:  Rate this |   Briefcase | 9,126 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: SQLServerCentral.com | Category: over clause
Rating: |  Discuss |   Briefcase | 22,684 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 | 5,082 reads