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

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

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: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 3,688 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,242 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,005 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 361 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,315 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,242 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: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 594 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: SQLServerCentral.com | 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: SQLPerformance.com
Rating: (not yet rated)  Rate this |   Briefcase | 3,098 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: SQLServerCentral.com | 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: SQLServerCentral.com | Category: qr code
Rating: |  Discuss |   Briefcase | 8,253 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,805 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 42 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: SQLServerCentral.com | Category: baseline
Rating: |  Discuss |   Briefcase | 11,135 reads

The Copy Cat Poll

This poll asks about copies, specifically those of your databases. How many do you keep around? How much extra storage does this cost? Steve Jones thinks that most organizations have quite a few copies, which can use a lot of resources.  Read more...
By Steve Jones 2016/09/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 146 reads

Master Data Management (MDM) Using SQL Server

So many of the problems that organisations have with their IT applications are due to the struggle with data, in the absence of overall organization-wide control and supervision of data and its progress through the various parts of the organization. Master data management (MDM) offers a solution to the many data woes by controlling data change, It does it in an analogous way to Version Control, so that changes are cleansed, checked, tracked and audited, and any named version can be published to other services. Now Microsoft has an implementation as part of the data platform.  Read more...
By Additional Articles 2016/09/02 | Source: SimpleTalk | Category: simple talk
Rating: (not yet rated)  Rate this |   Briefcase | 4,174 reads

Time Off

Finding a balance between work and life away from work is hard, but one good way is with periodic vacations. Today Steve Jones notes that some people don't take their vacation, which he sees as a problem.  Read more...
By Steve Jones 2016/09/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 243 reads

Get-SqlLogin and Remove-SqlLogin Are Here

Learn how to use the login commands included with SSMS2016 from PowerShell.  Read more...
By Aaron Nelson 2016/09/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,619 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 | 5,747 reads

Stairway to Columnstore Indexes Level 9: Batch Mode Execution

In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.  Read more...
By Hugo Kornelis 2016/08/31 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 726 reads
<< Newer    Items 61 to 80 of 15085    Older >>