SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 21 to 40 of 17544    Older >>
 

Do you have a security to-do list?

Security is important, and Steve wonders if any of us have a list of things we do that improve security.  Read more...
By Steve Jones 2019/01/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 43 reads

Two Things I Would Change in SSISDB Setup

I suggest these two changes to the SSISDB setup to prevent issues down the road.  Read more...
By Ben Kubicek 2019/01/11 (first published: 2016/03/29) | Source: SQLServerCentral.com | Category: ssisdb
Rating: |  Discuss |   Briefcase | 3,488 reads

Never Judge A Query By Its Cost

Erik shows an example where lower-cost queries take longer to run.  Read more...
By Additional Articles 2019/01/11 | Source: Brent Ozar Unlimited Blog | Category: query
Rating: (not yet rated)  Rate this |   Briefcase | 3,083 reads

Manage Data Across Multiple Sources with Azure Data Studio

Azure Data Studio, now the official name of SQL Operations Studio, was released in September. The biggest news regarding the release is the extensions that are now available, as Julie Lerman describes.  Read more...
By Additional Articles 2019/01/11 | Source: Microsoft MSDN | Category: azure data studio
Rating: (not yet rated)  Rate this |   Briefcase | 2,023 reads

Badly Trained AI

An Amazon AI system doesn't quite work as expected.  Read more...
By Steve Jones 2019/01/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 64 reads

The Basics of iTVFs

Learn the basics of inline table valued functions in this short article.  Read more...
By Steve Jones 2019/01/10 | Source: SQLServerCentral.com | Category: itvf
Rating: |  Discuss |   Briefcase | 1,007 reads

SSRS Reporting Basics: When is SSRS the Right Tool?

SSRS has undergone a number of changes over the past few versions. It remains a very popular reporting tool in companies large and small. In this article, Eugene Meidinger recounts the history of SSRS and explains when it’s the best tool to use. This is the first article of a series on SSRS.  Read more...
By Additional Articles 2019/01/10 | Source: SimpleTalk | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 3,704 reads

Introducing Azure SQL Database Hyperscale

With Azure SQL Database Hyperscale, databases can quickly auto-scale up to 100TB, eliminating the need to pre-provision storage resources, and significantly expand the potential for app growth without being limited by storage size.  Read more...
By Additional Articles 2019/01/10 | Source: Microsoft MSDN | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,049 reads

Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

As a part of his "Function / Iterator Pairs" mini-series, Business Intelligence architect, Analysis Services Maestro, SQL Server MVP, and author Bill Pearson introduces the DAX MAX() and MAXX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating "largest numeric values" to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2019/01/09 (first published: 2015/01/14) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,842 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2019/01/09 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 52,529 reads

Is Failure Allowed?

Failure is one of the ways we get better as software developers. Does that apply to DBAs?  Read more...
By Steve Jones 2019/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Getting Started with GitHub for SQL Server Developers

Learn some of the basics of GitHub and how this can be utilized for your SQL Server development projects.  Read more...
By Additional Articles 2019/01/09 | Source: MSSQLTips.com | Category: github
Rating: (not yet rated)  Rate this |   Briefcase | 2,653 reads

Azure DWH part 29: MicroStrategy Desktop with Azure

In this article, we will show how to connect MicroStrategy Desktop with ASDW.   Read more...
By Daniel Calbimonte 2019/01/08 | Source: SQLServerCentral.com | Category: microstrategy
Rating: |  Discuss |   Briefcase | 235 reads

MY Data

As we gather more and more data about individuals, not only does security become an issue, but also the morality of using the data.  Read more...
By Steve Jones 2019/01/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 134 reads

Factors Behind Successfully and Repeatedly Executing Digital Transformation Programs at a Lightning Pace

IT transformation projects often fail due to poor planning, poor communication and more. In this article, Mohammad Rizvi explains how to be successful and give your customer a great experience.  Read more...
By Additional Articles 2019/01/08 | Source: SimpleTalk | Category: .net
Rating: (not yet rated)  Rate this |   Briefcase | 2,424 reads

Azure Data Explorer

Read this white paper to get a better understanding of the architecture and technology powering Azure Data Explorer, a fast and highly scalable data exploration service.  Read more...
By Additional Articles 2019/01/08 | Source: Microsoft MSDN | Category: azure data explorer
Rating: (not yet rated)  Rate this |   Briefcase | 2,106 reads

Keep Column Headers Visible in SSRS

Keep column headers visible while scrolling down the page of SSRS reports.   Read more...
By Ginger Keys Daniel 2019/01/07 | Source: SQLServerCentral.com | Category: reporting services
Rating: |  Discuss |   Briefcase | 759 reads

Bootstrap 4 and Self-validating Forms

Validating the user input of a web form is important for security and data quality. In this article, Dino Esposito explains how to validate a form and add undo capability with Bootstrap 4.  Read more...
By Additional Articles 2019/01/07 | Source: SimpleTalk | Category: .net
Rating: (not yet rated)  Rate this |   Briefcase | 2,264 reads

Synonyms

Synonyms can be very useful depending on your database and object naming scheme.  Read more...
By Ben Kubicek 2019/01/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

Understanding Peer-to-Peer Transactional Replication, Part 3

We've gone through the basics of Peer-to-Peer Transactional Replication (PPTR). Now, we will blow it up! We will then fix it and show you how you how to triage and repair PPTR. When you remain calm and take some easy steps, you can stabilize PPTR with ease.  Read more...
By John F. Tamburo 2019/01/04 (first published: 2016/01/07) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,364 reads
<< Newer    Items 21 to 40 of 17544    Older >>