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

   Items 1 to 20 of 15481    Older >>
 

Stairway to Exploring Database Metadata Level 7: Extended Properties

In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.   Read more...
By Phil Factor 2017/02/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 155 reads

Byte Me: Compilation Vacation

By Bob Lang 2017/02/22 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 9 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 | 743 reads

In Search of Elasticity

An Evaluation of the Azure SQL Database Ecosystem.  Read more...
By Alex Chamchourine 2017/02/21 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 652 reads

Getting Started with Azure SQL Data Warehouse - Part 1

As the demand for data analytics grows so does the need for a technology or platform to process large amounts of different types of data in timely manner. Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just a few minutes. Read on to learn more about this data warehouse-as-a-service offering from Microsoft.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,203 reads

Why Object Databases will always be Tomorrow's Technology

For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?  Read more...
By Tony Davis 2017/02/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 366 reads

Back to Basics: Capturing Baselines on Production SQL Servers

If you have not been capturing baselines on your production servers, then today is the day you can start. This article provides scripts, valid for SQL Server 2005 and higher, which anyone can use to capture basic information about a SQL Server instance.  Read more...
By Erin Stellato 2017/02/20 (first published: 2012/11/27) | Source: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 29,576 reads

Lots of Learning at SQL Bits

Steve Jones is getting excited about learning at SQL Bits 2017.  Read more...
By Steve Jones 2017/02/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

New CREATE OR ALTER statement in SQL Server 2016 SP1

Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.  Read more...
By Additional Articles 2017/02/20 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,977 reads

Extending DevOps practices to SQL Server databases

In this free webinar, Steve Jones and Arneh Eskandari show how Redgate’s Database DevOps solution works with Visual Studio Team Services to improve your database delivery process. Register now.  Read more...
By 2017/02/20 (first published: 2017/02/15) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,997 reads

Using EXCEPT to Determine Row Differences

How to use the EXCEPT statement to perform row differences.  Read more...
By M. Douglas Bowan II 2017/02/17 (first published: 2014/03/25) | Source: SQLServerCentral.com | Category: except
Rating: |  Discuss |   Briefcase | 33,089 reads

Introduction to SAP HANA on Azure

Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, this trend has been exemplified by advancements in support for SAP-based solutions on Microsoft Azure. Marcin Policht provides an overview, focusing in particular on support for SAP HANA on Azure.  Read more...
By Additional Articles 2017/02/17 | Source: Database Journal | Category: sap hana
Rating: (not yet rated)  Rate this |   Briefcase | 2,163 reads

What motivates you to do your best?

In today's guest editorial: the motivation to do our best must come from within.  Read more...
By Ben Kubicek 2017/02/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 62 reads

vCenter Server fails to start, Purge and Shrink Vcenter SQL Database

In this article, you will learn how to troubleshoot If your vCenter Server fails to start and and manually purge the Vcenter database if required.  Read more...
By Ganapathi varma Chekuri 2017/02/16 | Source: SQLServerCentral.com | Category: vcenter
Rating: |  Discuss |   Briefcase | 78 reads

Framework Fatigue

Today we have a guest editorial that asks how do you deal with technology churn?  Read more...
By Gary Varga 2017/02/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 68 reads

Data masking survey and prize draw

The Foundry team at Redgate know that managing sensitive and regulated data can be both challenging and problematic. They want to solve these problems, but first need your help to better understand them in context. What do you find frustrating? What would save you time? Please fill out this short survey to let them know, and as a thanks for your time, at the end you'll be entered into a draw to win a $100 Amazon gift card.  Read more...
By 2017/02/16 (first published: 2017/02/10) | Source: Redgate | Category: survey
Rating:  Rate this |   Briefcase | 2,880 reads

Lists With, or Without, Ranges in both T-SQL and PowerShell

Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.  Read more...
By Additional Articles 2017/02/16 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,946 reads

SQL Server vs SQL Server v.Next

An introduction to the basics of current SQL Server vs v.Next Performance Testing.  Read more...
By Henrico Bekker 2017/02/15 | Source: SQLServerCentral.com | Category: vnext
Rating: |  Discuss |   Briefcase | 1,911 reads

What Would You Do if Your Company Was Targeted?

Today we have a guest editorial that asks what you might do if you knew a hacker was coming after your organization.  Read more...
By Andy Warren 2017/02/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads
   Items 1 to 20 of 15481    Older >>