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

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

Direct Query with Power BI

Power BI allows you to connect directly to the data just as if it were a “standard” connection, and modify and extend the data to support analytics. By using DirectQuery, you can build reports based on extremely large datasets where re-importing data not a practical solution. It also allows you to do data aggregations on the server. There are, of course, restrictions as well but it is nevertheless a worthwhile technique to use where appropriate. Adam Aspin explains all.  Read more...
By Additional Articles 2016/09/13 | Source: SimpleTalk | Category: bi
Rating:  Rate this |   Briefcase | 3,401 reads

Ignoring Database Version Control

Steve Jones thinks version control is important, even for databases.  Read more...
By Steve Jones 2016/09/12 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 90 reads

Creating Partition on Existing tables and Rolling Partitions

this article describes about creating partitions on our existing Tables and also gives details about how to create rolling partition to support new data  Read more...
By Avinash Gunjuluri 2016/09/12 | Source: | Category: partition
Rating: |  Discuss |   Briefcase | 1,468 reads

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 | 77 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,286 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,564 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 | 242 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,128 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,628 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,225 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 | 957 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 | 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,303 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,228 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,091 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,241 reads
<< Newer    Items 41 to 60 of 15074    Older >>