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

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

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,719 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 | 795 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,003 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,532 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,739 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 | 52 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,005 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,455 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,319 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,623 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 | 525 reads

How to Hire a Junior DBA

Brent Ozar covers some questions you need to ask yourself before hiring a Junior DBA.  Read more...
By Additional Articles 2017/10/26 | Source: Brent Ozar Unlimited Blog | Category: hiring
Rating: (not yet rated)  Rate this |   Briefcase | 3,879 reads

SQL Monitor Quick Tip: Using the SQL static code analysis performance rules

This quick tip will review how SQL Monitor 7 has incorporated SQL Code Guard’s built-in set of Performance Rules for static code analysis. These rules are designed to highlight SQL syntax that could potential cause performance problems, and so indicate ways to improve the overall quality and performance of the workload, over time.  Read more...
By 2017/10/26 | Source: Redgate | Category: static code analysis
Rating: (not yet rated)  Rate this |   Briefcase | 2,812 reads

HA HA HA

Crossword puzzle focusing on high availability  Read more...
By Kenneth Fisher 2017/10/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 99 reads

Stairway to Database Design Level 5: Procedures

Joe Celko tackles the subject of the Stored Procedure and its place in database design. What he writes is food for thought, even for experienced database developers.  Read more...
By Joe Celko 2017/10/25 (first published: 2010/08/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,053 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 2017/10/25 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 85,618 reads
<< Newer    Items 61 to 80 of 16273    Older >>