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

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

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2016/09/14 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 27,360 reads

Best Practices For Building Alerts for Using APIs with SQL Server

Tim Smith shares some ideas about how to handle and alert on irregular data coming from APIs when loading your database.  Read more...
By Additional Articles 2016/09/14 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 3,072 reads

Encryption Keys Matter

Protecting the keys used for encrypion can really matter for companies, and in today's complex world, that can be difficult. Monitoring becomes important to helping here.  Read more...
By Steve Jones 2016/09/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 55 reads

Restore Gene Version 6 - User Guide

Read about the Restore Genie and the new support for fork points, Azure and Multiple Concurrent Restores.   Read more...
By Paul Brewer 2016/09/13 | Source: | Category: restore genie
Rating: |  Discuss |   Briefcase | 733 reads

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,413 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,473 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,305 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,568 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,135 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,637 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,227 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 | 976 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,305 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,232 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
<< Newer    Items 41 to 60 of 15078    Older >>