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

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

Why is My Database Application so Slow?

When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that some of the more extravagant delays can be fairly blamed on a missing index or unnecessary locking, but there are other potential villains in the drama, including the network and the application itself. Dan Turner points out that you could save a lot of time and money by working out for sure where the problems lie before diving into the detail.  Read more...
By Additional Articles 2017/11/02 | Source: SimpleTalk | Category: performance
Rating:  Rate this |   Briefcase | 4,697 reads

What are the leading DevOps drivers in financial services?

DevOps is gaining ground everywhere. By offering a route to releasing software faster, with fewer errors, it can give companies which adopt it an immediate advantage. Unfortunately, it’s not something you can just buy or decide to do tomorrow. Instead, it’s a shift that needs the right guidance to become reality.  Read more...
By 2017/11/02 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,260 reads

Stairway to AlwaysOn Level 3: Infrastructure 101

In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2017/11/01 (first published: 2014/10/29) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 6,667 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2017/11/01 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 88,506 reads

Does Your Work Attire Really Make a Difference?

Does what you wear to work affect how you feel?  Read more...
By Ben Kubicek 2017/11/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

Live Query Plans and Blocking

Erik Darling looks at how SQL Server 2016's live query plans react when they're blocked.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,728 reads

Halloween 2017

It's a holiday in the US and Steve has a few thoughts.  Read more...
By Steve Jones 2017/10/31 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

Create SSRS Data Driven Subscriptions on Standard Edition

This will allow you to create "Data-Driven" subscriptions on your Standard SQL Server version.  Read more...
Rating: |  Discuss |   Briefcase | 798 reads

Six Scary SQL Surprises

The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially true if the DBA is not checking and monitoring the databases for obvious things such as database corruption, and disk space. However, the really scary surprises are less obvious and provide fewer warning signs. Brent Ozar gives six scary surprises that can be avoided by the shrewd DBA.  Read more...
By Additional Articles 2017/10/31 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 6,011 reads

Parse Data from a Field Containing Multiple Values using CROSS APPLY

It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.  Read more...
By Stan Kulp 2017/10/30 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 1,536 reads

Templates and Snippets in SSMS and SQL Prompt

Phil Factor provides an overview and comparison of SSMS templates, SSMS snippets, and SQL Prompt snippets.  Read more...
By 2017/10/30 | Source: Redgate | Category: snippets
Rating: (not yet rated)  Rate this |   Briefcase | 3,743 reads

How Far are You Willing To Go To Get Something?

There are important things in life and in our career, how far are you willing to go to get them?  Read more...
By Ben Kubicek 2017/10/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

Backup SQL Server Databases in Parallel with PowerShell

I have a need to decrease the time my SQL Server database backups are taking to run. I thought about trying to run multiple backups at the same time to see if that would work. I could have created multiple SQL Server Agent Jobs to run at the same time, but I wanted a more dynamic way to handle this, so I created a PowerShell script that allows processes to run in parallel.  Read more...
By Additional Articles 2017/10/30 | Source: MSSQLTips.com | Category: parallel processing
Rating: (not yet rated)  Rate this |   Briefcase | 3,010 reads

Adding Time Intelligence to a Power BI Data Model

In this article I want to provide an introduction to the vital set of functions that help you to use a time element when analyzing data  Read more...
By Adam Aspin 2017/10/27 (first published: 2016/06/06) | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 2,458 reads

Physical or Virtual Storage

This week Steve Jones talked about physical hardware, asking who might still pay attention.  Read more...
By Steve Jones 2017/10/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

The SQL Server Features that Time Forgot

Every new release of SQL Server comes with new features that cause a ripple of excitement within the industry: well, amongst the marketing people anyway. What happens to all the exciting TLAs that are bandied about when a new version launches? It's mixed, it seems. Adam Machanic's classic post, The SQL Hall of Shame, has inspired Rob Sheldon to look back at some of the features that, though worthy, have may have failed to hit the mainstream.  Read more...
By Additional Articles 2017/10/27 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 5,326 reads

Extracting a DAX Query Plan With Analysis Services 2016 Extended Events

In this post, Koen Verbeeck shows how to use SQL Sever 2016's Extended Events to find the query plan for a DAX query, just like you would for a T-SQL statement.  Read more...
By Additional Articles 2017/10/27 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,627 reads

Unstructured Data

Unstructured data can be misleading. Steve Jones has a few thoughts today on how he sees this term.  Read more...
By Steve Jones 2017/10/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

Distributed Computing Principles and SQL-on-Hadoop Systems

A look at SQL-On-Hadoop systems like PolyBase, Hive, Spark SQL in the context Distributed Computing Principles and new Big Data system design approach like the Lambda Architecture.  Read more...
By Frank A. Banin 2017/10/26 | Source: SQLServerCentral.com | Category: distributed computing
Rating: |  Discuss |   Briefcase | 527 reads
<< Newer    Items 61 to 80 of 16278    Older >>