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

   Items 1 to 20 of 15492    Older >>
 

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 | 252 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 | 547 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 16 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 14 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 | 680 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: SQLServerCentral.com | Category: active directory
Rating: |  Discuss |   Briefcase | 3,110 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 | 2,131 reads

The Multilingual Programmer

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

SQL Server Trace Flags - Complete list

Article in markdown format: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md  Read more...
By Konstantin Taranov 2017/02/23 | Source: SQLServerCentral.com | Category: trace-flag
Rating: |  Discuss |   Briefcase | 1,352 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 65 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 | 6,015 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 634 reads

Byte Me: Compilation Vacation

By Bob Lang 2017/02/22 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 42 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 | 4,259 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 | 800 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 | 3,514 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 | 399 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,800 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 | 62 reads
   Items 1 to 20 of 15492    Older >>