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

<< Newer    Items 41 to 60 of 15071    Older >>

Teaching a dog to sing

To survive the inevitable downturns in the IT industry, Phil Factor argues that a IT manager needs to take time to maintain technical skills. It is not enough to understand development; you have to be able to do it.  Read more...
By Phil Factor 2016/09/12 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

Real-time Operational Analytics in SQL Server 2016 - Part 1

Arshad Ali takes a look at traditional analytics architecture, the challenges it faces, and how the newly introduced Real-time Operational Analytics feature overcomes those challenges.  Read more...
By Additional Articles 2016/09/12 | Source: Database Journal | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,229 reads

A Case FOR Cursors...

We've all heard that definitive statement: "Avoid using cursors." But, in my opinion, what really should be conveyed is: "Avoid using row-by-row operations when possible."  Read more...
By Chris Jones 2016/09/09 (first published: 2015/06/01) | Source: | Category: cursors
Rating: |  Discuss |   Briefcase | 12,552 reads

Impressive Accomplishments

What things impress you most about potential candidates. This week Steve Jones asks the question to try and understand what types of activities data professionals might consider.  Read more...
By Steve Jones 2016/09/09 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 241 reads

How to tell what SQL Server version you are running

Gerg Robidoux demonstrates a couple of methods for determining which version of SQL Server you're running, as well as what service pack or hotfix is installed.  Read more...
By Additional Articles 2016/09/09 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 4,101 reads

You know what we really need? Better interpersonal communication

Today we have a guest editorial as Steve is traveling. Ben Kubicek notes that sometimes it is hard for technical people to communicate well.   Read more...
By Ben Kubicek 2016/09/08 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 91 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: | Category: calendar
Rating: |  Discuss |   Briefcase | 3,594 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,220 reads

Stairway to Exploring Database Metadata Level 2: Using the Dynamic Online Catalog to Solve Problems

In this second level of the Stairway, Phil looks at where we go to find information about objects, using triggers as the example.  Read more...
By Phil Factor 2016/09/07 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 956 reads

Practicing Deployments

Amateurs practice until they can get something right. Professionals practice until they don't get things wrong. How should we handle our deployments?  Read more...
By Steve Jones 2016/09/07 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 360 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2016/09/07 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 85,295 reads

Introduction to SQL Server Stretch Database

In many cases Azure SQL Database offers an economically and functionally viable alternative to SQL Server deployments. However, there are also scenarios where we might discover that rather than serving as a replacement, it provides synergy, working side by side with your on-premises databases. One of technologies that illustrate this paradigm is Stretch Database, introduced in SQL Server 2016. Marcin Polichtdescribes its basic characteristics and reviews its implementation steps in this article.  Read more...
By Additional Articles 2016/09/07 | Source: Database Journal | Category: stretch database
Rating: (not yet rated)  Rate this |   Briefcase | 4,225 reads

Resolving an Error When Creating an Availability Group Listener

In this post, Iā€™m going to talk an issue that I found when creating an availability group listener by using SQL Server Management Studio's Add Listener. This article helps you to resolve the issue.   Read more...
By Ganapathi varma 2016/09/06 | Source: | Category: alwayson
Rating: |  Discuss |   Briefcase | 587 reads

Does Log Data Belong in a Table or a File?

Today we have a guest editorial that asks how one might want to manage all those logging metrics produced by applications.  Read more...
By Andy Warren 2016/09/06 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 67 reads

Minimizing impact of widening an IDENTITY column ā€“ part 4

Aaron Bertrand continues his series on widening an IDENTITY column, showing how he would attack the problem directly.  Read more...
By Additional Articles 2016/09/06 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 3,087 reads

NCAs and NDAs

When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice. (This editorial was originally published on Mar 12, 2008. It is being re-run as Steve is on holiday.)  Read more...
By Steve Jones 2016/09/05 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 251 reads

Generate two-dimensional QR Code® bar codes in an SSRS report

QR (Quick Response) Code® is the Denso Wave, Inc. trademark for a type of two-dimensional bar code designed for the automotive industry in Japan. The QR Code system has become popular outside the automotive industry due to its speed and greater storage capacity compared to standard UPC bar codes.  Read more...
By Stan Kulp 2016/09/05 (first published: 2014/01/14) | Source: | Category: qr code
Rating: |  Discuss |   Briefcase | 8,237 reads

The Exploratory Testing Chrome Plugin

If all your application testing is done by test experts, who know how to record images, do screen-capture, write issue-reports to TFS more appropriate and consistent format and so on, you probably don't need the 'Exploratory Testing' chrome plug-in. Otherwise, it is worth checking out Ambily KK's walkthrough.  Read more...
By Additional Articles 2016/09/05 | Source: SimpleTalk | Category: .net
Rating: (not yet rated)  Rate this |   Briefcase | 2,796 reads

Towards a Single Management Stack

Phil Factor argues that with both SQL Server and PowerShell now running on Linux, the latter becomes increasingly important in achieving the goal of a single management stack for databases across all hosting environments.  Read more...
By Phil Factor 2016/09/05 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 41 reads

Comprehensive Baseline Collector Solution (Updated)

There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution  Read more...
By Robert Virag 2016/09/02 (first published: 2014/10/21) | Source: | Category: baseline
Rating: |  Discuss |   Briefcase | 11,121 reads
<< Newer    Items 41 to 60 of 15071    Older >>