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

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

Byte Me: Earning in the Grave

By Bob Lang 2016/08/03 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Stairway to Exploring Database Metadata Level 1: Why Should You Care About the Dynamic Online Catalog?

In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.  Read more...
By Phil Factor 2016/08/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,197 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2016/08/03 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 71,078 reads

Create a SQL Server Reporting Services Report from an Analysis Services Tabular Database

Daniel Calbimonte walks through the steps to creating a SQL Server Reporting Services (SSRS) Report from an Analysis Services Tabular Database.  Read more...
By Additional Articles 2016/08/03 | Source: MSSQLTips.com | Category: ssrs
Rating:  Rate this |   Briefcase | 5,017 reads

Changing Replication Passwords

A how-to guide for configuring replication agents after a password change  Read more...
By Lucinda Young 2016/08/02 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 643 reads

Strengthening the Foundations of Software Architecture

The term 'Architecture' seems to imply a plan that you can't easily subsequently deviate from. It's true that, if you abandon software architecture, you end up with a big ball of mud, but maybe the art of software is to make change much easier by planning how to implement each feature, tackling dependency issues, splitting functionality into small discrete components and considering how they should interact with each other.  Read more...
By Additional Articles 2016/08/02 | Source: SimpleTalk | Category: architecture
Rating: (not yet rated)  Rate this |   Briefcase | 4,548 reads

Moving Fast at Redgate

It's possible to change a software development team and dramatically improve things. Steve Jones highlights an example from Redgate Software.   Read more...
By Steve Jones 2016/08/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

How to Run Scheduled Jobs in Azure SQL Databases

This article will help you to schedule jobs in Azure SQL.  Read more...
By Daniel Calbimonte 2016/08/01 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 736 reads

Introduction to Azure SQL Database Temporal Tables

As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.  Read more...
By Additional Articles 2016/08/01 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 4,059 reads

Adding Old Features?

Is Row Level Security a new feature? Or should MS work on improving old ones?  Read more...
By Phil Factor 2016/08/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 48 reads

Passwords Under Pressure

Passwords are a problem, especially when we're in a hurry. What should we do?  Read more...
By Steve Jones 2016/08/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 74 reads

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL injection attack.  Read more...
By Gregory Larsen 2016/07/29 (first published: 2014/07/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,469 reads

How Far Have You Traveled for a SQL Saturday?

This Friday Steve Jones talks SQL Saturdays and asks how far you've traveled to attend one.  Read more...
By Steve Jones 2016/07/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation

Simon Liew shows how to execute SQL Server DBCC SHRINKFILE without causing index fragmentation and example conditions that cause fragmentation.  Read more...
By Additional Articles 2016/07/29 | Source: MSSQLTips.com | Category: dbcc shrinkfile
Rating: (not yet rated)  Rate this |   Briefcase | 4,383 reads

Data Quality - Addressing non-stated requirements

Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.  Read more...
By David Poole 2016/07/28 | Source: SQLServerCentral.com | Category: data quality
Rating: |  Discuss |   Briefcase | 1,038 reads

A Real-World React.js Setup for ASP.NET Core and MVC5

React is a front-end user interface library developed by Facebook, originally to help them improve their own site. Since then it has grown into somewhat of a phenomenon, with many active users. In this article, Jon Smith provides multiple examples of how to use React with recently released ASP.NET Core MVC, and the existing ASP.NET MVC5 framework.  Read more...
By Additional Articles 2016/07/28 | Source: SimpleTalk | Category: .net
Rating: (not yet rated)  Rate this |   Briefcase | 2,996 reads

Too Much Information for Sports

Gathering too much data isn't always helpful, and doesn't necessarily help you make better decisions. However, that's up to you to decide how much is too much.  Read more...
By Steve Jones 2016/07/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Learning to Search

Today Steve Jones notes that the ability to search if invaluable as the amount of information, or even objects, we deal with grows.  Read more...
By Steve Jones 2016/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.  Read more...
By Mike McQuillan 2016/07/27 | Source: SQLServerCentral.com | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 328 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2016/07/27 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 76,845 reads
<< Newer    Items 61 to 80 of 14991    Older >>