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

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

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,829 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,361 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 | 38 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,410 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 | 233 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 | 133 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,199 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 | 1,895 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 | 746 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,025 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,362 reads

The Giving Back Workload

Volunteering is a good thing for us to do, but it can be overwhelming at times.  Read more...
By Steve Jones 2019/01/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

"Surely this one will get a clustered index scan."

In which SQL Server stubbornly insists on doing key lookups way, way past the tipping point.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,712 reads

Workplace Encounter: Effects of TLS 1.2

In this article we share a recent experience we had with implementing TLS 1.2 ONLY support on our databases and particularly with respect to its effect on Transaction Log Shipping sessions.  Read more...
Rating: |  Discuss |   Briefcase | 732 reads

Lack of Memory

It seems that many SQL Servers can be lacking memory. Adding more is one way to improve performance, but Steve has other ideas.  Read more...
By Steve Jones 2019/01/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 87 reads

Working with SQL Server Stored Procedures and .NET

Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.  Read more...
By Additional Articles 2019/01/03 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,644 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.   Read more...
By Additional Articles 2019/01/03 | Source: SimpleTalk | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,937 reads

Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)

With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 174 reads

Thinkers and Doers

Steve wonders if having an organizational architect is a good idea.  Read more...
By Steve Jones 2019/01/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 71 reads
<< Newer    Items 21 to 40 of 17536    Older >>