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

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

Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions

In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.  Read more...
By Gregory Larsen 2017/07/14 (first published: 2015/09/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,387 reads

Cool Projects

This week Steve Jones wants to know what type of really interesting projects you are working on. Is there something you really enjoy and look forward to building?  Read more...
By Steve Jones 2017/07/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 228 reads

Deploying, Securing, and Updating Power BI Reports

Before Excel and other data-linked spreadsheets, business reports needed to be hand-crafted by IT experts, and changes were arbitrated slowly via change control. Power BI was designed to take the liberation that Excel pioneered to the max, by allowing 'power' users to not only to create Power BI desktop reports, graphics and visualisations in Power BI App, but then link and publish these to the Power BI app. These in turn can be given row level security and have their underlying data kept up-to-date so that users can log in and see the relevant and appropriate data in a browser. Saurabh Desai shows how.  Read more...
By 2017/07/14 | Source: SimpleTalk | Category: power bi
Rating:  Rate this |   Briefcase | 2,473 reads

What do you do when you make a mistake?

We all make mistakes, what you do next is what is important.  Read more...
By Ben Kubicek 2017/07/13 | Source: SQLServerCentral.com | Category: mistake
Rating: (not yet rated) |  Discuss |   Briefcase | 48 reads

Power BI - Rename Table Column headings

Trick to rename column headings on a Power BI Table visual  Read more...
By Daniel Taylor 2017/07/13 | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 475 reads

Performance Myths: Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.  Read more...
By Additional Articles 2017/07/13 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 4,732 reads

Free prototype tool to audit SQL Server permissions

Redgate have just released SQL Census, a prototype tool from the Foundry division that makes auditing SQL Server user access permissions much easier. In this post Ally Parker shows how it works, tells us what's up next in the tool's development development, and explains how you can download it for free.  Read more...
By 2017/07/13 | Source: Redgate | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 3,192 reads

Unlimited PTO

A guest editorial from Andy Warren looking at the unlimited amount of vacation time from his company.  Read more...
By Andy Warren 2017/07/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads

Stairway to DAX and Power BI - Level 8: The DAX COUNT() and COUNTX() Functions

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() 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 counts to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2017/07/12 (first published: 2015/01/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,874 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 2017/07/12 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 93,259 reads

SQL Server DBA On-Boarding Checklist

How can we be sure that the new DBAs are productive a soon as possible? How can we use highly qualified contractors in the most effective way from day one?  Read more...
By Additional Articles 2017/07/12 | Source: MSSQLTips.com | Category: dba
Rating: (not yet rated)  Rate this |   Briefcase | 2,956 reads

How do you go about team building?

Team building isn't easy, but important for people to work together well.  Read more...
By Ben Kubicek 2017/07/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 46 reads

Batch SSIS pkg execution from Business Intelligence Development Studio

The Execute Package Task and a second instance of Business Intelligence Development Studio can be a satisfactory method of background execution of SSIS packages in batch mode when you don't have access to Integration Services.  Read more...
By Stan Kulp 2017/07/11 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 691 reads

Continuous Database Deployment with Confidence

To achieve gains from Database Lifecycle Management in general, and in Continuous Deployment in particular, it pays to aim for lightweight but consistent techniques and processes, refining them iteratively in the light of experience. Edward Elliott describes a Test-driven development process for developing SQL Server databases that worked for CD, based on a series of steps. Though the tools for CD may be necessary, they are not sufficient, without an effective structured process.  Read more...
By Additional Articles 2017/07/11 | Source: SimpleTalk | Category: continuous deployment (cd)
Rating:  Rate this |   Briefcase | 2,621 reads

Top 10 DevOps Operational Requirements

One of the key tenets in DevOps is to involve the Operations team in the full software development lifecycle and, in particular, to ensure that operational requirements are incorporated into the design and build phases.  Read more...
By Additional Articles 2017/07/11 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,744 reads

Birds of a Feather

What makes SQL Server professionals stick together? Can we draw any conclusions from this?  Read more...
By Hakim Ali 2017/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

Azure DWH part 10: WPF and Azure SQL Data Warehouse

In this article, we will show how to create a WPF application ans show how to insert data to ASDW.  Read more...
Rating: |  Discuss |   Briefcase | 368 reads

The Panjandrum Conundrum

With progress thwarted by a committee of panjandrums, will T-SQL forever remain in the doldrums? So wonders Phil Factor.  Read more...
By Phil Factor 2017/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 64 reads

What You Need To Know About DR Testing

Practice makes perfect. That’s true of everything, including disaster recovery. If you aren’t already testing your DR plan, you should be - here’s what you need to know to get started.  Read more...
By Tim Mullahy 2017/07/10 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 385 reads

Introduction to Azure SQL Datab Sync

The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Preview since its introduction 7 years ago. Fortunately, there are signs that this service might be finally reaching production-ready state. In this article, Martin Pollicht introduces its main characteristics.  Read more...
By Additional Articles 2017/07/10 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,219 reads
<< Newer    Items 21 to 40 of 15921    Older >>