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

<< Newer    Items 61 to 80 of 15558    Older >>

Stairway to U-SQL Level 13: SQL.MAP

We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.  Read more...
By Mike McQuillan 2017/03/01 | Source: | Category: u-sql
Rating: |  Discuss |   Briefcase | 866 reads

Detecting Issues

How do you detect issues in your systems? Testing? Monitoring? Steve Jones has a few thoughts that we should find ways to do so before our customers.  Read more...
By Steve Jones 2017/03/01 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 86 reads

DevOps and “Shift Left” for Databases

The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to use the term ‘shift-left’. By performing, or at least preparing for, all the processes and tasks that are necessary for deployment as soon as possible in the development cycle, it is possible to move from big, infrequent releases to “little and often”. Stephanie Herr explains how ‘shifting left’ can get deployment pipelines moving.  Read more...
By Additional Articles 2017/03/01 | Source: SimpleTalk | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 4,629 reads

In-Place Upgrade or Migration

To upgrade or migrate, that is the question. And I have an answer.  Read more...
By Jim Youmans 2017/02/28 | Source: | Category: sql
Rating: |  Discuss |   Briefcase | 1,173 reads

One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.  Read more...
By Additional Articles 2017/02/28 | Source: | Category: index
Rating:  Rate this |   Briefcase | 5,164 reads

Containers and Databases

Steve Jones comments on containers and their suitability for databases.  Read more...
By Steve Jones 2017/02/28 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 105 reads

Performance Dashboard Error: Could not find stored procedure

In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.  Read more...
Rating: |  Discuss |   Briefcase | 770 reads

The Last Week for SQL Bits 2017 Discounts

This is the last week for a discounted registration to SQL Bits 2017. The price goes up after Mar 4, so register today.  Read more...
By Press Release 2017/02/27 | Source: SQLBits | Category: sqlbits
Rating: (not yet rated)  Rate this |   Briefcase | 2,723 reads

Human and Machine Learning

Machine learning and AI are becoming more and more prevalent, which Steve Jones thinks is good.  Read more...
By Steve Jones 2017/02/27 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

The Secure Medical Data Challenge

This week Steve looks at the challenges of security for medical data.  Read more...
By Steve Jones 2017/02/27 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 63 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,140 reads

Enumerate Windows Group Members

Here a quick script showing how to get all the Active Directory users in a AD group.  Read more...
By Lowell Izaguirre 2017/02/24 (first published: 2016/03/17) | Source: | Category: active directory
Rating: |  Discuss |   Briefcase | 3,418 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,648 reads

The Multilingual Programmer

Steve looks back at the languages he's learned this week.  Read more...
By Steve Jones 2017/02/24 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 78 reads

The Cloud is Just a Tool

Today Steve Jones argues the cloud is just another tool for us to use. Not required, not ignored, but considered.  Read more...
By Steve Jones 2017/02/23 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 83 reads

SQL Server Trace Flags - Complete list

This article is a complete list of all SQL Server trace flags.  Read more...
By Konstantin Taranov 2017/02/23 | Source: | Category: trace-flag
Rating: |  Discuss |   Briefcase | 2,091 reads

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.  Read more...
By Additional Articles 2017/02/23 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 7,729 reads

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: | Category: stairway series
Rating: |  Discuss |   Briefcase | 798 reads

Byte Me: Compilation Vacation

By Bob Lang 2017/02/22 | Source: | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 50 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,646 reads
<< Newer    Items 61 to 80 of 15558    Older >>