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

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

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,450 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,305 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,616 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 | 521 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,874 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,811 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 | 97 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,049 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,612 reads

SQL Server R Services: Working with ggplot2 Statistical Graphics

It is when you use R in SQL Server with one of the huge range of packages that comes with it that you can begin to appreciate the power of the system. With a package such as ggplot there are many 'knobs one can twiddle' in order to get spectacular and informative visualisations. Rob Sheldon continues his beginners series for R in SQL Server by showing how to refine the output to get it as you need it.  Read more...
By Additional Articles 2017/10/25 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 2,768 reads

Improved parentheses formatting in SQL Prompt 8.1

The SQL Prompt team have made some improvements to parentheses formatting in the latest version of the tool - here are the details of what's changed and why.  Read more...
By 2017/10/25 | Source: Redgate | Category: formatting
Rating: (not yet rated)  Rate this |   Briefcase | 2,822 reads

Gigging for a Career

The idea of working on just projects is tailor made for a data professional. Or is it?  Read more...
By Steve Jones 2017/10/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Parameter Sniffing In Action

This article will demonstrate what is parameter sniffing and how can it can kill performance   Read more...
By Nisarg Upadhyay 2017/10/24 | Source: SQLServerCentral.com | Category: parameter sniffing
Rating: |  Discuss |   Briefcase | 1,388 reads

A Freecon Halloween at the PASS Summit

If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend.  Read more...
By Press Release 2017/10/24 (first published: 2017/10/13) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 380 reads

How to determine SQL Server database transaction log usage

One crucial aspect of all databases is the transaction log. The transaction log is used to write all transactions prior to committing the data to the data file. In some circumstances the transaction logs can get quite large and not knowing what is in the transaction log or how much space is being used can become a problem. So how to you determine how much of the transaction log is being used and what portions are being used?  Read more...
By Additional Articles 2017/10/24 | Source: MSSQLTips.com | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 3,719 reads

All DevOps All Day

An online DevOps conference is taking place tomorrow, October 24, 2017.  Read more...
By Steve Jones 2017/10/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

Azure DWH part 19: Backup and Restore SSAS

In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.  Read more...
By Daniel Calbimonte 2017/10/23 | Source: SQLServerCentral.com | Category: ssas
Rating: |  Discuss |   Briefcase | 241 reads

Tell the Judge You Have No Backup

The NYPD is claiming there isn't a backup for one of their databases.  Read more...
By Steve Jones 2017/10/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads
<< Newer    Items 61 to 80 of 16264    Older >>