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

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

Using SQL Compare with Row Level Security

Row Level Security is one of many new features in SQL Server 2016. It provides a much easier, consistent, and maintainable solution for row-based security rules. In this blog post, Data Platform MVP Steve Jones introduces this new feature, and walks through how Redgate SQL Compare can safely and reliably handle RLS changes.   Read more...
By Additional Articles 2016/09/15 | Source: Redgate | Category: sql compare
Rating: (not yet rated)  Rate this |   Briefcase | 2,496 reads

Free Webinar: Redgate DLM Demo

Learn how to use Redgate’s DLM solution to improve your database change management process in this free webinar on September 20th. Microsoft Data Platform MVPs, Steve Jones and Grant Fritchey, will demonstrate how Redgate’s tools plug into Visual Studio Online so that you can build, test and deploy your database alongside your application code. Register now.  Read more...
By 2016/09/20 (first published: 2016/09/15) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,158 reads

Stairway to U-SQL Level 8: Joining Tables in U-SQL

U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.  Read more...
By Mike McQuillan 2016/09/14 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,386 reads

Down Tools Week 2016

Last week Steve Jones participated in the Down Tools Week at Redgate Software.  Read more...
By Steve Jones 2016/09/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

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,418 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: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 3,104 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 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: SQLServerCentral.com | Category: restore genie
Rating: |  Discuss |   Briefcase | 738 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,420 reads

Ignoring Database Version Control

Steve Jones thinks version control is important, even for databases.  Read more...
By Steve Jones 2016/09/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 91 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: SQLServerCentral.com | Category: partition
Rating: |  Discuss |   Briefcase | 1,509 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 78 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,310 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: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 12,571 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 244 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: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 4,139 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 92 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: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 3,658 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,232 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 | 993 reads
<< Newer    Items 41 to 60 of 15082    Older >>